Post reply

PBM - result_detail column in syspolicy_policy_execution_history_details

  • October 11, 2020 at 11:27 am

    #3796033

    Hello,

    we use PBM to monitor last full and last log backup. PBM created, nothing special so far. We created a stored procedure and a job querying syspolicy_policy_execution_history joining syspolicy_policy_execution_history_details to get the result of the PBM and send it as e-mail. So far so good. But we want to include the expected result in the mail as well. Ok let's do some xml tricks. Now it gets weared. Below is the xml output of the policy.  Pay attention to the result values. I have no clue what this very large numbers are. It must be a date. The SSMS UI shows it. But hey, it is not definitely. Any help is appriciated!

    <Operator>

    <TypeClass>Bool</TypeClass>

    <OpType>GE</OpType>

    <ResultObjType>System.Boolean</ResultObjType>

    <ResultValue>False</ResultValue>

    <Count>2</Count>

    <Attribute>

    <TypeClass>DateTime</TypeClass>

    <Name>LastBackupDate</Name>

    <ResultObjType>System.DateTime</ResultObjType>

    <ResultValue>637377078470000000</ResultValue>

    </Attribute>

    <Function>

    <TypeClass>DateTime</TypeClass>

    <FunctionType>DateAdd</FunctionType>

    <ReturnType>DateTime</ReturnType>

    <ResultObjType>System.DateTime</ResultObjType>

    <ResultValue>-8585993519367121853</ResultValue>

    <Count>3</Count>

    <Constant>

    <TypeClass>String</TypeClass>

    <ObjType>System.String</ObjType>

    <Value>HH</Value>

    </Constant>

    <Constant>

    <TypeClass>Numeric</TypeClass>

    <ObjType>System.Double</ObjType>

    <Value>-24</Value>

    </Constant>

    <Function>

    <TypeClass>DateTime</TypeClass>

    <FunctionType>GetDate</FunctionType>

    <ReturnType>DateTime</ReturnType>

    <ResultObjType>System.DateTime</ResultObjType>

    <ResultValue>-8585992655367121853</ResultValue>

    <Count>0</Count>

    </Function>

    </Function>

    </Operator>

    Regards

    Marcus

  • October 12, 2020 at 12:10 pm

    #3796305

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply