Databases Reference
In-Depth Information
Figure 12-22
The cmdlet also has a
-AdHocPolicyEvaluationMode
parameter to specify the evaluation modes. The
possible values are as follows:
❑
Check
: Reports the compliance status of the target objects using the credentials of the current
login. Does not reconfigure any objects. This is the default setting.
❑
CheckSqlScriptAsProxy
: Reports the compliance status of the target objects using the creden-
tials of the
##MS PolicyTSQLExecutionLogin
## proxy login. Does not reconfigure any objects.
❑
Configure
: Reports the compliance status of the target objects using the credentials of the cur-
rent login. Reconfigures any settable and deterministic options that are not in compliance with
the policies.
The target sets of the policy evaluation can be specified in two ways. You can evaluate the policy against
all the qualified objects on a server instance specified in the
-TargetServerName
parameter. To fine-tune
the target set further, use the -
TargetExpression
parameter.
You can use the -
TargetObjects
parameter to specify a
PSObject
or an array of
PSObjects
that define
the set of SQL Server objects.
Search WWH ::
Custom Search