Applies To: SQL Server 2014, SQL Server 2016 Preview
Displays one row for each Policy-Based Management policy in the instance of SQL Server. syspolicy_policies belongs to the dbo schema in the msdb database. The following table describes the columns in the syspolicy_policies view.
Applies to: SQL Server (SQL Server 2008 through current version).
Identifier of the policy.
Name of the policy.
ID of the condition enforced or tested by this policy.
For internal use only.
Date and time the policy was created.
Evaluation mode for the policy. Possible values are as follows:
ID of the Policy-Based Management policy category that this policy belongs to. Is NULL if it is the default policy group.
When the execution_mode is On schedule, contains the ID of the schedule; otherwise, is NULL.
Description of the policy. The description column is optional and can be NULL.
The hyperlink text that belongs to help_link.
The additional help hyperlink that is assigned to the policy by the policy creator.
ID of the object set that the policy evaluates.
Indicates whether the policy is currently enabled (1) or disabled (0).
When the execution_mode is On schedule, contains the ID of the SQL Server Agent job that runs the policy.
Login that created the policy.
Login that most recently modified the policy. Is NULL if never modified.
Date and time the policy was created. Is NULL if never modified.
When you are troubleshooting Policy-Based Management, query the syspolicy_conditions view to determine whether the policy is enabled. This view also displays who created or last changed the policy.
Requires membership in the PolicyAdministratorRole role in the msdb database.