Add-CMComplianceSettingSqlQuery

Módulo:

ConfigurationManager

Agrega una consulta SQL de configuración de cumplimiento

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

Nota:

Ejecute cmdlets de Configuration Manager desde la unidad de sitio Configuration Manager, por ejemploPS XYZ:\>. Para obtener más información, consulte Introducción.

Ejemplos

Ejemplo 1

PS XYZ:\>

Parámetros

-ColumnName

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

-Confirm

Solicitará confirmación antes de ejecutar el 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

Este parámetro trata los caracteres comodín como valores de caracteres literales. No se puede combinar con 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

Este parámetro procesa caracteres comodín y puede provocar un comportamiento inesperado (no recomendado). No se puede combinar con 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

Devuelve un objeto que representa el elemento con el que está trabajando. De forma predeterminada, este cmdlet no puede generar ninguna salida.

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

Muestra lo que ocurriría si se ejecuta el cmdlet. El cmdlet no se ejecuta.

Type:	SwitchParameter
Aliases:	wi
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

Entradas

System.Management.Automation.PSObject

Salidas

System.Object