Create New Condition or Open Condition Dialog Box, General Page
Use this dialog box to create or change a Policy-Based Management condition. A condition is a Boolean expression that specifies a set of allowed states of a Policy-Based Management managed target with regard to facets. The properties that can be selected in the Expression/Field box depend on the facet that is used. For more information about how conditions relate to facets and policies, see Administering Servers by Using Policy-Based Management.
You can open this dialog box in several ways.
To open this dialog box
In Object Explorer, expand Management, expand Policy Management, right-click Conditions, and then click New Condition.
In Object Explorer, expand Management, expand Policy Management, expand Conditions, right-click a condition, and then click Properties.
Note
To open a system condition, in Object Explorer, expand Management, expand Policy Management, expand Conditions, expand System Conditions, right-click a condition, and then click Properties.
In Object Explorer, expand Management, expand Policy Management, expand the facet that contains the condition, right-click a facet, and then click New Condition.
On the Open Policy, General Page in the condition area, click New or Edit.
Options
Important
For system conditions, all the fields are read-only. The System Conditions folder contains conditions that should not be deleted or changed through Policy-Based Management. For example, to make sure that monitoring policies that are used in SQL Server Utility Explorer are not incorrectly changed. These policies and their associated conditions can only be changed through Utility Explorer.
Name
For a new condition, type the new condition name. For an existing condition, the name is displayed.Facet
The facet used by this condition.AndOr
When you add multiple expressions, indicates whether the expressions should be joined by using And or Or. Remains blank when there is only one expression.Field
Each facet exposes one or more properties that can be set. In the field box, select a property from the list of available properties to create an expression for this condition.Operator
Select a comparison operator for this expression. Operators are as follows: =, !=, >, >=, <, <=, [NOT]LIKE, [NOT]IN. Not all operators are available for some properties.Value
The value setting for this expression. The allowed values depend on the facet. Values can be TRUE/FALSE, string, or numeric. String values must be enclosed in single quotation marks, for example: 'AdventureWorks2008R2'. Not all operators are available for some properties.
Group Clauses
Clauses can be grouped to operate as a single unit separate from the rest of the query, exactly like putting parentheses around an expression in a mathematical equation or logic statement. Grouping clauses is useful when you are building complex queries.
To group clauses
- Press the SHIFT or CTRL keys, and then click two or more clauses to select a range. Right-click the selected area, and then click Group Clauses.