Add-CMComplianceSettingSqlQuery
Adds a compliance setting sql query
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
Note
Run Configuration Manager cmdlets from the Configuration Manager site drive, for example PS XYZ:\>
. For more information, see getting started .
Examples
Example 1
PS XYZ:\>
Parameters
-ColumnName
Type: String
Position: Named
Default value: None
Required: True
Accept pipeline input: False
Accept wildcard characters: False
-Confirm
Prompts you for confirmation before running the 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
This parameter treats wildcard characters as literal character values. You can't combine it with 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
This parameter processes wildcard characters and may lead to unexpected behavior (not recommended). You can't combine it with 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
Returns an object representing the item with which you are working. By default, this cmdlet may not generate any output.
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
Shows what would happen if the cmdlet runs. The cmdlet doesn't run.
Type: SwitchParameter
Aliases: wi
Position: Named
Default value: None
Required: False
Accept pipeline input: False
Accept wildcard characters: False
System.Management.Automation.PSObject
Outputs
System.Object