Export (0) Print
Expand All

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.

Applies to: SQL Server (SQL Server 2008 through current version).

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.

When you are troubleshooting Policy-Based Management, query the syspolicy_conditions view to determine who created or last changed the condition.

Requires membership in the PolicyAdministratorRole role in the msdb database.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft