syspolicy_conditions (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Administer Servers by Using Policy-Based Management
Policy-Based Management Views (Transact-SQL)