Displays one row for each Policy-Based Management policy and target query expression combination. Use the syspolicy_system_health_state view to programmatically check the policy health of the server. The following table describes the columns in the syspolicy_system_health_state view.
Identifier of the policy health state record.
Identifier of the policy.
Date and time the policy was last run.
The target expression, with values assigned to identity variables, that defines the target against which the policy is evaluated.
The epxression that defines the target against which the policy is evaluated.
Health state of this target with regard to the policy:
0 = Failure
1 = Success