Add-CMComplianceSettingSqlQuery

  • リファレンス
モジュール:
ConfigurationManager

コンプライアンス設定の SQL クエリを追加します

構文

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コマンドレットを実行します (例: PS XYZ:\>)。 詳細については、「作業の 開始」を参照してください。

例

例 1

PS XYZ:\>

パラメーター

-ColumnName

Type:String
Position:Named
Default value:None
Required:True
Accept pipeline input:False
Accept wildcard characters:False

-Confirm

コマンドレットを実行する前に確認メッセージを表示します。

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

-InputObject

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

作業中のアイテムを表す オブジェクトを返します。 既定では、このコマンドレットは出力を生成しない場合があります。

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

コマンドレットが実行されるとどうなるかを示します。 コマンドレットは実行されません。

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