| title | syspolicy_conditions (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.service | |||
| ms.component | system-catalog-views | ||
| ms.reviewer | |||
| ms.suite | sql | ||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | af97d26c-4bd5-4b08-be51-8419e3b2832c | ||
| caps.latest.revision | 22 | ||
| author | stevestein | ||
| ms.author | sstein | ||
| manager | craigg | ||
| ms.workload | Inactive |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
Displays one row for each Policy-Based Management condition in the instance of [!INCLUDEssNoVersion]. 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. |
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.
Administer Servers by Using Policy-Based Management
Policy-Based Management Views (Transact-SQL)