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.
|
Column name
|
Data type
|
Description
|
|---|
|
condition_id
|
int
|
Identifier of this condition. Each condition represents a collection of one or more condition expressions.
|
|
name
|
sysname
|
Name of the condition.
|
|
date_created
|
datetime
|
Date and time the condition was created.
|
|
description
|
nvarchar(max)
|
Description of the condition. The description column is optional and can be NULL.
|
|
created_by
|
sysname
|
Login that created the condition.
|
|
modified_by
|
sysname
|
Login that most recently modified the condition. Is NULL if never modified.
|
|
date_modified
|
datetime
|
Date and time the condition was created. Is NULL if never modified.
|
|
is_name_condition
|
smallint
|
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.
|
|
facet
|
nvarchar(max)
|
Name of the facet that the condition is based on.
|
|
Expression
|
nvarchar(max)
|
Expression of the facet states.
|
|
obj_name
|
sysname
|
The object name assigned to @Name if the condition expression contains this variable.
|
Remarks
When you are troubleshooting Policy-Based Management, query the syspolicy_conditions view to determine who created or last changed the condition.
Permissions
Requires membership in the PolicyAdministratorRole role in the msdb database.
See Also