Policy-Based Management Views (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse 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