Create New Condition or Open Condition Dialog Box, General Page
Applies To: SQL Server 2016
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 upon the facet that is used. For more information about how conditions relate to facets and policies, see Administer Servers by Using Policy-Based Management.
For a new condition, type the new condition name. For an existing condition, the name is displayed.
The facet used by this condition.
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.
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.
Select a comparison operator for this expression. Operators are as follows: =, !=, >, >=, <, <=, [NOT]LIKE, [NOT]IN. Not all operators are available for some properties.
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: 'AdventureWorks'. Not all operators are available for some properties.
Clauses can be grouped to operate as a single unit separate from the rest of the query, just 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.