public/Import-AppVManagementConnectionGroup.ps1
|
function Import-AppVManagementConnectionGroup { <# .SYNOPSIS Imports App-V Connection Groups from the Management Database to the AppVentiX configuration. .DESCRIPTION The Import-AppVManagementConnectionGroup function retrieves Connection Groups from the App-V Management Database and imports them into the AppVentiX configuration share. This function allows you to synchronize Connection Groups from the Management Server to make them available for seamless publishing. .PARAMETER SQLServer Specifies the SQL Server hostname or IP address. Default value: localhost .PARAMETER SQLInstance Specifies the SQL Server instance name. If not specified, the default instance will be used. .PARAMETER SQLDatabase Specifies the App-V Management database name. Default value: AppVManagement .PARAMETER SQLCredential Specifies the PSCredential object for SQL Server authentication. If not specified, Windows Integrated Authentication will be used. .PARAMETER GUI When specified, displays a graphical user interface to select Connection Groups to import. .PARAMETER ConfigShare Specifies the AppVentiX configuration share path. This parameter is hidden and uses the module's configured ConfigShare by default. .EXAMPLE Import-AppVManagementConnectionGroup -SQLServer "sql01.domain.local" Imports all Connection Groups from the specified SQL Server. .EXAMPLE Import-AppVManagementConnectionGroup -SQLServer "sql01.domain.local" -GUI Displays a GUI to select specific Connection Groups to import. .EXAMPLE $cred = Get-Credential Import-AppVManagementConnectionGroup -SQLServer "sql01.domain.local" -SQLCredential $cred -GUI Imports Connection Groups using SQL authentication and GUI selection. .NOTES Function : Import-AppVManagementConnectionGroup Author : John Billekens Copyright: Copyright (c) John Billekens Consultancy & AppVentiX Version : 2026.130.945 Requires : Valid AppVentiX license #> [CmdletBinding()] param ( [String]$SQLServer = "localhost", [String]$SQLInstance, [String]$SQLDatabase = 'AppVManagement', [switch]$MatchConnectionGroupWithMachineGroup, [System.Management.Automation.PSCredential]$SQLCredential = [System.Management.Automation.PSCredential]::Empty, [switch]$GUI, [Parameter(DontShow)] [ValidateNotNullOrEmpty()] [String]$ConfigShare = $Script:AppVentiX.ConfigShare ) $PSDefaultParameterValues['Write-AppVentiXError:Cmdlet'] = $PSCmdlet if (Test-AppVentiXIsLicensed -ConfigShare $ConfigShare) { $SQLParams = @{ SQLServer = $SQLServer SQLInstance = $SQLInstance SQLDatabase = $SQLDatabase SQLCredential = $SQLCredential } try { Write-Verbose "Testing connection to App-V Management database '$SQLDatabase' on server '$SQLServer', instance '$SQLInstance'..." $connectionResult = Test-AppVManagementSQLConnection @SQLParams -ErrorAction Stop if (-not $connectionResult) { Write-AppVentiXError -Message "Cannot connect to the App-V Management database on server '$SQLServer', database '$SQLDatabase', instance '$SQLInstance'." ` -ErrorId 'SQLConnectionFailed' ` -Category ConnectionError ` -Cmdlet $PSCmdlet return } } catch { Write-AppVentiXError -Message "Cannot connect to the App-V Management database on server '$SQLServer', database '$SQLDatabase', instance '$SQLInstance'." ` -ErrorId 'SQLConnectionFailed' ` -Category ConnectionError ` -Cmdlet $PSCmdlet return } Write-Host "Connected to App-V Management database '$SQLDatabase' on server '$SQLServer', retrieving Connection Groups..." Write-Verbose "Retrieving AppVentiX Content Share Packages from configuration share '$ConfigShare'..." $AppVentiXContentSharePackages = Get-AppVentiXContentSharePackages -ConfigShare $ConfigShare if ($AppVManagementConnectionGroup = Get-AppVManagementConnectionGroup @SQLParams) { if ($GUI.IsPresent -eq $true) { $AppVManagementConnectionGroup = @( $AppVManagementConnectionGroup | Select-ObjectFromGrid -Title "Select App-V Management Connection Groups to import" ` -ColumnsToShow @('ConnectionGroupId', 'ConnectionGroupName', 'ConnectionGroupEnabled', 'ConnectionGroupPriority', 'ConnectionGroupVersion', 'Description') ) } if (-not $AppVManagementConnectionGroup -or $AppVManagementConnectionGroup.Count -eq 0) { Write-Warning "No App-V Management Connection Groups selected for import." return } Write-Host "`r`nImporting $($AppVManagementConnectionGroup.Count) App-V Management Connection Groups" foreach ($ConnectionGroup in $AppVManagementConnectionGroup) { Write-Host "`r`n================================" -ForegroundColor Cyan if ($ConnectionGroup.ConnectionGroupEnabled -ne $true) { Write-Host "`r`nSkipping disabled App-V Management Connection Group '$($ConnectionGroup.ConnectionGroupName)'" -ForegroundColor Yellow continue } Write-Host "`r`nImporting App-V Management Connection Group '$($ConnectionGroup.ConnectionGroupName)'" -ForegroundColor Cyan [PSCustomObject[]]$appVManagementPackages = @() $AppVentiXPackages = @() $ContentShares = @(Get-AppVentiXMachineGroup | Select-Object -ExpandProperty GroupContentshares -ErrorAction SilentlyContinue | Select-Object -ExpandProperty ContentShare -ErrorAction SilentlyContinue | Select-Object -ExpandProperty Path -ErrorAction SilentlyContinue -Unique) Write-Host "Processing packages for Connection Group" -ForegroundColor Cyan foreach ($appVManagementPackage in $ConnectionGroup.Packages) { Write-Host " => Processing package '$($appVManagementPackage.PackageName)'" -ForegroundColor Cyan $MachineGroupFriendlyName = 'All Machine Groups' if (-not [string]::IsNullOrEmpty($appVManagementPackage.PackageUrl) -and $appVManagementPackage.PackageUrl.StartsWith('\\')) { $fileServer, $fileServerShare, $fileserverPath = $appVManagementPackage.PackageUrl.TrimStart('\\').Split('\', 3) $AppVentiXPackage = @($AppVentiXContentSharePackages | Where-Object { $_.FullName -like "\\$($fileServer)*\$($fileServerShare)\$($fileserverPath)" }) if (-Not ($ContentShare = $ContentShares | Where-Object { $_ -like "\\$($fileServer)*\$($fileServerShare)" } | Select-Object -First 1)) { $ContentShare = "\\$($fileServer)\$($fileServerShare)" } Write-Verbose "Using Content Share '$ContentShare'." if ($MatchConnectionGroupWithMachineGroup.IsPresent -eq $false) { if ($AppVentiXPackage.Count -eq 0) { Write-Warning "Package URL: '$($appVManagementPackage.PackageUrl)'" Write-Warning "Package not found in any of the configured Machine Group Content Shares. Trying to publish to All Machine Groups." } } elseif ($AppVentiXPackage.Count -eq 0) { Write-Warning "Package URL: '$($appVManagementPackage.PackageUrl)'" Write-Warning "Package not found in AppVentiX Content Share Packages. Trying to publish to All Machine Groups." } elseif ($AppVentiXPackage.Count -gt 1) { Write-Warning "Package URL: '$($appVManagementPackage.PackageUrl)'" Write-Warning "Multiple packages found ($($AppVentiXPackage.Count)) in AppVentiX Content Share Packages matching the specified URL." Write-Warning "Trying to publish to All Machine Groups." } else { Write-Host " => Found package in AppVentiX Content Share Packages." -ForegroundColor Green $AppVentiXPackages += $AppVentiXPackage $appVManagementPackages += [PSCustomObject]@{ Path = $appVManagementPackage.PackageUrl Optional = $appVManagementPackage.Optional AnyVersion = $appVManagementPackage.UseAnyVersion } } } else { Write-Warning "Package URL: '$($appVManagementPackage.PackageUrl)'" Write-Warning "Package is not a valid UNC path. Skipping package." continue } } Write-Host "Creating Connection Group '$($ConnectionGroup.ConnectionGroupName)' with $($AppVentiXPackages.Count) packages." -ForegroundColor Cyan try { if ($MatchConnectionGroupWithMachineGroup.IsPresent -eq $true -and $AppVentiXPackages.Count -gt 0) { $MachineGroupFriendlyName = $AppVentiXPackages | Select-Object -ExpandProperty MachineGroup -Unique if (($MachineGroupFriendlyName | Measure-Object).Count -gt 1) { Write-Warning "Packages belong to multiple Machine Groups: $($MachineGroupFriendlyName -join ', ')." Write-Warning "Publishing Connection Group to 'All Machine Groups'." $MachineGroupFriendlyName = 'All Machine Groups' } } else { $MachineGroupFriendlyName = 'All Machine Groups' } Write-Host "Continuing with Machine Group '$MachineGroupFriendlyName'" -ForegroundColor Cyan $AppVentiXConnectionGroup = New-AppVentiXConnectionGroup -Packages $appVManagementPackages ` -MachineGroupFriendlyName $MachineGroupFriendlyName ` -ConnectionGroupName $ConnectionGroup.ConnectionGroupName ` -ContentShare $ContentShare ` -Priority $ConnectionGroup.ConnectionGroupPriority Write-Host "Successfully created Connection Group '$($AppVentiXConnectionGroup.Name)'." -ForegroundColor Green $publishTaskADGroup = @() foreach ($adGroup in $ConnectionGroup.ADGroups) { if ([string]::IsNullOrEmpty($($adGroup.Name))) { Write-Warning "Skipping empty AD Group for Connection Group '$($ConnectionGroup.ConnectionGroupName)'." continue } $publishTaskADGroup += '{0}\{1}' -f $adGroup.Domain, $adGroup.Name } $params = @{ MachineGroupFriendlyName = $MachineGroupFriendlyName Group = $publishTaskADGroup Path = $AppVentiXConnectionGroup.Path } Write-Verbose "Creating publishing task for Connection Group '$($ConnectionGroup.ConnectionGroupName)' with parameters: $($params | Out-String)" $newTaskId = New-AppVentiXPublishingTask @params Write-Output ([PSCustomObject]@{ Name = $ConnectionGroup.ConnectionGroupName Id = $newTaskId.Id }) } catch { Write-Warning "Failed to create Connection Group '$($ConnectionGroup.ConnectionGroupName)': $($_.Exception.Message)" } Write-Host "Finished with the Connection Group '$($ConnectionGroup.ConnectionGroupName)'." -ForegroundColor Cyan } Write-Host "`r`n================================" -ForegroundColor Cyan Write-Host "`r`nFinished processing App-V Management Connection Groups.`r`n" -ForegroundColor Cyan } else { Write-Warning "No App-V Management Connection Groups found in the database '$SQLDatabase' on server '$SQLServer'." Write-Verbose $($_ | Get-ExceptionDetails -AsPlainText) } } else { throw "AppVentiX is not licensed. Please run the license setup before using this function." } } # SIG # Begin signature block # MIImdwYJKoZIhvcNAQcCoIImaDCCJmQCAQExDzANBglghkgBZQMEAgEFADB5Bgor # BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG # KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCB7muXqlitK5WiA # SFEr6URLxCTH48DPJsXUD9YBvy+jk6CCIAowggYUMIID/KADAgECAhB6I67aU2mW # D5HIPlz0x+M/MA0GCSqGSIb3DQEBDAUAMFcxCzAJBgNVBAYTAkdCMRgwFgYDVQQK # Ew9TZWN0aWdvIExpbWl0ZWQxLjAsBgNVBAMTJVNlY3RpZ28gUHVibGljIFRpbWUg # U3RhbXBpbmcgUm9vdCBSNDYwHhcNMjEwMzIyMDAwMDAwWhcNMzYwMzIxMjM1OTU5 # WjBVMQswCQYDVQQGEwJHQjEYMBYGA1UEChMPU2VjdGlnbyBMaW1pdGVkMSwwKgYD # VQQDEyNTZWN0aWdvIFB1YmxpYyBUaW1lIFN0YW1waW5nIENBIFIzNjCCAaIwDQYJ # KoZIhvcNAQEBBQADggGPADCCAYoCggGBAM2Y2ENBq26CK+z2M34mNOSJjNPvIhKA # VD7vJq+MDoGD46IiM+b83+3ecLvBhStSVjeYXIjfa3ajoW3cS3ElcJzkyZlBnwDE # JuHlzpbN4kMH2qRBVrjrGJgSlzzUqcGQBaCxpectRGhhnOSwcjPMI3G0hedv2eNm # GiUbD12OeORN0ADzdpsQ4dDi6M4YhoGE9cbY11XxM2AVZn0GiOUC9+XE0wI7CQKf # OUfigLDn7i/WeyxZ43XLj5GVo7LDBExSLnh+va8WxTlA+uBvq1KO8RSHUQLgzb1g # bL9Ihgzxmkdp2ZWNuLc+XyEmJNbD2OIIq/fWlwBp6KNL19zpHsODLIsgZ+WZ1AzC # s1HEK6VWrxmnKyJJg2Lv23DlEdZlQSGdF+z+Gyn9/CRezKe7WNyxRf4e4bwUtrYE # 2F5Q+05yDD68clwnweckKtxRaF0VzN/w76kOLIaFVhf5sMM/caEZLtOYqYadtn03 # 4ykSFaZuIBU9uCSrKRKTPJhWvXk4CllgrwIDAQABo4IBXDCCAVgwHwYDVR0jBBgw # FoAU9ndq3T/9ARP/FqFsggIv0Ao9FCUwHQYDVR0OBBYEFF9Y7UwxeqJhQo1SgLqz # YZcZojKbMA4GA1UdDwEB/wQEAwIBhjASBgNVHRMBAf8ECDAGAQH/AgEAMBMGA1Ud # JQQMMAoGCCsGAQUFBwMIMBEGA1UdIAQKMAgwBgYEVR0gADBMBgNVHR8ERTBDMEGg # P6A9hjtodHRwOi8vY3JsLnNlY3RpZ28uY29tL1NlY3RpZ29QdWJsaWNUaW1lU3Rh # bXBpbmdSb290UjQ2LmNybDB8BggrBgEFBQcBAQRwMG4wRwYIKwYBBQUHMAKGO2h0 # dHA6Ly9jcnQuc2VjdGlnby5jb20vU2VjdGlnb1B1YmxpY1RpbWVTdGFtcGluZ1Jv # b3RSNDYucDdjMCMGCCsGAQUFBzABhhdodHRwOi8vb2NzcC5zZWN0aWdvLmNvbTAN # BgkqhkiG9w0BAQwFAAOCAgEAEtd7IK0ONVgMnoEdJVj9TC1ndK/HYiYh9lVUacah # RoZ2W2hfiEOyQExnHk1jkvpIJzAMxmEc6ZvIyHI5UkPCbXKspioYMdbOnBWQUn73 # 3qMooBfIghpR/klUqNxx6/fDXqY0hSU1OSkkSivt51UlmJElUICZYBodzD3M/SFj # eCP59anwxs6hwj1mfvzG+b1coYGnqsSz2wSKr+nDO+Db8qNcTbJZRAiSazr7KyUJ # Go1c+MScGfG5QHV+bps8BX5Oyv9Ct36Y4Il6ajTqV2ifikkVtB3RNBUgwu/mSiSU # ice/Jp/q8BMk/gN8+0rNIE+QqU63JoVMCMPY2752LmESsRVVoypJVt8/N3qQ1c6F # ibbcRabo3azZkcIdWGVSAdoLgAIxEKBeNh9AQO1gQrnh1TA8ldXuJzPSuALOz1Uj # b0PCyNVkWk7hkhVHfcvBfI8NtgWQupiaAeNHe0pWSGH2opXZYKYG4Lbukg7HpNi/ # KqJhue2Keak6qH9A8CeEOB7Eob0Zf+fU+CCQaL0cJqlmnx9HCDxF+3BLbUufrV64 # EbTI40zqegPZdA+sXCmbcZy6okx/SjwsusWRItFA3DE8MORZeFb6BmzBtqKJ7l93 # 9bbKBy2jvxcJI98Va95Q5JnlKor3m0E7xpMeYRriWklUPsetMSf2NvUQa/E5vVye # fQIwggZFMIIELaADAgECAhAIMk+dt9qRb2Pk8qM8Xl1RMA0GCSqGSIb3DQEBCwUA # MFYxCzAJBgNVBAYTAlBMMSEwHwYDVQQKExhBc3NlY28gRGF0YSBTeXN0ZW1zIFMu # QS4xJDAiBgNVBAMTG0NlcnR1bSBDb2RlIFNpZ25pbmcgMjAyMSBDQTAeFw0yNDA0 # MDQxNDA0MjRaFw0yNzA0MDQxNDA0MjNaMGsxCzAJBgNVBAYTAk5MMRIwEAYDVQQH # DAlTY2hpam5kZWwxIzAhBgNVBAoMGkpvaG4gQmlsbGVrZW5zIENvbnN1bHRhbmN5 # MSMwIQYDVQQDDBpKb2huIEJpbGxla2VucyBDb25zdWx0YW5jeTCCAaIwDQYJKoZI # hvcNAQEBBQADggGPADCCAYoCggGBAMslntDbSQwHZXwFhmibivbnd0Qfn6sqe/6f # os3pKzKxEsR907RkDMet2x6RRg3eJkiIr3TFPwqBooyXXgK3zxxpyhGOcuIqyM9J # 28DVf4kUyZHsjGO/8HFjrr3K1hABNUszP0o7H3o6J31eqV1UmCXYhQlNoW9FOmRC # 1amlquBmh7w4EKYEytqdmdOBavAD5Xq4vLPxNP6kyA+B2YTtk/xM27TghtbwFGKn # u9Vwnm7dFcpLxans4ONt2OxDQOMA5NwgcUv/YTpjhq9qoz6ivG55NRJGNvUXsM3w # 2o7dR6Xh4MuEGrTSrOWGg2A5EcLH1XqQtkF5cZnAPM8W/9HUp8ggornWnFVQ9/6M # ga+ermy5wy5XrmQpN+x3u6tit7xlHk1Hc+4XY4a4ie3BPXG2PhJhmZAn4ebNSBwN # Hh8z7WTT9X9OFERepGSytZVeEP7hgyptSLcuhpwWeR4QdBb7dV++4p3PsAUQVHFp # wkSbrRTv4EiJ0Lcz9P1HPGFoHiFAQQIDAQABo4IBeDCCAXQwDAYDVR0TAQH/BAIw # ADA9BgNVHR8ENjA0MDKgMKAuhixodHRwOi8vY2NzY2EyMDIxLmNybC5jZXJ0dW0u # cGwvY2NzY2EyMDIxLmNybDBzBggrBgEFBQcBAQRnMGUwLAYIKwYBBQUHMAGGIGh0 # dHA6Ly9jY3NjYTIwMjEub2NzcC1jZXJ0dW0uY29tMDUGCCsGAQUFBzAChilodHRw # Oi8vcmVwb3NpdG9yeS5jZXJ0dW0ucGwvY2NzY2EyMDIxLmNlcjAfBgNVHSMEGDAW # gBTddF1MANt7n6B0yrFu9zzAMsBwzTAdBgNVHQ4EFgQUO6KtBpOBgmrlANVAnyiQ # C6W6lJwwSwYDVR0gBEQwQjAIBgZngQwBBAEwNgYLKoRoAYb2dwIFAQQwJzAlBggr # BgEFBQcCARYZaHR0cHM6Ly93d3cuY2VydHVtLnBsL0NQUzATBgNVHSUEDDAKBggr # BgEFBQcDAzAOBgNVHQ8BAf8EBAMCB4AwDQYJKoZIhvcNAQELBQADggIBAEQsN8wg # PMdWVkwHPPTN+jKpdns5AKVFjcn00psf2NGVVgWWNQBIQc9lEuTBWb54IK6Ga3hx # QRZfnPNo5HGl73YLmFgdFQrFzZ1lnaMdIcyh8LTWv6+XNWfoyCM9wCp4zMIDPOs8 # LKSMQqA/wRgqiACWnOS4a6fyd5GUIAm4CuaptpFYr90l4Dn/wAdXOdY32UhgzmSu # xpUbhD8gVJUaBNVmQaRqeU8y49MxiVrUKJXde1BCrtR9awXbqembc7Nqvmi60tYK # lD27hlpKtj6eGPjkht0hHEsgzU0Fxw7ZJghYG2wXfpF2ziN893ak9Mi/1dmCNmor # GOnybKYfT6ff6YTCDDNkod4egcMZdOSv+/Qv+HAeIgEvrxE9QsGlzTwbRtbm6gwY # YcVBs/SsVUdBn/TSB35MMxRhHE5iC3aUTkDbceo/XP3uFhVL4g2JZHpFfCSu2TQr # rzRn2sn07jfMvzeHArCOJgBW1gPqR3WrJ4hUxL06Rbg1gs9tU5HGGz9KNQMfQFQ7 # 0Wz7UIhezGcFcRfkIfSkMmQYYpsc7rfzj+z0ThfDVzzJr2dMOFsMlfj1T6l22GBq # 9XQx0A4lcc5Fl9pRxbOuHHWFqIBD/BCEhwniOCySzqENd2N+oz8znKooSISStnkN # aYXt6xblJF2dx9Dn89FK7d1IquNxOwt0tI5dMIIGYjCCBMqgAwIBAgIRAKQpO24e # 3denNAiHrXpOtyQwDQYJKoZIhvcNAQEMBQAwVTELMAkGA1UEBhMCR0IxGDAWBgNV # BAoTD1NlY3RpZ28gTGltaXRlZDEsMCoGA1UEAxMjU2VjdGlnbyBQdWJsaWMgVGlt # ZSBTdGFtcGluZyBDQSBSMzYwHhcNMjUwMzI3MDAwMDAwWhcNMzYwMzIxMjM1OTU5 # WjByMQswCQYDVQQGEwJHQjEXMBUGA1UECBMOV2VzdCBZb3Jrc2hpcmUxGDAWBgNV # BAoTD1NlY3RpZ28gTGltaXRlZDEwMC4GA1UEAxMnU2VjdGlnbyBQdWJsaWMgVGlt # ZSBTdGFtcGluZyBTaWduZXIgUjM2MIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIIC # CgKCAgEA04SV9G6kU3jyPRBLeBIHPNyUgVNnYayfsGOyYEXrn3+SkDYTLs1crcw/ # ol2swE1TzB2aR/5JIjKNf75QBha2Ddj+4NEPKDxHEd4dEn7RTWMcTIfm492TW22I # 8LfH+A7Ehz0/safc6BbsNBzjHTt7FngNfhfJoYOrkugSaT8F0IzUh6VUwoHdYDpi # ln9dh0n0m545d5A5tJD92iFAIbKHQWGbCQNYplqpAFasHBn77OqW37P9BhOASdmj # p3IijYiFdcA0WQIe60vzvrk0HG+iVcwVZjz+t5OcXGTcxqOAzk1frDNZ1aw8nFhG # EvG0ktJQknnJZE3D40GofV7O8WzgaAnZmoUn4PCpvH36vD4XaAF2CjiPsJWiY/j2 # xLsJuqx3JtuI4akH0MmGzlBUylhXvdNVXcjAuIEcEQKtOBR9lU4wXQpISrbOT8ux # +96GzBq8TdbhoFcmYaOBZKlwPP7pOp5Mzx/UMhyBA93PQhiCdPfIVOCINsUY4U23 # p4KJ3F1HqP3H6Slw3lHACnLilGETXRg5X/Fp8G8qlG5Y+M49ZEGUp2bneRLZoyHT # yynHvFISpefhBCV0KdRZHPcuSL5OAGWnBjAlRtHvsMBrI3AAA0Tu1oGvPa/4yeei # Ayu+9y3SLC98gDVbySnXnkujjhIh+oaatsk/oyf5R2vcxHahajMCAwEAAaOCAY4w # ggGKMB8GA1UdIwQYMBaAFF9Y7UwxeqJhQo1SgLqzYZcZojKbMB0GA1UdDgQWBBSI # YYyhKjdkgShgoZsx0Iz9LALOTzAOBgNVHQ8BAf8EBAMCBsAwDAYDVR0TAQH/BAIw # ADAWBgNVHSUBAf8EDDAKBggrBgEFBQcDCDBKBgNVHSAEQzBBMDUGDCsGAQQBsjEB # AgEDCDAlMCMGCCsGAQUFBwIBFhdodHRwczovL3NlY3RpZ28uY29tL0NQUzAIBgZn # gQwBBAIwSgYDVR0fBEMwQTA/oD2gO4Y5aHR0cDovL2NybC5zZWN0aWdvLmNvbS9T # ZWN0aWdvUHVibGljVGltZVN0YW1waW5nQ0FSMzYuY3JsMHoGCCsGAQUFBwEBBG4w # bDBFBggrBgEFBQcwAoY5aHR0cDovL2NydC5zZWN0aWdvLmNvbS9TZWN0aWdvUHVi # bGljVGltZVN0YW1waW5nQ0FSMzYuY3J0MCMGCCsGAQUFBzABhhdodHRwOi8vb2Nz # cC5zZWN0aWdvLmNvbTANBgkqhkiG9w0BAQwFAAOCAYEAAoE+pIZyUSH5ZakuPVKK # 4eWbzEsTRJOEjbIu6r7vmzXXLpJx4FyGmcqnFZoa1dzx3JrUCrdG5b//LfAxOGy9 # Ph9JtrYChJaVHrusDh9NgYwiGDOhyyJ2zRy3+kdqhwtUlLCdNjFjakTSE+hkC9F5 # ty1uxOoQ2ZkfI5WM4WXA3ZHcNHB4V42zi7Jk3ktEnkSdViVxM6rduXW0jmmiu71Z # pBFZDh7Kdens+PQXPgMqvzodgQJEkxaION5XRCoBxAwWwiMm2thPDuZTzWp/gUFz # i7izCmEt4pE3Kf0MOt3ccgwn4Kl2FIcQaV55nkjv1gODcHcD9+ZVjYZoyKTVWb4V # qMQy/j8Q3aaYd/jOQ66Fhk3NWbg2tYl5jhQCuIsE55Vg4N0DUbEWvXJxtxQQaVR5 # xzhEI+BjJKzh3TQ026JxHhr2fuJ0mV68AluFr9qshgwS5SpN5FFtaSEnAwqZv3IS # +mlG50rK7W3qXbWwi4hmpylUfygtYLEdLQukNEX1jiOKMIIGgjCCBGqgAwIBAgIQ # NsKwvXwbOuejs902y8l1aDANBgkqhkiG9w0BAQwFADCBiDELMAkGA1UEBhMCVVMx # EzARBgNVBAgTCk5ldyBKZXJzZXkxFDASBgNVBAcTC0plcnNleSBDaXR5MR4wHAYD # VQQKExVUaGUgVVNFUlRSVVNUIE5ldHdvcmsxLjAsBgNVBAMTJVVTRVJUcnVzdCBS # U0EgQ2VydGlmaWNhdGlvbiBBdXRob3JpdHkwHhcNMjEwMzIyMDAwMDAwWhcNMzgw # MTE4MjM1OTU5WjBXMQswCQYDVQQGEwJHQjEYMBYGA1UEChMPU2VjdGlnbyBMaW1p # dGVkMS4wLAYDVQQDEyVTZWN0aWdvIFB1YmxpYyBUaW1lIFN0YW1waW5nIFJvb3Qg # UjQ2MIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEAiJ3YuUVnnR3d6Lkm # gZpUVMB8SQWbzFoVD9mUEES0QUCBdxSZqdTkdizICFNeINCSJS+lV1ipnW5ihkQy # C0cRLWXUJzodqpnMRs46npiJPHrfLBOifjfhpdXJ2aHHsPHggGsCi7uE0awqKggE # /LkYw3sqaBia67h/3awoqNvGqiFRJ+OTWYmUCO2GAXsePHi+/JUNAax3kpqstbl3 # vcTdOGhtKShvZIvjwulRH87rbukNyHGWX5tNK/WABKf+Gnoi4cmisS7oSimgHUI0 # Wn/4elNd40BFdSZ1EwpuddZ+Wr7+Dfo0lcHflm/FDDrOJ3rWqauUP8hsokDoI7D/ # yUVI9DAE/WK3Jl3C4LKwIpn1mNzMyptRwsXKrop06m7NUNHdlTDEMovXAIDGAvYy # nPt5lutv8lZeI5w3MOlCybAZDpK3Dy1MKo+6aEtE9vtiTMzz/o2dYfdP0KWZwZIX # bYsTIlg1YIetCpi5s14qiXOpRsKqFKqav9R1R5vj3NgevsAsvxsAnI8Oa5s2oy25 # qhsoBIGo/zi6GpxFj+mOdh35Xn91y72J4RGOJEoqzEIbW3q0b2iPuWLA911cRxgY # 5SJYubvjay3nSMbBPPFsyl6mY4/WYucmyS9lo3l7jk27MAe145GWxK4O3m3gEFEI # kv7kRmefDR7Oe2T1HxAnICQvr9sCAwEAAaOCARYwggESMB8GA1UdIwQYMBaAFFN5 # v1qqK0rPVIDh2JvAnfKyA2bLMB0GA1UdDgQWBBT2d2rdP/0BE/8WoWyCAi/QCj0U # JTAOBgNVHQ8BAf8EBAMCAYYwDwYDVR0TAQH/BAUwAwEB/zATBgNVHSUEDDAKBggr # BgEFBQcDCDARBgNVHSAECjAIMAYGBFUdIAAwUAYDVR0fBEkwRzBFoEOgQYY/aHR0 # cDovL2NybC51c2VydHJ1c3QuY29tL1VTRVJUcnVzdFJTQUNlcnRpZmljYXRpb25B # dXRob3JpdHkuY3JsMDUGCCsGAQUFBwEBBCkwJzAlBggrBgEFBQcwAYYZaHR0cDov # L29jc3AudXNlcnRydXN0LmNvbTANBgkqhkiG9w0BAQwFAAOCAgEADr5lQe1oRLjl # ocXUEYfktzsljOt+2sgXke3Y8UPEooU5y39rAARaAdAxUeiX1ktLJ3+lgxtoLQhn # 5cFb3GF2SSZRX8ptQ6IvuD3wz/LNHKpQ5nX8hjsDLRhsyeIiJsms9yAWnvdYOdEM # q1W61KE9JlBkB20XBee6JaXx4UBErc+YuoSb1SxVf7nkNtUjPfcxuFtrQdRMRi/f # InV/AobE8Gw/8yBMQKKaHt5eia8ybT8Y/Ffa6HAJyz9gvEOcF1VWXG8OMeM7Vy7B # s6mSIkYeYtddU1ux1dQLbEGur18ut97wgGwDiGinCwKPyFO7ApcmVJOtlw9FVJxw # /mL1TbyBns4zOgkaXFnnfzg4qbSvnrwyj1NiurMp4pmAWjR+Pb/SIduPnmFzbSN/ # G8reZCL4fvGlvPFk4Uab/JVCSmj59+/mB2Gn6G/UYOy8k60mKcmaAZsEVkhOFuoj # 4we8CYyaR9vd9PGZKSinaZIkvVjbH/3nlLb0a7SBIkiRzfPfS9T+JesylbHa1LtR # V9U/7m0q7Ma2CQ/t392ioOssXW7oKLdOmMBl14suVFBmbzrt5V5cQPnwtd3UOTpS # 9oCG+ZZheiIvPgkDmA8FzPsnfXW5qHELB43ET7HHFHeRPRYrMBKjkb8/IN7Po0d0 # hQoF4TeMM+zYAJzoKQnVKOLg8pZVPT8wgga5MIIEoaADAgECAhEAmaOACiZVO2Wr # 3G6EprPqOTANBgkqhkiG9w0BAQwFADCBgDELMAkGA1UEBhMCUEwxIjAgBgNVBAoT # GVVuaXpldG8gVGVjaG5vbG9naWVzIFMuQS4xJzAlBgNVBAsTHkNlcnR1bSBDZXJ0 # aWZpY2F0aW9uIEF1dGhvcml0eTEkMCIGA1UEAxMbQ2VydHVtIFRydXN0ZWQgTmV0 # d29yayBDQSAyMB4XDTIxMDUxOTA1MzIxOFoXDTM2MDUxODA1MzIxOFowVjELMAkG # A1UEBhMCUEwxITAfBgNVBAoTGEFzc2VjbyBEYXRhIFN5c3RlbXMgUy5BLjEkMCIG # A1UEAxMbQ2VydHVtIENvZGUgU2lnbmluZyAyMDIxIENBMIICIjANBgkqhkiG9w0B # AQEFAAOCAg8AMIICCgKCAgEAnSPPBDAjO8FGLOczcz5jXXp1ur5cTbq96y34vuTm # flN4mSAfgLKTvggv24/rWiVGzGxT9YEASVMw1Aj8ewTS4IndU8s7VS5+djSoMcbv # IKck6+hI1shsylP4JyLvmxwLHtSworV9wmjhNd627h27a8RdrT1PH9ud0IF+njvM # k2xqbNTIPsnWtw3E7DmDoUmDQiYi/ucJ42fcHqBkbbxYDB7SYOouu9Tj1yHIohzu # C8KNqfcYf7Z4/iZgkBJ+UFNDcc6zokZ2uJIxWgPWXMEmhu1gMXgv8aGUsRdaCtVD # 2bSlbfsq7BiqljjaCun+RJgTgFRCtsuAEw0pG9+FA+yQN9n/kZtMLK+Wo837Q4QO # ZgYqVWQ4x6cM7/G0yswg1ElLlJj6NYKLw9EcBXE7TF3HybZtYvj9lDV2nT8mFSkc # SkAExzd4prHwYjUXTeZIlVXqj+eaYqoMTpMrfh5MCAOIG5knN4Q/JHuurfTI5XDY # O962WZayx7ACFf5ydJpoEowSP07YaBiQ8nXpDkNrUA9g7qf/rCkKbWpQ5boufUnq # 1UiYPIAHlezf4muJqxqIns/kqld6JVX8cixbd6PzkDpwZo4SlADaCi2JSplKShBS # ND36E/ENVv8urPS0yOnpG4tIoBGxVCARPCg1BnyMJ4rBJAcOSnAWd18Jx5n858JS # qPECAwEAAaOCAVUwggFRMA8GA1UdEwEB/wQFMAMBAf8wHQYDVR0OBBYEFN10XUwA # 23ufoHTKsW73PMAywHDNMB8GA1UdIwQYMBaAFLahVDkCw6A/joq8+tT4HKbROg79 # MA4GA1UdDwEB/wQEAwIBBjATBgNVHSUEDDAKBggrBgEFBQcDAzAwBgNVHR8EKTAn # MCWgI6Ahhh9odHRwOi8vY3JsLmNlcnR1bS5wbC9jdG5jYTIuY3JsMGwGCCsGAQUF # BwEBBGAwXjAoBggrBgEFBQcwAYYcaHR0cDovL3N1YmNhLm9jc3AtY2VydHVtLmNv # bTAyBggrBgEFBQcwAoYmaHR0cDovL3JlcG9zaXRvcnkuY2VydHVtLnBsL2N0bmNh # Mi5jZXIwOQYDVR0gBDIwMDAuBgRVHSAAMCYwJAYIKwYBBQUHAgEWGGh0dHA6Ly93 # d3cuY2VydHVtLnBsL0NQUzANBgkqhkiG9w0BAQwFAAOCAgEAdYhYD+WPUCiaU58Q # 7EP89DttyZqGYn2XRDhJkL6P+/T0IPZyxfxiXumYlARMgwRzLRUStJl490L94C9L # GF3vjzzH8Jq3iR74BRlkO18J3zIdmCKQa5LyZ48IfICJTZVJeChDUyuQy6rGDxLU # UAsO0eqeLNhLVsgw6/zOfImNlARKn1FP7o0fTbj8ipNGxHBIutiRsWrhWM2f8pXd # d3x2mbJCKKtl2s42g9KUJHEIiLni9ByoqIUul4GblLQigO0ugh7bWRLDm0CdY9rN # LqyA3ahe8WlxVWkxyrQLjH8ItI17RdySaYayX3PhRSC4Am1/7mATwZWwSD+B7eMc # ZNhpn8zJ+6MTyE6YoEBSRVrs0zFFIHUR08Wk0ikSf+lIe5Iv6RY3/bFAEloMU+vU # BfSouCReZwSLo8WdrDlPXtR0gicDnytO7eZ5827NS2x7gCBibESYkOh1/w1tVxTp # V2Na3PR7nxYVlPu1JPoRZCbH86gc96UTvuWiOruWmyOEMLOGGniR+x+zPF/2DaGg # K2W1eEJfo2qyrBNPvF7wuAyQfiFXLwvWHamoYtPZo0LHuH8X3n9C+xN4YaNjt2yw # zOr+tKyEVAotnyU9vyEVOaIYMk3IeBrmFnn0gbKeTTyYeEEUz/Qwt4HOUBCrW602 # NCmvO1nm+/80nLy5r0AZvCQxaQ4xggXDMIIFvwIBATBqMFYxCzAJBgNVBAYTAlBM # MSEwHwYDVQQKExhBc3NlY28gRGF0YSBTeXN0ZW1zIFMuQS4xJDAiBgNVBAMTG0Nl # cnR1bSBDb2RlIFNpZ25pbmcgMjAyMSBDQQIQCDJPnbfakW9j5PKjPF5dUTANBglg # hkgBZQMEAgEFAKCBhDAYBgorBgEEAYI3AgEMMQowCKACgAChAoAAMBkGCSqGSIb3 # DQEJAzEMBgorBgEEAYI3AgEEMBwGCisGAQQBgjcCAQsxDjAMBgorBgEEAYI3AgEV # MC8GCSqGSIb3DQEJBDEiBCDQnk2gy1zoEBAstXaTuc4FfvdGUeJSzkAjlbQZUkqz # +DANBgkqhkiG9w0BAQEFAASCAYCaTGeLdwaC4mAOEeFck31rdAq4WuL4ccxhjUNK # iI40H1LhUp/awO5THdQI4P1dQUKsbCpQ4mCrDoy7hiwkmQutDWFdJ51MDk/TljtN # 460uiETR7ec8zkR9/jtxcJUgvy1fC1i4f8QDhxo+QOrGzXwHsjZt6cdGQhmU16GV # sJ6IQ4zR31HqSkBUT30HIEAYcvVBNFg/2EpfdnWILHvu9mSodKNrJaRB6t0EztPq # Y7hZMOReGDvsKuBcH+1cLgy3I2/Pe7h7OOMLp+jUNsN1zOUUI6AYdn/PW6Ab+B22 # nU5X3OKJnp/ukIFdTGAiq9Yi3YfF7w4SDIG78Z4lNrab5uGHBDgcRee5ymLUZ83y # cD05BiNVwhBleS6SFqwJbj/k+4eQlMhsBeAoyzrK6e4F+f5YtmE0vUgkN9tARcEb # NU5/OemLDDgygqrMSbp2tP0NHFRN8XX9FxrbVtBWfjMzSMHHlL4af265xdlN6fnN # vIsRQ1lhG5K21kNoMU6hjg6awoahggMjMIIDHwYJKoZIhvcNAQkGMYIDEDCCAwwC # AQEwajBVMQswCQYDVQQGEwJHQjEYMBYGA1UEChMPU2VjdGlnbyBMaW1pdGVkMSww # KgYDVQQDEyNTZWN0aWdvIFB1YmxpYyBUaW1lIFN0YW1waW5nIENBIFIzNgIRAKQp # O24e3denNAiHrXpOtyQwDQYJYIZIAWUDBAICBQCgeTAYBgkqhkiG9w0BCQMxCwYJ # KoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0yNjAxMzAxOTEzMjZaMD8GCSqGSIb3 # DQEJBDEyBDB9QFz3WvaZNnbajdimujUmS+MwDz7KNCzD1hP+7jkw7RuIAM9JMxU7 # Xc3ih8tsgZEwDQYJKoZIhvcNAQEBBQAEggIADP6ozqveMTQ80n6wKn6HtWR91Wis # YcqBJhvni6da0t4v0KQVVFNjv7AL4ccx7bYNBWyXiuVrrM1NCzt6MDudRv/jJqNI # k6bcRSUp3EGimyE2OQd2GmeS3EQYUpVjtCcJn7/y/ohKBCIbHha1G4hkecoFlmhw # hOMpoEim+oE7KjXN1YpNmNr1wWL4ZGjpkU8UassZqD5r9GVbVFf+MMGGCjZJ8k/k # It7KhH+2FTi9IkLtTfGlVW4YiUKQzx7A0iDRnXI+KfVBm0nSrBIin1bO+i4MntUz # ge5uwx2vKldHeTtC9uKre8QmVN+o941AAyxW7e3QMhD8hJzr406GZhmkyYtt+q+Z # WeijR/2zus1I/8PK0qlfX/YoYrX89ZU7HQ2S6rfgGVLNKjalZqeBaVFu0V/x+MdK # UwILNPKYDbo4dbUvxePdlfALa3Ysfnk8QITXoDfjPFcoZ4sxxFktc3vkP537C6be # ZL1mdYA4eBI4x5o1b5KXITT37t3q/ldWAb5EU5Ha/WRJ7M9w6FE/T/ku9ANGqPI5 # SD5v/m9Z9klz1rsmML4zKSC5RYaLnbaL7ffpAsijiny2QB0Btr2VucgYcq6XmVae # 1nXNhxQl6Uf5I3A2+h6r+8JtNtaCX0s/OaaRjRoTCWgptfzfynP2Z7cqZmw/3+Jj # 5vdvSwHSu7vj2q0= # SIG # End signature block |