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

See Also

Administer Servers by Using Policy-Based Management