537
Chapter 20: Policy Based Management
20
FIGURE 20-4
This condition includes an expression that tests the Database Facet’s @AutoShrink. The
condition evaluates as True if @AutoShrink = False.The ellipsis button under Field and Value opens the Advanced Edit dialog box, as shown in
Figure 20-5. The Cell value is typically a property, function, or a literal value; however, it is
possible to build more advanced expressions that reference DMV or system tables.A condition may include multiple expressions, in which case the AndOr column defi nes how
they are evaluated.Best Practice
In the entire policy design scheme, the only place that enables multiples is designing multiple expres-
sions within a single condition. Therefore, if every expression should indeed be tested, encapsulating
multiple expressions in a single condition can reduce the number of conditions and policies.The open condition’s description page may be used to record a description of the condition,
and the dependent policies page lists the policies based on the condition. After the condi-
tion is created, it may be enforced by one or more policies. To programmatically view the
created conditions, query the dbo.syspolicy_conditions view in the MSDB database:c20.indd 537c20.indd 537 7/30/2012 5:45:12 PM7/30/2012 5:45:12 PM
http://www.it-ebooks.info