syspolicy_system_health_state (Transact-SQL)


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.

Applies to: SQL Server (SQL Server 2008 through current version).
Column nameData typeDescription
health_state_idbigintIdentifier of the policy health state record.
policy_idintIdentifier of the policy.
last_run_datedatetimeDate and time the policy was last run.
target_query_expression_with_idnvarchar(400)The target expression, with values assigned to identity variables, that defines the target against which the policy is evaluated.
target_query_expressionnvarchar(max)The epxression that defines the target against which the policy is evaluated.
resultbitHealth state of this target with regard to the policy:

0 = Failure

1 = Success

The syspolicy_system_health_state view displays the most recent health state of target query expression for each active (enabled) policy. The SQL Server Management Studio Object Explorer and Object Explorer Details page aggregates policy health from this view to show the critical health state.

Requires membership in the PolicyAdministratorRole role in the msdb database.

Administer Servers by Using Policy-Based Management
Policy-Based Management Views (Transact-SQL)

Community Additions