syspolicy_system_health_state (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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 name Data type Description
health_state_id bigint Identifier of the policy health state record.
policy_id int Identifier of the policy.
last_run_date datetime Date and time the policy was last run.
target_query_expression_with_id nvarchar(400) The target expression, with values assigned to identity variables, that defines the target against which the policy is evaluated.
target_query_expression nvarchar(max) The epxression that defines the target against which the policy is evaluated.
result bit Health state of this target with regard to the policy:

0 = Failure

1 = Success

Remarks

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.

Permissions

Requires membership in the PolicyAdministratorRole role in the msdb database.

See Also

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