• Article

Policy-Based Management Views (Transact-SQL)

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