Add-CMComplianceSettingSqlQuery
Syntax
Add-CMComplianceSettingSqlQuery
-ColumnName <String>
-DatabaseName <String>
-DataType <SettingDataType>
[-InstanceName <String>]
[-InstanceType <TargetSqlInstance>]
[-SqlStatementFile <String>]
[-SqlStatementText <String>]
[-Description <String>]
-InputObject <PSObject>
-Name <String>
[-NoRule]
[-PassThru]
[-DisableWildcardHandling]
[-ForceWildcardHandling]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Add-CMComplianceSettingSqlQuery
-ColumnName <String>
-DatabaseName <String>
-DataType <SettingDataType>
[-InstanceName <String>]
[-InstanceType <TargetSqlInstance>]
[-SqlStatementFile <String>]
[-SqlStatementText <String>]
[-Description <String>]
-Existence <ExistenceType>
[-ExistentialRule]
[-ExpectedValue <String[]>]
[-ExpressionOperator <RuleExpressionOperator>]
-InputObject <PSObject>
-Name <String>
[-NoncomplianceSeverity <NoncomplianceSeverity>]
[-PassThru]
[-RuleDescription <String>]
-RuleName <String>
[-DisableWildcardHandling]
[-ForceWildcardHandling]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Add-CMComplianceSettingSqlQuery
-ColumnName <String>
-DatabaseName <String>
-DataType <SettingDataType>
[-InstanceName <String>]
[-InstanceType <TargetSqlInstance>]
[-SqlStatementFile <String>]
[-SqlStatementText <String>]
[-Description <String>]
-ExpectedValue <String[]>
-ExpressionOperator <RuleExpressionOperator>
-InputObject <PSObject>
-Name <String>
[-NoncomplianceSeverity <NoncomplianceSeverity>]
[-PassThru]
[-ReportNoncompliance]
[-RuleDescription <String>]
-RuleName <String>
[-ValueRule]
[-DisableWildcardHandling]
[-ForceWildcardHandling]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Description
注意事項
從Configuration Manager月臺磁片磁碟機執行 Configuration Manager Cmdlet,例如 PS XYZ:\>
。 如需詳細資訊,請 參閱開始使用。
範例
範例 1
PS XYZ:\>
參數
-ColumnName
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Confirm
執行 Cmdlet 之前提示您確認。
Type: | SwitchParameter |
Aliases: | cf |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-DatabaseName
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-DataType
Type: | SettingDataType |
Accepted values: | String, DateTime, Integer, FloatingPoint, Version, Boolean |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Description
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-DisableWildcardHandling
此參數會將萬用字元視為常值字元值。 您無法將其與 ForceWildcardHandling結合。
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Existence
Type: | ExistenceType |
Accepted values: | MustExist, MustNotExist, Occurs |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ExistentialRule
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ExpectedValue
Type: | String[] |
Aliases: | ExpectedValues, ExpectedCount, ExpectedCounts |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ExpressionOperator
Type: | RuleExpressionOperator |
Accepted values: | And, Or, Other, IsEquals, NotEquals, GreaterThan, LessThan, Between, NotBetween, GreaterEquals, LessEquals, BeginsWith, NotBeginsWith, EndsWith, NotEndsWith, Contains, NotContains, AllOf, OneOf, NoneOf, SetEquals, SubsetOf, ExcludesAll, And, Or, Other, IsEquals, NotEquals, GreaterThan, LessThan, Between, NotBetween, GreaterEquals, LessEquals, BeginsWith, NotBeginsWith, EndsWith, NotEndsWith, Contains, NotContains, AllOf, OneOf, NoneOf, SetEquals, SubsetOf, ExcludesAll |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ForceWildcardHandling
此參數會處理萬用字元,並可能導致非預期的行為 (不建議) 。 您無法將其與 DisableWildcardHandling結合。
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
Type: | PSObject |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-InstanceName
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-InstanceType
Type: | TargetSqlInstance |
Accepted values: | All, Default, Named |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-Name
Type: | String |
Aliases: | SettingName |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-NoncomplianceSeverity
Type: | NoncomplianceSeverity |
Accepted values: | None, Informational, Warning, Critical, CriticalWithEvent |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-NoRule
Type: | SwitchParameter |
Aliases: | NoRules |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-PassThru
傳回 物件,表示您正在使用的專案。 根據預設,此 Cmdlet 可能不會產生任何輸出。
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ReportNoncompliance
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-RuleDescription
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-RuleName
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-SqlStatementFile
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-SqlStatementText
Type: | String |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ValueRule
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-WhatIf
顯示執行 Cmdlet 時會發生什麼情況。 Cmdlet 不會執行。
Type: | SwitchParameter |
Aliases: | wi |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
System.Management.Automation.PSObject
輸出
System.Object