Displays one row for each Policy-Based Management condition in the instance of SQL Server. syspolicy_conditions belongs to the dbo schema in the msdb database. The following table describes the columns in the syspolicy_conditions view.
Identifier of this condition. Each condition represents a collection of one or more condition expressions.
Name of the condition.
Date and time the condition was created.
Description of the condition. The description column is optional and can be NULL.
Login that created the condition.
Login that most recently modified the condition. Is NULL if never modified.
Date and time the condition was created. Is NULL if never modified.
Specifies whether the condition is a naming condition.
0 = The condition expression does not contain the @Name variable.
1 = The condition expression contains the @Name variable.
Name of the facet that the condition is based on.
Expression of the facet states.
The object name assigned to @Name if the condition expression contains this variable.