Policy-Based Management Views (Transact-SQL)

APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

Policy-Based Management has the following views for displaying information about Policy-Based Management policies, conditions, expressions, groups, and filters. These views are in the msdb database and are owned by the dbo schema.

syspolicy_conditions syspolicy_policy_group_subscriptions
syspolicy_policies syspolicy_policy_groups
syspolicy_policy_execution_history syspolicy_system_health_state
syspolicy_policy_execution_history_details

See Also

Administer Servers by Using Policy-Based Management