Events
Get certified in Microsoft Fabric—for free!
19 Nov, 23 - 10 Dec, 23
For a limited time, the Microsoft Fabric Community team is offering free DP-600 exam vouchers.
Prepare nowThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: SQL Server
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.
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's 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: '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're building complex queries.
To group clauses
Events
Get certified in Microsoft Fabric—for free!
19 Nov, 23 - 10 Dec, 23
For a limited time, the Microsoft Fabric Community team is offering free DP-600 exam vouchers.
Prepare now