Add-CMComplianceSettingSqlQuery
语法
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>]
说明
注意
从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