Set-WEMCitrixOptimizerConfiguration.ps1

<#
    .Synopsis
    Updates a Citrix Optimizer Configuration object in the WEM Database.

    .Description
    Updates a Citrix Optimizer Configuration object in the WEM Database.

    .Link
    https://msfreaks.wordpress.com

    .Parameter IdSite
    ..

    .Parameter IdTemplate
    ..

    .Parameter State
    ..

    .Parameter Groups
    ..

    .Parameter Targets
    ..

    .Parameter Connection
    ..

    .Example

    .Notes
    Author: Arjan Mensch
#>
function Set-WEMCitrixOptimizerConfiguration {
    [CmdletBinding()]
    param (
        [Parameter(Mandatory=$True,ValueFromPipeline=$True, ValueFromPipelineByPropertyName=$True)]
        [int]$IdSite,
        [Parameter(Mandatory=$True, ValueFromPipelineByPropertyName=$True)]
        [int]$IdTemplate,

        [Parameter(Mandatory=$False)][ValidateSet("Enabled","Disabled")]
        [string]$State,
        [Parameter(Mandatory=$False)]
        [string[]]$Groups,
        [Parameter(Mandatory=$False)]
        [string[]]$Targets,

        [Parameter(Mandatory=$True)]
        [System.Data.SqlClient.SqlConnection]$Connection
    )

    process {
        Write-Verbose "Working with database version $($script:databaseVersion)"
        Write-Verbose "Function name '$($MyInvocation.MyCommand.Name)'"

        # only continue if the WEM version supports it
        if ($script:databaseSchema -lt 2003) {
            Write-Error "WEM $($script:databaseSchema) does not support Citrix Optimizer Configurations"
            Break
        }

        # only continue if a valid IdSite was passed
        if (-not (Get-WEMConfiguration -Connection $Connection -IdSite $IdSite)) {
            Write-Warning "No site found with IdSite $($IdSite)"
            Break
        }
        
        # grab original object
        $origObject = Get-WEMCitrixOptimizerConfiguration -Connection $Connection -IdSite $IdSite -IdTemplate $IdTemplate -Verbose

        # only continue if the object was found
        if (-not $origObject) { 
            Write-Warning "No Citrix Optimizer Configuration object found for Id $($IdTemplate)"
            Break
        }
        
        # determine targets
        $newtargets = 0
        if ([bool]($MyInvocation.BoundParameters.Keys -match 'targets')) {
            foreach($target in $Targets) {
                if ($configurationSettings."$($script:databaseSchema)".VUEMCitrixOptimizerTargets.GetEnumerator() | Where-Object {$_.Value -eq $target}) {
                    $newtargets += [int]($configurationSettings."$($script:databaseSchema)".VUEMCitrixOptimizerTargets.GetEnumerator() | Where-Object {$_.Value -eq $target}).Name
                } else {
                    Write-Host "Cannot apply Targets parameter.`n'$($target)' does not exist in WEM $($script:databaseSchema)" -ForegroundColor Red
                    Break
                }
            }

            Write-Verbose "Determined Targets are valid"
        }

        # check State (only 1 Target OS template may be enabled at any time) 
        if ([bool]($MyInvocation.BoundParameters.Keys -match 'state') -and $State -eq "Enabled") {
            $configurations = Get-WEMCitrixOptimizerConfiguration -Connection $Connection -IdSite $IdSite -State Enabled

            # check Target OSs
            foreach ($configuration in $configurations) {
                $conftargets = 0
                foreach ($target in $configuration.Targets) {
                    $conftargets += [int]($configurationSettings."$($script:databaseSchema)".VUEMCitrixOptimizerTargets.GetEnumerator() | Where-Object {$_.Value -eq $target}).Name
                }
                if($newtargets -band $conftargets) {
                    Write-Host "Cannot Enable this Citrix Optimizer Configuration.`nOnly one Target OS Template may be enabled at any time.`n'$($configuration.Name)' is already enabled for one or more of the requested target OSs." -ForegroundColor Red
                    Break
                }
            }

            Write-Verbose "Determined State can indeed be Enabled"
        }

        $selectedGroups = @()
        $unselectedGroups = @()
        $availableGroups = $origObject.TemplateXml.root.group.displayname

        # check Groups 
        if ([bool]($MyInvocation.BoundParameters.Keys -match 'groups')) {
            if (@($Groups | Where-Object { $availableGroups -notcontains $_ } | Select-Object -first 1).Count) {
                Write-Host "One or more of the requested groups are not available in the template." -ForegroundColor Red
                Break
            }

            $selectedGroups = $Groups
            $unselectedGroups = @($availableGroups | Where-Object { $_ -notin $selectedGroups })
        }

        # build the query to update the object
        $SQLQuery = "UPDATE VUEMCitrixOptimizerConfigurations SET "
        $updateFields = @()
        $keys = $MyInvocation.BoundParameters.Keys | Where-Object { $_ -notmatch "connection" -and $_ -notmatch "idtemplate" -and $_ -notmatch "idsite" }
        foreach ($key in $keys) {
            switch ($key) {
                "State" {
                    $updateFields += "State = $($tableVUEMState["$($State)"])"
                    continue
                }
                "Groups" {
                    $updateFields += "SelectedGroups = '$($selectedGroups -join ",")'"
                    $updateFields += "UnselectedGroups = '$($unselectedGroups -join ",")'"
                    continue
                }
                "Targets" {
                    $updateFields += "Targets = $($newtargets)"
                    continue
                }
                Default {}
            }
        }

        # if anything needs to be updated, update the object
        if($updateFields) { 
            $SQLQuery += "{0}, " -f ($updateFields -join ", ")
            $SQLQuery += "RevisionId = $($origObject.Version + 1) WHERE IdTemplate = $($IdTemplate)"
            $null = Invoke-SQL -Connection $Connection -Query $SQLQuery

            # Updating the ChangeLog
            New-ChangesLogEntry -Connection $Connection -IdSite $origObject.IdSite -IdElement $IdTemplate -ChangeType "Update" -ObjectName $origObject.Name -ObjectType "Citrix Optimizer\Configurations" -NewValue "N/A" -ChangeDescription $null -Reserved01 $null
        } else {
            Write-Warning "No parameters to update were provided"
        }
    }
}