syspolicy_conditions (Transact-SQL)

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

Reference

Policy-Based Management Views (Transact-SQL)

Concepts

Administer Servers by Using Policy-Based Management