DSCResources/Resources/SqlServer.ScriptQuery.ps1
|
# Copyright (c) Microsoft Corporation. All rights reserved. # Licensed under the MIT License. $rules = Get-RuleClassData -StigData $stigData -Name SqlScriptQueryRule foreach ($instance in $ServerInstance) { if ($null -ne $Database) { foreach ($db in $Database) { foreach ( $rule in $rules ) { SqlScriptQuery "$(Get-ResourceTitle -Rule $rule)$instance" { ServerInstance = $Instance GetQuery = $rule.GetScript TestQuery = $rule.TestScript SetQuery = $rule.SetScript Variable = $db } } } } else { foreach ($rule in $rules) { SqlScriptQuery "$(Get-ResourceTitle -Rule $rule)$instance" { ServerInstance = $instance GetQuery = $rule.GetScript TestQuery = $rule.TestScript SetQuery = $rule.SetScript } } } } |