TD.Util.psm1
|
[Diagnostics.CodeAnalysis.SuppressMessageAttribute("PSAvoidGlobalVars", "")] param( [parameter(Mandatory = $false)][HashTable]$ImportVars ) $quiet = $false if ($ImportVars -and $ImportVars.ContainsKey('Quiet')) { $quiet = $ImportVars.Quiet } if (!($quiet)) { $tdUtilModule = 'TD.Util' $manifest = Test-ModuleManifest -Path (Join-Path (Split-Path $MyInvocation.MyCommand.Path) "$tdUtilModule.psd1") -WarningAction SilentlyContinue Write-Host "$tdUtilModule Version $($manifest.Version.ToString()) by $($manifest.Author)" Write-Host "Proudly created in Schiedam (NLD), $($manifest.Copyright)"; } function Add-AdoAzureArmEndpoint { param( [alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $ProjectId, $ApiVersion = '7.0', $Name, $SubscriptionId, $SubscriptionName, $TenantId, $ServicePrincipalId, $ServicePrincipalKey ) $endPoint = @{ data = @{ subscriptionId = $SubscriptionId subscriptionName = $SubscriptionName environment = "AzureCloud" scopeLevel = "Subscription" creationMode = "Manual" } name = $Name type = "AzureRM" url = "https=//management.azure.com/" authorization = @{ parameters = @{ tenantid = $TenantId serviceprincipalid = $ServicePrincipalId authenticationType = "spnKey" serviceprincipalkey = $ServicePrincipalKey } scheme = "ServicePrincipal" } isShared = $false isReady = $true serviceEndpointProjectReferences = @( @{ projectReference = @{ id = $ProjectId name = $Project } name = $Name } ) } # alternative: az devops service-endpoint create # $endPoint = @" # { # "data": { # "subscriptionId": "$SubscriptionId", # "subscriptionName": "$SubscriptionName", # "environment": "AzureCloud", # "scopeLevel": "Subscription", # "creationMode": "Manual" # }, # "name": "$Name", # "type": "AzureRM", # "url": "https://management.azure.com/", # "authorization": { # "parameters": { # "tenantid": "$TenantId", # "serviceprincipalid": "$ServicePrincipalId", # "authenticationType": "spnKey", # "serviceprincipalkey": "$ServicePrincipalKey" # }, # "scheme": "ServicePrincipal" # }, # "isShared": false, # "isReady": true, # "serviceEndpointProjectReferences": [ # { # "projectReference": { # "id": "$ProjectId", # "name": "$Project" # }, # "name": "$Name" # } # ] # } # "@ $res = Add-AdoEndpoint -u $Uri -t $AdoAuthToken -Organization $Organization -Project $Project -EndPoint $endPoint -ApiVersion $ApiVersion return $res } function Add-AdoBuildDefinition { param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $Definition, [switch]$AsJson, $ApiVersion = '6.0') $url = "$(Get-AdoUri -Uri $AdoUri -Project $Project -Organization $Organization)/_apis/build/definitions?api-version=$($ApiVersion)" if ($AsJson.IsPresent) { $body = $Definition } else { $body = $Definition | ConvertTo-Json -Depth 10 -Compress } $result = Invoke-RestMethod -Method Post -Uri $url -Body $body -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 return $result } function Add-AdoElasticPool { param( [alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, [ValidateNotNullOrEmpty()]$Name, [ValidateNotNullOrEmpty()]$AuthorizeAllPipelines, [ValidateNotNullOrEmpty()]$AutoProvisionProjectPools, $ProjectId, [ValidateNotNullOrEmpty()]$Body, $ApiVersion = '7.0' ) $extraParams = '' if ($ProjectId) { $extraParams = "&projectId=$($ProjectId)" } $url = "$(Get-AdoUri -Uri $AdoUri -Organization $Organization)/_apis/distributedtask/elasticpools?poolName=$($Name)&authorizeAllPipelines=$($AuthorizeAllPipelines)&autoProvisionProjectPools=$($AutoProvisionProjectPools)$($extraParams)&api-version=$($ApiVersion)" if (($Body -is [HashTable]) -or ($Body -is [PSCustomObject])) { $jsonBody = $Body | ConvertTo-Json -Depth 5 } else { $jsonBody = $Body } $result = Invoke-RestMethod -Method Post -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 -Body $jsonBody return $result } function Add-AdoEndpoint { param( [alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $EndPoint, [switch]$AsJson, $ApiVersion = '7.0' ) $url = "$(Get-AdoUri -Uri $AdoUri -Project $Project -Organization $Organization)/_apis/serviceendpoint/endpoints?api-version=$($ApiVersion)" if ($AsJson.IsPresent) { $body = $EndPoint } else { $body = $EndPoint | ConvertTo-Json -Depth 10 -Compress } $result = Invoke-RestMethod -Method Post -Uri $url -Body $body -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 return $result } function Add-AdoEnvironment { param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $Name, $Description, $ApiVersion = '7.0') $url = "$(Get-AdoUri -Uri $AdoUri -Project $Project -Organization $Organization)/_apis/distributedtask/environments?api-version=$($ApiVersion)" $body = @{ name = $Name description = $Description } $jsonBody = $body | ConvertTo-Json -Depth 5 $result = Invoke-RestMethod -Method Post -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 -Body $jsonBody return $result.Value } function Add-AdoPool { param( [alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Name, $Body, $ApiVersion = '7.0' ) $url = "$(Get-AdoUri -Uri $AdoUri -Organization $Organization)/_apis/distributedtask/pools?api-version=$($ApiVersion)" if ($null -eq $Body) { $Body = @{ name = $Name } } if (($Body -is [HashTable]) -or ($Body -is [PSCustomObject])) { $jsonBody = $Body | ConvertTo-Json -Depth 5 } else { $jsonBody = $Body } $result = Invoke-RestMethod -Method Post -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 -Body $jsonBody return $result } function Add-AdoProject { param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $ApiVersion = '5.0', $Organization, $Project, $Description, [switch]$Wait) $url = "$(Get-AdoUri $AdoUri '' $Organization)/_apis/projects?api-version=$ApiVersion" $request = @{ name = $Project description = $Description capabilities = @{ versioncontrol = @{ sourceControlType = 'Git' } processTemplate = @{ templateTypeId = '6b724908-ef14-45cf-84f8-768b5384da45' } } } $body = $request | ConvertTo-Json -Depth 10 -Compress $result = Invoke-RestMethod -Method Post -Uri $url -Body $body -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 if ($Wait.IsPresent) { $timeOut = 60 * 5 $url = $result.url $timer = [Diagnostics.Stopwatch]::StartNew() $finished = $false while (!$finished) { Start-Sleep -Seconds 5 $o = Invoke-RestMethod -Method Get -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 if ($o.status -eq 'succeeded') { $finished = $true } if ($timer.Elapsed.TotalSeconds -gt $timeOut ) { Write-Warning "Project creation to long $($timeout)s"; $finished = $true } #[Console]::Write('.') } $timer.Stop() } return $result } function Add-AdoPullRequest { param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $RepoId, $SourceRefName, $TargetRefName = 'master', $Description = 'PR Created via REST API', $User = 'monitor', $ApiVersion = '6.0') $url = "$(Get-AdoUri -Uri $AdoUri -Project $Project -Organization $Organization)/_apis/git/repositories/$RepoId/pullRequests?api-version=$($ApiVersion)" $ref = "refs/heads/" $sourceBranch = "$Ref$SourceRefName" $targetBranch = "$Ref$TargetRefName" $request = @{ sourceRefName = $sourceBranch targetRefName = $targetBranch title = "Merge $SourceRefName to $TargetRefName by $User" description = $Description autoCompleteSetBy = @{ id = $User displayName = $User } createdBy = @{ id = $User displayName = $User } } $body = $request | ConvertTo-Json -Depth 10 -Compress $result = Invoke-RestMethod -Method Post -Uri $url -Body $body -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 return $result.pullRequestId } function Add-AdoRepository { param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $Repo, $ApiVersion = '6.0') $url = "$(Get-AdoUri -Uri $AdoUri -Project $Project -Organization $Organization)/_apis/git/repositories?api-version=$($ApiVersion)" $request = @{ name = $Repo } $body = $request | ConvertTo-Json -Depth 10 -Compress $result = Invoke-RestMethod -Method Post -Uri $url -Body $body -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 return $result } function Add-AdoVariableGroup { param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $Vars, $Type, $Name, $Description, $ApiVersion = '5.1-preview.1') $url = "$(Get-AdoUri -Uri $AdoUri -Project $Project -Organization $Organization)/_apis/distributedtask/variablegroups?api-version=$($ApiVersion)" $body = @{ variables = $Vars type = $Type name = $Name description = $Description } | ConvertTo-Json -Depth 10 -Compress $result = Invoke-RestMethod -Method Post -Uri $url -Body $body -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 return $result.id } function Get-AdoAllRepositories { param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Filter = { $_ }, $ApiVersion = '5.0') $repositories = @() $projects = Get-AdoProjects -AdoUri $AdoUri -AdoAuthToken $AdoAuthToken -Organization $Organization -ApiVersion $ApiVersion foreach ($project in $projects) { $projectRepositories = Get-AdoRepositories -AdoUri $AdoUri -AdoAuthToken $AdoAuthToken -Organization $Organization -Project $project.name $projectRepositories = $projectRepositories | Where-Object $Filter foreach ($r in $projectRepositories) { $defBranch = '' if (Test-PSProperty $r 'defaultBranch') { $defBranch = $r.defaultBranch } $repositories += [PSCustomObject]@{ Project = $project.name Name = $r.name Id = $r.id DefaultBranch = $defBranch RemoteUrl = $r.RemoteUrl Url = $r.url WebUrl = $r.webUrl Object = $r } } } return , ($repositories | Sort-Object -Property Project, Name) } function Get-AdoApiResult([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Method = 'Get', [alias('Body')]$aBody, $ContentType) { $params = @{} if ($aBody) { $params.Add('Body', $aBody) } if ($ContentType) { $params.Add('ContentType', $ContentType) } return Invoke-RestMethod -Uri $AdoUri -Method $Method -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 @params } function Get-AdoBuild { param( [alias('u', 'Uri')][string]$AdoUri, [ValidateNotNullOrEmpty()][alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, [ValidateNotNullOrEmpty()]$Project, [ValidateNotNull()]$Id, $ApiVersion = '5.0' ) $url = "$(Get-AdoUri $AdoUri $Project $Organization)/_apis/build/builds/$($Id)?api-version=$ApiVersion" $build = Invoke-RestMethod -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 return $build } function Get-AdoBuildDefinition { param( [alias('u', 'Uri')][string]$AdoUri, [ValidateNotNullOrEmpty()][alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, [ValidateNotNullOrEmpty()]$Project, [ValidateNotNullOrEmpty()]$Id, $ApiVersion = '7.0' ) $url = "$(Get-AdoUri $AdoUri $project $Organization)/_apis/build/definitions/$($Id)?includeAllProperties=true&includeLatestBuilds=true&api-version=$ApiVersion" $def = Invoke-RestMethod -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 return $def.Value } function Get-AdoBuildDefinitions { param( [alias('u', 'Uri')][string]$AdoUri, [ValidateNotNullOrEmpty()][alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, [ValidateNotNullOrEmpty()]$Project, [switch]$Expand, $ApiVersion = '7.0' ) $extraValues = $null if ($Expand.IsPresent) { $extraValues = 'includeAllProperties=true&includeLatestBuilds=true&' } $url = "$(Get-AdoUri $AdoUri $project $Organization)/_apis/build/definitions?$($extraValues)api-version=$ApiVersion" $defs = Invoke-RestMethod -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 return , $defs.Value } function Get-AdoBuildLog { param( [alias('u', 'Uri')][string]$AdoUri, [ValidateNotNullOrEmpty()][alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, [ValidateNotNullOrEmpty()]$Project, [ValidateNotNull()]$Id, [ValidateNotNull()]$LogId, $ApiVersion = '7.0' ) $url = "$(Get-AdoUri $AdoUri $Project $Organization)/_apis/build/builds/$($Id)/logs/$($LogId)?api-version=$ApiVersion" $log = Invoke-RestMethod -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 return $log } function Get-AdoBuildLogs { param( [alias('u', 'Uri')][string]$AdoUri, [ValidateNotNullOrEmpty()][alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, [ValidateNotNullOrEmpty()]$Project, [ValidateNotNull()]$Id, $ApiVersion = '7.0' ) $url = "$(Get-AdoUri $AdoUri $Project $Organization)/_apis/build/builds/$($Id)/logs?api-version=$ApiVersion" $logs = Invoke-RestMethod -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 return , $logs.value } function Get-AdoBuildOutput { param( [alias('u', 'Uri')][string]$AdoUri, [ValidateNotNullOrEmpty()][alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, [ValidateNotNullOrEmpty()]$Project, [ValidateNotNull()]$Id, $ApiVersion = '6.0' ) $params = @{ Organization = $Organization Project = $Project } if ($AdoUri) { [void]$params.Add('AdoUri', $AdoUri) } if ($AdoAuthToken) { [void]$params.Add('AdoAuthToken', $AdoAuthToken) } $output = $null $logs = Get-AdoBuildLogs @params -Id $Id foreach ($log in $logs) { $output += Get-AdoBuildLog @params -Id $Id -LogId $log.id } return $output } function Get-AdoBuilds { param( [alias('u', 'Uri')][string]$AdoUri, [ValidateNotNullOrEmpty()][alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, [ValidateNotNullOrEmpty()]$Project, [ValidateNotNull()]$DefinitionId, $StatusFilter, [switch]$NoLimit, $ApiVersion = '6.0' ) $limit = 'maxBuildsPerDefinition=50&' if ($NoLimit.IsPresent) { $limit = '' } $url = "$(Get-AdoUri $AdoUri $Project $Organization)/_apis/build/builds?$($limit)queryOrder=startTimeDescending&definitions=$($DefinitionId)&statusFilter=$StatusFilter&api-version=$ApiVersion" $builds = Invoke-RestMethod -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 return , $builds.value } function Get-AdoBuildTimeline { param( [alias('u', 'Uri')][string]$AdoUri, [ValidateNotNullOrEmpty()][alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, [ValidateNotNullOrEmpty()]$Project, [ValidateNotNull()]$Id, [ValidateNotNull()]$TimelineId, $ApiVersion = '6.0' ) $url = "$(Get-AdoUri $AdoUri $Project $Organization)/_apis/build/builds/$($Id)/timeline/$($TimelineId)?api-version=$ApiVersion" $build = Invoke-RestMethod -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 return $build } function Get-AdoElasticPool { param( [alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $PoolId, $ApiVersion = '7.0' ) $url = "$(Get-AdoUri -Uri $AdoUri -Organization $Organization)/_apis/distributedtask/elasticpools/$($PoolId)?api-version=$ApiVersion" $p = Invoke-RestMethod -Method Get -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 return $p } function Get-AdoEndPoint { param( [alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $Id, $ApiVersion = '7.0' ) $url = "$(Get-AdoUri $AdoUri $Project $Organization)/_apis/serviceendpoint/endpoints/$($Id)?api-version=$ApiVersion" $endpoint = Invoke-RestMethod -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 return $endpoint } function Get-AdoEndPoints { param( [alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $ApiVersion = '7.0', $Type, [switch]$Detailed ) $detailOption = '' if ($detailed.IsPresent) { $detailOption = 'includeDetails=true&' } $typeOption = '' if ($Type) { $typeOption = "type=$type&" } $url = "$(Get-AdoUri $AdoUri $Project $Organization)/_apis/serviceendpoint/endpoints?$($typeOption)$($detailOption)api-version=$ApiVersion" $endpoints = Invoke-RestMethod -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 return , $endpoints.Value } function Get-AdoEnvironments { param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $ApiVersion = '7.0') $url = "$(Get-AdoUri -Uri $AdoUri -Project $Project -Organization $Organization)/_apis/distributedtask/environments?api-version=$($ApiVersion)" $result = Invoke-RestMethod -Method Get -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 return $result.Value } function Get-AdoPipeline { param( [alias('u', 'Uri')][string]$AdoUri, [ValidateNotNullOrEmpty()][alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, [ValidateNotNullOrEmpty()]$Project, [ValidateNotNull()]$Id, $ApiVersion = '7.0' ) $url = "$(Get-AdoUri $AdoUri $Project $Organization)/_apis/pipelines/$($Id)?api-version=$ApiVersion" $pipeline = Invoke-RestMethod -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 return $pipeline } function Get-AdoPipelineApprovals { param( [alias('u', 'Uri')][string]$AdoUri, [ValidateNotNullOrEmpty()][alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, [ValidateNotNullOrEmpty()]$Project, $Ids, $ApiVersion = '7.1-preview.1' ) $url = "$(Get-AdoUri $AdoUri $Project $Organization)/_apis/pipelines/approvals?approvalIds=$Ids&api-version=$ApiVersion" $approvals = Invoke-RestMethod -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 return , $approvals.value } function Get-AdoPipelineChecks { param( [alias('u', 'Uri')][string]$AdoUri, [ValidateNotNullOrEmpty()][alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, [ValidateNotNullOrEmpty()]$Project, $ApiVersion = '7.1-preview.1' ) $url = "$(Get-AdoUri $AdoUri $Project $Organization)/_apis/pipelines/checks/configurations?api-version=$ApiVersion" $approvals = Invoke-RestMethod -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 return , $approvals.value } function Get-AdoPipelinePendingApprovals { param( [alias('u', 'Uri')][string]$AdoUri, [ValidateNotNullOrEmpty()][alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, [ValidateNotNullOrEmpty()]$Project, $BuildDefinitionId, $ApiVersion = '7.1-preview.1' ) $splat = @{ Token = $AdoAuthToken Organization = $Organization Project = $Project } if ($BuildDefinitionId) { $bd = @{ DefinitionId = $BuildDefinitionId } } else { $bd = @{} } $builds = Get-AdoBuilds @splat -StatusFilter 'inProgress,notStarted' @bd $approvals = @() foreach ($b in $builds) { $bt = Get-AdoBuildTimeline @splat -Id $b.id -TimelineId $b.orchestrationPlan.planId $buildApprovals = $bt.records | Where-Object { ($_.type -eq 'Checkpoint.Approval' -and $_.state -eq 'inProgress') } foreach ($buildApproval in $buildApprovals) { $apr = Get-AdoPipelineApprovals @splat -Ids $buildApproval.id if ($apr -and ($null -ne $apr[0])) { $checkpoint = $bt.records | Where-Object { $_.id -eq $buildApproval.parentId } $stage = $bt.records | Where-Object { $_.id -eq $checkpoint.parentId } $approvals += @{ BuildDefinition = $b.Definition.id BuildName = $b.Definition.name BuildId = $b.Id BuildUrl = $b._links.web.href StageId = $stage.id Stage = $stage.identifier StageName = $stage.name ApprovalId = $apr[0].id Approval = $apr[0] } } } } return $approvals } function Get-AdoPipelinePermission { param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $ResourceType, $ResourceId, $ApiVersion = '6.1-preview.1') $url = "$(Get-AdoUri -Uri $AdoUri -Project $Project -Organization $Organization)/_apis/pipelines/pipelinePermissions/$($ResourceType)/$($ResourceId)?api-version=$($ApiVersion)" $result = Invoke-RestMethod -Method Get -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 return $result } function Get-AdoPipelineRun { param( [alias('u', 'Uri')][string]$AdoUri, [ValidateNotNullOrEmpty()][alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, [ValidateNotNullOrEmpty()]$Project, [ValidateNotNull()]$Id, [ValidateNotNull()]$RunId, $ApiVersion = '7.0' ) $url = "$(Get-AdoUri $AdoUri $Project $Organization)/_apis/pipelines/$($Id)/runs/$($RunId)?api-version=$ApiVersion" $run = Invoke-RestMethod -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 return $run } function Get-AdoPipelineRunLog { param( [alias('u', 'Uri')][string]$AdoUri, [ValidateNotNullOrEmpty()][alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, [ValidateNotNullOrEmpty()]$Project, [ValidateNotNull()]$Id, [ValidateNotNull()]$RunId, [ValidateNotNull()]$LogId, $ApiVersion = '7.0' ) $url = "$(Get-AdoUri $AdoUri $Project $Organization)/_apis/pipelines/$($Id)/runs/$($RunId)/logs/$($LogId)?`$expand=signedContent&api-version=$ApiVersion" $log = Invoke-RestMethod -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 return $log } function Get-AdoPipelineRunLogs { param( [alias('u', 'Uri')][string]$AdoUri, [ValidateNotNullOrEmpty()][alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, [ValidateNotNullOrEmpty()]$Project, [ValidateNotNull()]$Id, [ValidateNotNull()]$RunId, $ApiVersion = '7.0' ) $url = "$(Get-AdoUri $AdoUri $Project $Organization)/_apis/pipelines/$($Id)/runs/$($RunId)/logs?api-version=$ApiVersion" $logs = Invoke-RestMethod -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 return , $logs.logs } function Get-AdoPipelineRunOutput { param( [alias('u', 'Uri')][string]$AdoUri, [ValidateNotNullOrEmpty()][alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, [ValidateNotNullOrEmpty()]$Project, [ValidateNotNull()]$Id, [ValidateNotNull()]$RunId, [switch]$All, $ApiVersion = '7.0' ) $params = @{ Organization = $Organization Project = $Project ApiVersion = $ApiVersion } if ($AdoUri) { [void]$params.Add('AdoUri', $AdoUri) } if ($AdoAuthToken) { [void]$params.Add('AdoAuthToken', $AdoAuthToken) } $output = $null $logs = Get-AdoPipelineRunLogs @params -Id $Id -RunId $RunId foreach ($log in $logs) { $l = Get-AdoPipelineRunLog @params -Id $Id -RunId $RunId -LogId $log.id $contents = Invoke-RestMethod -Uri $l.signedContent.url $output += $contents if (!($All.IsPresent)) { break } } return $output } function Get-AdoPipelineRuns { param( [alias('u', 'Uri')][string]$AdoUri, [ValidateNotNullOrEmpty()][alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, [ValidateNotNullOrEmpty()]$Project, [ValidateNotNull()]$Id, $ApiVersion = '7.0' ) $url = "$(Get-AdoUri $AdoUri $Project $Organization)/_apis/pipelines/$($Id)/runs?api-version=$ApiVersion" $runs = Invoke-RestMethod -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 return , $runs.value } function Get-AdoPipelines { param( [alias('u', 'Uri')][string]$AdoUri, [ValidateNotNullOrEmpty()][alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, [ValidateNotNullOrEmpty()]$Project, $StatusFilter, $ApiVersion = '7.0' ) $url = "$(Get-AdoUri $AdoUri $Project $Organization)/_apis/pipelines?api-version=$ApiVersion" $pipelines = Invoke-RestMethod -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 return , $pipelines.value } function Get-AdoPool { param( [alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $PoolId, $ApiVersion = '7.0' ) $url = "$(Get-AdoUri -Uri $AdoUri -Organization $Organization)/_apis/distributedtask/pools/$($PoolId)?api-version=$ApiVersion" $p = Invoke-RestMethod -Method Get -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 return $p } function Get-AdoPools { param( [alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $ApiVersion = '7.0' ) $url = "$(Get-AdoUri -Uri $AdoUri -Organization $Organization)/_apis/distributedtask/pools?api-version=$($ApiVersion)" $pools = Invoke-RestMethod -Method Get -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 return , $pools.value } function Get-AdoProject { [CmdletBinding()] param( [alias('u', 'Uri')][string]$AdoUri, [ValidateNotNullOrEmpty()][alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, [ValidateNotNullOrEmpty()]$Project, $ApiVersion = '7.0' ) try { $prj = $null $url = "$(Get-AdoUri $AdoUri '' $Organization)/_apis/projects/$($Project)?includeCapabilities=true&includeHistory=true&api-version=$ApiVersion" $prj = Invoke-RestMethod -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 } catch { if ($ErrorActionPreference -ne 'Ignore') { Throw } } return $prj } function Get-AdoProjectBuilds { param( [alias('u', 'Uri')][string]$AdoUri, [ValidateNotNullOrEmpty()][alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, $Project = '', $Filter = { $_ }, [switch]$IncludeMissingBuilds, [switch]$NoDistinct, [string]$DetectScanningString = 'job: Security', $ApiVersion = '7.0' ) $buildCollection = [System.Collections.ArrayList]::New() $params = @{ Organization = $Organization Project = $Project ApiVersion = $ApiVersion } if ($AdoUri) { [void]$params.Add('AdoUri', $AdoUri) } if ($AdoAuthToken) { [void]$params.Add('AdoAuthToken', $AdoAuthToken) } if ([string]::IsNullOrEmpty($Project)) { $projects = Get-AdoProjects @params } else { $projects = Get-AdoProjects @params -Project $Project } foreach ($prj in $projects) { $definitions = Get-AdoBuildDefinitions @params -Project $prj.name -Expand foreach ($definition in $definitions) { $ignore = $false $team = '' if (Test-PsProperty $definition 'variables') { if (Test-PsProperty $definition.variables 'team') { $team = $definition.variables.Team.value } if (Test-PsProperty $definition.variables 'ignore-build') { $ignore = ($definition.variables.'Ignore-build'.value -eq 'true' ) } } if ($ignore) { continue; } $procType = -1 $procYaml = '' if (Test-PsProperty $definition 'process') { if (Test-PsProperty $definition.process 'type') { $procType = $definition.process.type $procYaml = if ($procType -eq 2 ) { $definition.process.yamlFilename } else { '' } } } $added = $false $builds = Get-AdoBuilds @params -Project $prj.name -DefinitionId $definition.id $totalBuilds = $builds.count $cnt = 0 $builds | Where-Object $Filter | ForEach-Object { if (!($NoDistinct.IsPresent) -and ($cnt -ge 1) ) { return } $added = $true if (Test-PsProperty -o $_ -p startTime) { $startTime = [DateTime]$_.startTime } else { $startTime = [DateTime]$definition.createdDate } if (Test-PsProperty -o $_ -p finishTime) { $finishTime = [DateTime]$_.finishTime } else { $finishTime = [DateTime]$definition.createdDate } if (Test-PsProperty -o $_ -p queueTime) { $queueTime = [DateTime]$_.queueTime } else { $queueTime = [DateTime]$definition.createdDate } if (Test-PsProperty -o $_ -p result -Exact $true) { $result = $_.result } else { $result = '' } $duration = $finishTime - $startTime try { # we use optimalization here and asume we always have logId 1 $log = Get-AdoBuildLog @params -Project $prj.Name -Id $_.id -LogId 1 #$build.Id } catch { $log = '' } $hasScanning = $log.Contains($DetectScanningString) [void]$buildCollection.Add([PSCustomObject]@{ Project = $_.project.name Definition = $_.definition.name Team = $team Name = $_.buildNumber Id = $_.id BuildNumber = $_.buildNumber Status = $_.status Result = $result StartTime = $startTime FinishTime = $FinishTime QueueTime = $queueTime Duration = $duration Branch = $_.sourceBranch Tags = $_.tags Reason = $_.reason Url = $_.url WebUrl = $_._links.web.href DefUrl = $definition._links.web.href Object = $_ ProcessType = $procType ProcessYaml = $procYaml TotalBuilds = $totalBuilds User = $_.requestedBy.displayName Missing = $false Log = $log HasScanning = $hasScanning }) $cnt++ } if ($IncludeMissingBuilds.IsPresent -and !$added -and (-not($definition.Name.StartsWith('xxx'))) ) { $startTime = [DateTime]$definition.createdDate $finishTime = [DateTime]$definition.createdDate $queueTime = [DateTime]$definition.createdDate $result = '' $branch = '' $duration = '' $user = '' if ($totalBuilds -gt 0) { $lastBuild = $builds | Select-Object -First 1 if ($lastBuild) { if (Get-HasPsProperty -o $lastBuild -p startTime) { $startTime = [DateTime]$lastBuild.startTime } if (Get-HasPsProperty -o $lastBuild -p finishTime) { $finishTime = [DateTime]$lastBuild.finishTime } if (Get-HasPsProperty -o $lastBuild -p queueTime) { $queueTime = [DateTime]$lastBuild.queueTime } $duration = $finishTime - $startTime #if (Get-HasPsProperty -o $lastBuild -p result -Exact $true) { $result = $lastBuild.result } #$branch = $lastBuild.sourceBranch $user = $lastBuild.requestedBy.displayName } } [void]$buildCollection.Add([PSCustomObject]@{ Project = $prj.name Definition = $definition.name Team = $team Name = '' Id = -1 BuildNumber = '' Status = 'notStarted' Result = $result StartTime = $startTime FinishTime = $finishTime QueueTime = $queueTime Duration = $duration Branch = $branch Tags = '' Reason = 'undefined' Url = $definition.url WebUrl = '' DefUrl = $definition._links.web.href Object = $definition ProcessType = $procType ProcessYaml = $procYaml TotalBuilds = $totalBuilds User = $user Missing = $true HasScanning = $false }) } } } return , ($buildCollection | Sort-Object -Property Project, Definition, Name, Status, Result, @{Expression = 'FinishTime'; Descending = $true }) } function Get-AdoProjects { param( [alias('u', 'Uri')][string]$AdoUri, [ValidateNotNullOrEmpty()][alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, $Project, $ApiVersion = '7.0' ) $url = "$(Get-AdoUri $AdoUri '' $Organization)/_apis/projects/$($Project)?api-version=$ApiVersion" $projects = Invoke-RestMethod -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 if ($Project) { return , $projects } else { return , $projects.Value } } function Get-AdoQueue { param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $ApiVersion = '6.0-preview.1', $Organization, $Project, $Queue) $url = "$(Get-AdoUri $AdoUri $Project $Organization)/_apis/distributedtask/queues?queueName=$($Queue)&api-version=$ApiVersion" $q = Invoke-RestMethod -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 return $q } function Get-AdoReleaseApprovals { param( [alias('u', 'Uri')][string]$AdoUri, [ValidateNotNullOrEmpty()][alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, [ValidateNotNullOrEmpty()]$Project, [ValidateNotNull()]$StatusFilter = 'pending', $ApiVersion = '6.0' ) $url = "$(Get-AdoUri $AdoUri $Project $Organization)/_apis/release/approvals?api-version=$ApiVersion" $url = Get-AdoVsRmUrl $url $approvals = Invoke-RestMethod -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 return , $approvals.value } function Get-AdoRepositories { param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $ApiVersion = '5.0') $url = "$(Get-AdoUri $AdoUri $Project $Organization)/_apis/git/repositories?includeLinks=true&includeAllUrls=true&includeHidden=true&api-version=$ApiVersion" $repositories = Invoke-RestMethod -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 return , $repositories.Value } function Get-AdoRepository { param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $Repo, $ApiVersion = '5.0') $url = "$(Get-AdoUri $AdoUri $Project $Organization)/_apis/git/repositories/$($Repo)?includeLinks=true&includeAllUrls=true&includeHidden=true&api-version=$ApiVersion" $repo = Invoke-RestMethod -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 return $repo } function Get-AdoRepositoryPolicy { param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $RepoId, $RefName, $ApiVersion = '5.0') if ($RepoId) { $url = "$(Get-AdoUri $AdoUri $Project $Organization)/_apis/git/policy/configurations?repositoryId=$($RepoId)&refName=$($RefName)&api-version=$ApiVersion" } else { $url = "$(Get-AdoUri $AdoUri $Project $Organization)/_apis/git/policy/configurations?api-version=$ApiVersion" } $policies = Invoke-RestMethod -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 return ,$policies.Value } function Get-AdoUri { param($Uri, $Project, $Organization) if ($Uri) { $lUri = [System.Uri]$Uri } else { if ($env:SYSTEM_TEAMFOUNDATIONCOLLECTIONURI) { $lUri = [System.Uri]$env:SYSTEM_TEAMFOUNDATIONCOLLECTIONURI } else { if ($Organization) { $lUri = [System.Uri]"https://dev.azure.com/$Organization" } else { Throw "Unable to create Azure DevOps organization url, no Organization defined" } } } if ($Project) { $uriBuilder = [System.UriBuilder]$lUri if ($uriBuilder.Path.EndsWith('/')) { $s = '' } else { $s = '/' } $uriBuilder.Path += "$s$Project" $lUri = $uriBuilder.Uri } return $lUri.ToString() } function Get-AdoVariableGroup { param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $Name, $ApiVersion = '5.1-preview.1') $url = "$(Get-AdoUri -Uri $AdoUri -Project $Project -Organization $Organization)/_apis/distributedtask/variablegroups/?groupName=$($Name)&actionFilter=none&api-version=$($ApiVersion)" $result = Invoke-RestMethod -Method Get -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 return $result.Value } function Get-AdoVsRmUrl($Url) { return $Url.Replace('dev.azure.com', 'vsrm.dev.azure.com') } <# .SYNOPSIS Get the Azure DevOps Personal Access Token from Azure Devops Hosted Agent (In build/deploy) or the Windows Credential Store .DESCRIPTION Get the Azure DevOps Personal Access Token from Azure Devops Hosted Agent (In build/deploy) or the Windows Credential Store. This function is MS Windows only when running local. .PARAMETER Url Url of the Azure DevOps subscription like https://(mycompany)@dev.azure.com/(mycompany) .Example $token = Get-AzureDevOpsAccessToken 'https://mycompany@dev.azure.com/mycompany') #> function Get-AzureDevOpsAccessToken([Parameter(Mandatory = $true)][ValidateNotNullOrEmpty()]$Url) { Write-Verbose "Get-AzureDevOpsAccessToken $Url" $token = $env:SYSTEM_ACCESSTOKEN if ([string]::IsNullOrEmpty($token)) { if ($env:windir) { if (-not(Get-Module CredentialManager -ListAvailable)) { Install-Module CredentialManager -Scope CurrentUser -Force } Import-Module CredentialManager $credential = Get-StoredCredential -Target "git:$Url" if ($null -eq $credential) { Throw "No Azure DevOps credentials found in credential store" } Write-Verbose "Using Azure DevOps Access Token from Windows Credential Store" $token = $credential.GetNetworkCredential().Password } else { Write-Warning "Unable to resolve Azure DevOps (ADO) Credential on platforms other than Windows" } } return $token } <# .SYNOPSIS Get the Azure DevOps Credentials from Azure Devops Hosted Agent (In build/deploy) or the Windows Credential Store .DESCRIPTION Get the Azure DevOps Credentials from Azure Devops Hosted Agent (In build/deploy) or the Windows Credential Store. This function is MS Windows only when running local. .PARAMETER Url Url of the Azure DevOps subscription like https://(mycompany)@dev.azure.com/(mycompany) .Example $cred = Get-AzureDevOpsCredential 'https://mycompany@dev.azure.com/mycompany') #> function Get-AzureDevOpsCredential([Parameter(Mandatory = $true)][ValidateNotNullOrEmpty()]$Url) { Write-Verbose "Get-AzureDevOpsCredential $Url" $token = $env:SYSTEM_ACCESSTOKEN if ([string]::IsNullOrEmpty($token)) { if ($env:windir) { if (-not(Get-Module CredentialManager -ListAvailable)) { Install-Module CredentialManager -Scope CurrentUser -Force } Import-Module CredentialManager $credential = Get-StoredCredential -Target "git:$Url" if ($null -eq $credential) { Throw "No Azure DevOps credentials found. It should be passed in via env:SYSTEM_ACCESSTOKEN." } Write-Verbose "Using Azure DevOps Access Token from Windows Credential Store" } else { Write-Warning "Unable to resolve Azure DevOps (ADO) Credential on platforms other than Windows" } } else { Write-Verbose "Using Azure DevOps Access Token from Hosted Agent" $secureToken = $token | ConvertTo-SecureString -AsPlainText -Force $credential = New-Object System.Management.Automation.PSCredential(".", $secureToken) } return $credential } function Grant-AdoPipelineResourceAccess { param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $Access, [switch]$AsJson, $ApiVersion = '6.0') $url = "$(Get-AdoUri -Uri $AdoUri -Project $Project -Organization $Organization)/_apis/pipelines/pipelinePermissions?api-version=$($ApiVersion)" if ($AsJson.IsPresent) { $body = $Access } else { $body = $Access | ConvertTo-Json -Depth 10 -Compress } $result = Invoke-RestMethod -Method Patch -Uri $url -Body $body -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 return $result } <# .SYNOPSIS Import PowerShell module(s) and if not found install them from Azure DevOps Artifacts .DESCRIPTION Import PowerShell module(s) and if not found install them from Azure DevOps Artifacts .PARAMETER PackageSource Azure DevOps packagesource name .PARAMETER Modules Array of modules to import .PARAMETER Credential Credentials to access feed .PARAMETER Latest Always import latest modules .EXAMPLE Register-AzureDevOpsPackageSource -Name myFeed -Url https://pkgs.dev.azure.com/myCompany/_packaging/myFeed/nuget/v2 Import-AzureDevOpsModules -PackageSource 'myFeed' -Modules @('myModule') -Latest #> function Import-AzureDevOpsModules([Parameter(Mandatory = $true)][ValidateNotNullOrEmpty()]$PackageSource, [Parameter(Mandatory = $true)]$Modules, [System.Management.Automation.PSCredential]$Credential, [Switch]$Latest) { Write-Verbose "Import-AzureDevOpsModules '$Modules' from $PackageSource" foreach ($module in $Modules) { if (-not (Get-Module -ListAvailable -Name $module) -or $Latest.IsPresent) { Install-Module $module -Repository $PackageSource -Scope CurrentUser -Force -AllowClobber -Credential $Credential } else { Import-Module $module } } } function Invoke-AdoCreateRelease { param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $DefinitionId, $BuildId, $BuildAlias, $Reason = 'UserCreated', $ApiVersion = '5.0') $body = @{ "definitionId" = "$($DefinitionId)"; "reason" = "$Reason" } $body.Add("artifacts", @()) $artifact = @{ "alias" = "$($BuildAlias)" "instanceReference" = @{ "id" = "$($BuildId)" "name" = $null } } $body.artifacts += $artifact $jsonBody = $body | ConvertTo-Json -Depth 5 $url = "$(Get-AdoUri $AdoUri $Project $Organization)/_apis/release/releases?api-version=$ApiVersion" $url = Get-AdoVsRmUrl $url $release = Get-AdoApiResult -AdoUri $url -AdoAuthToken $AdoAuthToken -Method Post -Body $jsonBody -ContentType 'application/json' return $release } function Invoke-AdoQueueBuild { param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $Id, $Branch, $Reason = 'UserCreated', $ApiVersion = '5.0') if ($Branch) { $lBranch = $Branch } else { $lBranch = '' } $body = "{`"definition`": { `"id`": $Id }, reason: `"$Reason`", priority: `"Normal`", tags: `"`", sourceBranch: `"$lBranch`"}" $url = "$(Get-AdoUri $AdoUri $Project $Organization)/_apis/build/builds?api-version=$ApiVersion" $build = Get-AdoApiResult -AdoUri $url -AdoAuthToken $AdoAuthToken -Method Post -Body $body -ContentType 'application/json' return $build } function Invoke-AdoQueuePipeline { # Remark: To use templatedParameters you need to supply all parameters. Tip: use browser dev console tools to see usage of call in ADO Web Application # ref: https://learn.microsoft.com/en-us/rest/api/azure/devops/pipelines/runs/run-pipeline?view=azure-devops-rest-7.0 param( [alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $Id, $Branch, [HashTable]$Parameters, [HashTable]$Variables, [Array]$StagesToSkip, [Switch]$Preview, [Switch]$Debug, $ApiVersion = '7.0') $body = @{} if ($Branch) { $body.resources = @{ "repositories" = @{ "self" = @{ "refName" = $Branch } } } } if ($Preview) { $body.previewRun = $true } if ($StagesToSkip) { $body.stagesToSkip = $StagesToSkip } if ($Parameters) { $body.templateParameters = $Parameters } else { $body.templateParameters = @{} } if ($Variables) { $body.variables = $Variables } else { $body.variables = @{} } if ($Debug) { $body.variables.'system.debug' = $true $body.variables.'agent.diagnostic' = $true } $url = "$(Get-AdoUri $AdoUri $Project $Organization)/_apis/pipelines/$($Id)/runs?api-version=$ApiVersion" $build = Get-AdoApiResult -AdoUri $url -AdoAuthToken $AdoAuthToken -Method Post -Body ($body | ConvertTo-Json -Depth 10 -Compress) -ContentType 'application/json' return $build } function New-AdoAuthenticationToken([alias('p', 'Pat')][string] $Token) { $accessToken = ""; if ($Token) { $user = "" $encodedToken = [Convert]::ToBase64String([Text.Encoding]::ASCII.GetBytes(("{0}:{1}" -f $User, $Token))) $accessToken = "Basic $encodedToken" } elseif ($env:SYSTEM_ACCESSTOKEN) { $accessToken = "Bearer $($env:SYSTEM_ACCESSTOKEN)" } else { Throw "No AccessToken or Personal Access Token (PAT) supplied" } return $accessToken; } <# .SYNOPSIS Publish the PowerShell Package to the Azure Devops Feed / Artifacts .DESCRIPTION Publish the PowerShell Package to the Azure Devops Feed / Artifacts. Depends on nuget.exe installed and in environment path. Strategy: - Register feed with nuget - Register local temp feed to use Powershell Publish-Module command - Publish locally created module to feed with nuget.exe .PARAMETER ModuleName Name of the PowerShell Module to publish .PARAMETER ModulePath Root path of the module .PARAMETER Feedname Name of the Azure DevOps feed .PARAMETER FeedUrl Url of the Azure DevOps feed .PARAMETER AccessToken Personal AccessToken used for Azure DevOps Feed push/publish .Example Publish-PackageToAzureDevOps -ModuleName 'MyModule' -ModulePath './Output' -Feedname 'MyFeed' -FeedUrl 'https://pkgs.dev.azure.com/mycompany/_packaging/MyFeed/nuget/v2' -AccessToken 'sasasasa' #> function Publish-PackageToAzureDevOps([Parameter(Mandatory = $true)][ValidateNotNullOrEmpty()]$ModuleName, $ModulePath = './Output', [Parameter(Mandatory = $true)][ValidateNotNullOrEmpty()]$Feedname, [Parameter(Mandatory = $true)][ValidateNotNullOrEmpty()]$FeedUrl, [Parameter(Mandatory = $true)][ValidateNotNullOrEmpty()]$AccessToken) { Write-Verbose "Publish-PackageToAzureDevOps $ModuleName" $packageSource = $Feedname $packageFeedUrl = $FeedUrl $deployPath = Join-Path $ModulePath $ModuleName # register nuget feed $nuGet = (Get-Command 'nuget').Source &$nuGet sources Remove -Name $packageSource [string]$r = &$nuGet sources if (!($r.Contains($packageSource))) { # add as NuGet feed Write-Verbose "Add NuGet source" &$nuGet sources Add -Name $packageSource -Source $packageFeedUrl -username "." -password $AccessToken } # get module version $manifestFile = "./$ModuleName/$ModuleName.psd1" $manifest = Import-PowerShellDataFile -Path $manifestFile $version = $manifest.Item('ModuleVersion') if (!$version) { Throw "No module version found in $manifestFile" } else { Write-Host "$moduleName version: $version" } $tmpFeedPath = Join-Path ([System.IO.Path]::GetTempPath()) "$(New-Guid)-Localfeed" New-Item -Path $tmpFeedPath -ItemType Directory -ErrorAction Ignore -Force | Out-Null try { # register temp feed for export package # maybe need to use temp name for feed !! if (Get-PSRepository -Name LocalFeed -ErrorAction Ignore) { Unregister-PSRepository -Name LocalFeed } Register-PSRepository -Name LocalFeed -SourceLocation $tmpFeedPath -PublishLocation $tmpFeedPath -InstallationPolicy Trusted try { # publish to temp feed $packageName = "$moduleName.$version.nupkg" $package = (Join-Path $tmpFeedPath $packageName) Write-Verbose "Publish Module $package" Publish-Module -Path $deployPath -Repository LocalFeed -Force -ErrorAction Ignore if (!(Test-Path $package)) { Throw "Nuget package $package not created" } # publish package from tmp/local feed to PS feed Write-Verbose "Push package $packageName in $tmpFeedPath" Push-Location $tmpFeedPath try { nuget push $packageName -source $packageSource -Apikey Az -NonInteractive if ($LastExitCode -ne 0) { Throw "Error pushing nuget package $packageName to feed $packageSource ($packageFeedUrl)" } } finally { Pop-Location } } finally { Unregister-PSRepository -Name LocalFeed -ErrorAction Ignore } } finally { Remove-Item -Path $tmpFeedPath -Force -Recurse } } <# .SYNOPSIS Registers a package source from AzureDevOps Feed / Artifacts .DESCRIPTION Registers a package source from AzureDevOps Feed /Artifacts. If already found removes reference first. .PARAMETER Name Name of package source .PARAMETER Url Url of package feed .PARAMETER Credential Credentials to access feed .Example Register-AzureDevOpsPackageSource -Name myFeed -Url https://pkgs.dev.azure.com/myCompany/_packaging/myFeed/nuget/v2 #> function Register-AzureDevOpsPackageSource([Parameter(Mandatory = $true)][ValidateNotNullOrEmpty()]$Name, [Parameter(Mandatory = $true)][ValidateNotNullOrEmpty()]$Url, [System.Management.Automation.PSCredential]$Credential) { Write-Verbose "Register-AzureDevOpsPackageSource $Name" if ($Credential) { Write-Verbose "Performing Credential check..." try { Invoke-RestMethod -Uri $Url -Credential $Credential | Out-Null # check for access to artifacts with credential } catch { Throw "Register-AzureDevOpsPackageSource error for $Url : $($_.Exception.Message)" } } try { if (Get-PSRepository -Name $Name -ErrorAction Ignore) { Unregister-PSRepository -Name $Name } Register-PSRepository -Name $Name -SourceLocation $Url -InstallationPolicy Trusted -Credential $Credential } catch { if ($env:windir) { if ($_.Exception.Message -eq "The property 'Name' cannot be found on this object. Verify that the property exists.") { Write-Warning "Maybe invalid PSRepositories.xml detected in 'C:\Users\$($env:USERNAME)\AppData\Local\Microsoft\Windows\PowerShell\PowerShellGet', check file for correctness" } } Write-Host $_ Throw } } function Remove-AdoBuildDefinition { [CmdletBinding()] param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $ApiVersion = '6.0', $Organization, $Project, $BuildDefinitionId) $url = "$(Get-AdoUri -Uri $AdoUri -Project $Project -Organization $Organization)/_apis/build/definitions/$($BuildDefinitionId)?api-version=$ApiVersion" Invoke-RestMethod -Method Delete -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 } function Remove-AdoEnvironment { param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $EnvironmentId, $ApiVersion = '7.0') $url = "$(Get-AdoUri -Uri $AdoUri -Project $Project -Organization $Organization)/_apis/distributedtask/environments/$($EnvironmentId)?api-version=$($ApiVersion)" Invoke-RestMethod -Method Delete -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 } function Remove-AdoPool { param( [alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $PoolId, $ApiVersion = '7.0' ) $url = "$(Get-AdoUri -Uri $AdoUri -Organization $Organization)/_apis/distributedtask/pools/$($PoolId)?api-version=$($ApiVersion)" Invoke-RestMethod -Method Delete -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 } function Remove-AdoProject { [CmdletBinding()] param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $ApiVersion = '6.0', $Organization, $ProjectId) try { $prj = $null $url = "$(Get-AdoUri $AdoUri '' $Organization)/_apis/projects/$($ProjectId)?api-version=$ApiVersion" $prj = Invoke-RestMethod -Method Delete -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 } catch { if ($ErrorActionPreference -ne 'Ignore') { Throw } } return $prj } function Remove-AdoRepository { [CmdletBinding()] param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $ApiVersion = '6.0', $Organization, $Project, $RepoId) $url = "$(Get-AdoUri -Uri $AdoUri -Project $Project -Organization $Organization)/_apis/git/repositories/$($RepoId)?api-version=$ApiVersion" Invoke-RestMethod -Method Delete -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 } function Remove-AdoServiceConnection { [CmdletBinding()] param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $ApiVersion = '6.0-preview.4', $Organization, $ProjectIds, $EndPointId, [switch]$DeleteSpn) $url = "$(Get-AdoUri -Uri $AdoUri -Project '' -Organization $Organization)/_apis/serviceendpoint/endpoints/$($EndpointId)?projectIds=$($ProjectIds)&deep=$($DeleteSpn.IsPresent)&api-version=$ApiVersion" Invoke-RestMethod -Method Delete -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -TimeoutSec 60 } function Remove-AdoVariableGroup { param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, [alias('Id')]$aId, $ApiVersion = '5.1-preview.1') $url = "$(Get-AdoUri -Uri $AdoUri -Project $Project -Organization $Organization)/_apis/distributedtask/variablegroups/$($aId)?api-version=$($ApiVersion)" Invoke-RestMethod -Method Delete -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 } function Test-BuildDefinitionExists($BuildDefinitions, $BuildDefinitionName) { foreach ($def in $BuildDefinitions) { if ($def.name -eq $BuildDefinitionName) { return $true } } return $false } function Test-EndPointExists($EndPoints, $EndPointName) { foreach ($ep in $EndPoints) { if ($ep.name -eq $EndPointName) { return $true } } return $false } function Test-ProjectExists($Projects, $ProjectName) { foreach ($project in $Projects) { if ($project.name -eq $ProjectName) { return $true } } return $false } function Test-RepositoryExists($Repos, $RepoName) { foreach ($repo in $Repos) { if ($repo.name -eq $RepoName) { return $true } } return $false } function Test-VariableGroupExists($VariableGroups, $VariableGroupName) { foreach ($grp in $VariableGroups) { if ($grp.name -eq $VariableGroupName) { return $true } } return $false } function Update-AdoAzureArmEndpoint { param( [alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $ProjectId, $EndPointId, $ApiVersion = '7.0', $Name, $SubscriptionId, $SubscriptionName, $TenantId, $ServicePrincipalId, $ServicePrincipalKey ) $endPoint = @{ data = @{ subscriptionId = $SubscriptionId subscriptionName = $SubscriptionName environment = "AzureCloud" scopeLevel = "Subscription" creationMode = "Manual" } name = $Name type = "AzureRM" url = "https=//management.azure.com/" authorization = @{ parameters = @{ tenantid = $TenantId serviceprincipalid = $ServicePrincipalId authenticationType = "spnKey" serviceprincipalkey = $ServicePrincipalKey } scheme = "ServicePrincipal" } isShared = $false isReady = $true serviceEndpointProjectReferences = @( @{ projectReference = @{ id = $ProjectId name = $Project } name = $Name } ) } $res = Update-AdoEndpoint -u $Uri -t $AdoAuthToken -Organization $Organization -Project $Project -EndPoint $endPoint -EndPointId $EndPointId -ApiVersion $ApiVersion return $res } function Update-AdoElasticPool { param( [alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $PoolId, $Body, $ApiVersion = '7.0' ) $url = "$(Get-AdoUri -Uri $AdoUri -Organization $Organization)/_apis/distributedtask/elasticpools/$($PoolId)?api-version=$($ApiVersion)" if ($null -eq $Body) { throw "No details (Body) information supplied in Update-AdoElasticPool, see https://learn.microsoft.com/en-us/rest/api/azure/devops/distributedtask/elasticpools/update?view=azure-devops-rest-7.0 for more details" } if (($Body -is [HashTable]) -or ($Body -is [PSCustomObject])) { $jsonBody = $Body | ConvertTo-Json -Depth 5 } else { $jsonBody = $Body } $result = Invoke-RestMethod -Method Patch -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 -Body $jsonBody return $result } function Update-AdoEndpoint { param( [alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $EndPointId, $EndPoint, [switch]$AsJson, $ApiVersion = '7.0' ) $url = "$(Get-AdoUri -Uri $AdoUri -Project $Project -Organization $Organization)/_apis/serviceendpoint/endpoints/$($EndPointId)?api-version=$($ApiVersion)" if ($AsJson.IsPresent) { $body = $EndPoint } else { $body = $EndPoint | ConvertTo-Json -Depth 10 -Compress } $result = Invoke-RestMethod -Method Put -Uri $url -Body $body -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 return $result } function Update-AdoEnvironment { param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $EnvironmentId, $Name, $Description, $ApiVersion = '7.0') $url = "$(Get-AdoUri -Uri $AdoUri -Project $Project -Organization $Organization)/_apis/distributedtask/environments/$($EnvironmentId)?api-version=$($ApiVersion)" $body = @{ name = $Name description = $Description } $jsonBody = $body | ConvertTo-Json -Depth 5 $result = Invoke-RestMethod -Method Patch -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 -Body $jsonBody return $result.Value } function Update-AdoPipelineApproval { param( [alias('u', 'Uri')][string]$AdoUri, [ValidateNotNullOrEmpty()][alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, [ValidateNotNullOrEmpty()]$Project, [Parameter(Mandatory)][ValidateNotNull()]$ApprovalId, [ValidateSet('approved', 'canceled', 'skipped', 'rejected')]$Status, $Comment = '', $ApiVersion = '6.1-preview.1' ) $url = "$(Get-AdoUri -Uri $AdoUri -Project $Project -Organization $Organization)/_apis/pipelines/approvals?api-version=$($ApiVersion)" $approvals = @( @{ approvalId = $ApprovalId comment = $Comment status = $Status } ) $body = $approvals | ConvertTo-Json -AsArray -Depth 10 -Compress $result = Invoke-RestMethod -Method Patch -Uri $url -Body $body -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 return $result } function Update-AdoPipelinePermission { param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $ResourceType, $ResourceId, $PipelineId, $ApiVersion = '6.1-preview.1') $url = "$(Get-AdoUri -Uri $AdoUri -Project $Project -Organization $Organization)/_apis/pipelines/pipelinePermissions/$($ResourceType)/$($ResourceId)?api-version=$($ApiVersion)" $permission = @{ pipelines = @( @{ id = $PipelineId authorized = $true } ) } $body = $permission | ConvertTo-Json -Depth 10 -Compress $result = Invoke-RestMethod -Method Patch -Uri $url -Body $body -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 return $result } function Update-AdoPipelinePermissions { param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, $Resources, $ApiVersion = '6.1-preview.1') $url = "$(Get-AdoUri -Uri $AdoUri -Project $Project -Organization $Organization)/_apis/pipelines/pipelinePermissions?api-version=$($ApiVersion)" $body = $Resources | ConvertTo-Json -Depth 10 -Compress $result = Invoke-RestMethod -Method Patch -Uri $url -Body $body -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 return $result } function Update-AdoPool { param( [alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $PoolId, $Body, $ApiVersion = '7.0' ) $url = "$(Get-AdoUri -Uri $AdoUri -Organization $Organization)/_apis/distributedtask/pools/$($PoolId)?api-version=$($ApiVersion)" if ($null -eq $Body) { throw "No details (Body) information supplied in Update-AdoPool, see https://learn.microsoft.com/en-us/rest/api/azure/devops/distributedtask/pools/update?view=azure-devops-rest-7.0 for more details" } if (($Body -is [HashTable]) -or ($Body -is [PSCustomObject])) { $jsonBody = $Body | ConvertTo-Json -Depth 5 } else { $jsonBody = $Body } $result = Invoke-RestMethod -Method Patch -Uri $url -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 -Body $jsonBody return $result } function Update-AdoVariableGroup { param([alias('u', 'Uri')][string]$AdoUri, [alias('t', 'Token', 'Pat')][string]$AdoAuthToken, $Organization, $Project, [alias('Id')]$aId, $Vars, $Type, $Name, $Description, $ApiVersion = '5.1-preview.1') $url = "$(Get-AdoUri -Uri $AdoUri -Project $Project -Organization $Organization)/_apis/distributedtask/variablegroups/$($aId)?api-version=$($ApiVersion)" $vars = @{ variables = $Vars name = $Name } if ($Type) { $vars.Add('type', $Type) | Out-Null } if ($Description) { $vars.Add('description', $Description) | Out-Null } $body = $vars | ConvertTo-Json -Depth 10 -Compress $result = Invoke-RestMethod -Method Put -Uri $url -Body $body -Headers @{Authorization = "$(New-AdoAuthenticationToken $AdoAuthToken)" } -ContentType 'application/json' -TimeoutSec 60 return $result.id } function Wait-AdoBuildCompleted { param( [alias('u', 'Uri')][string]$AdoUri, [ValidateNotNullOrEmpty()][alias('t', 'Token', 'Pat')][string]$AdoAuthToken, [ValidateNotNullOrEmpty()]$Organization, [ValidateNotNullOrEmpty()]$Project, [ValidateNotNull()]$Id, $TimeOut = 600, $ApiVersion = '5.0' ) $timer = [Diagnostics.Stopwatch]::StartNew() $finished = $false while (!$finished) { Start-Sleep -Seconds 5 $b = Get-AdoBuild -Token $AdoAuthToken -Organization $Organization -Project $Project -Id $Id if ($b.status -eq 'completed') { $finished = $true } elseif ($timer.Elapsed.TotalSeconds -gt $TimeOut) { Write-Warning "Build running to long $($Timeout)s, aborting wait for build completion" $finished = $true } [Console]::Write('.') } $timer.Stop() return $finished } <# .SYNOPSIS Get Azure Keyvault secrets and add them to token collection .DESCRIPTION Get secrets from Azure Keyvault and add them to token collection, use default logged-in account to Azure or try to get it from 'az cli' .PARAMETER Vault Name of the Azure KeyVault .PARAMETER Tokens Hashtable to add secrets to .PARAMETER SubscriptionId Azure Subscription ID .Example $Tokens = @{} Add-TokensFromAzureKeyVault -Vault 'MyVaultName' -Tokens $Tokens -SubscriptionId 'mySubscriptionId' #> function Add-TokensFromAzureKeyVault([Parameter(Mandatory = $true)][ValidateNotNullOrEmpty()]$Vault, [Parameter(Mandatory = $true)]$Tokens, $SubscriptionId) { Write-Verbose "Add-TokensFromAzureKeyVault" Write-Verbose " Vault: $Vault" Write-Verbose " SubscriptionId: $SubscriptionId" function Add-Secret($Name, $Value) { if (!$Tokens.ContainsKey($Name)) { Write-Host "Adding secret $Name : ******* to Token Store" $Tokens.Add($Name, $Value) } } Connect-ToAzure if ($SubscriptionId) { Select-AzureDefaultSubscription -SubscriptionId $SubscriptionId } $warning = (Get-Item Env:\SuppressAzurePowerShellBreakingChangeWarnings -ErrorAction Ignore) -eq 'true' Set-Item Env:\SuppressAzurePowerShellBreakingChangeWarnings "true" try { try { $secrets = Get-AzKeyVaultSecret -VaultName $Vault foreach ($secret in $secrets) { $s = Get-AzKeyVaultSecret -VaultName $Vault -Name $secret.Name -ErrorAction Ignore if ($s) { #$pass = $s.SecretValue | ConvertFrom-SecureString -AsPlainText $cred = New-Object System.Management.Automation.PSCredential($secret.Name, $s.SecretValue) Add-Secret $secret.Name $cred # Secret alternative name support by using KeyVault Secrets Tags 'alt-name', additional second token is created with this name. # Use it to circumvent Azure KeyVault Secret name character restrictions if ($s.Tags -and $s.Tags.ContainsKey('alt-name')) { $cred = New-Object System.Management.Automation.PSCredential($s.Tags.'alt-name', $s.SecretValue) Add-Secret $s.Tags.'alt-name' $cred } } } } catch { # Generic KeyVaultErrorException if ($_.Exception.Message.Contains("Operation returned an invalid status code 'Forbidden'")) { Write-Warning "Check if your service principal '$(([Microsoft.Azure.Commands.Common.Authentication.Abstractions.AzureRmProfileProvider]::Instance.Profile).DefaultContext.Account.Id)' has Secret and Certificate Permissions (List,Get) for this KeyVault '$Vault'. Check the Vaults Access Policies" } Throw } } finally { Set-Item Env:\SuppressAzurePowerShellBreakingChangeWarnings $warning } } <# .SYNOPSIS Assert if logged-in to Azure with powershell Az modules .DESCRIPTION Assert if logged-in to Azure with powershell Az modules .Example Assert-AzureConnected #> function Assert-AzureConnected { Initialize-AzureModules $azProfile = [Microsoft.Azure.Commands.Common.Authentication.Abstractions.AzureRmProfileProvider]::Instance.Profile if (-not $azProfile.Accounts.Count) { Throw "Powershell Az error: Ensure you are logged in." } } <# .SYNOPSIS Connect to Azure with Powershell Az modules .DESCRIPTION Connect to Azure with Powershell Az modules, use 'az cli' as fallback to connect .PARAMETER Force Always re-authenticated when used .Example Connect-ToAzure #> function Connect-ToAzure([Switch]$Force) { Write-Verbose "Connect-ToAzure" # check already logged-in to Azure if (!(Test-AzureConnected) -or $Force.IsPresent) { # try to find logged-in user via az cli if installed Write-Verbose 'Connect to azure with Azure Cli configuration' try { $token = $(az account get-access-token --query accessToken --output tsv) $id = $(az account show --query user.name --output tsv) if ($token -and $id) { Connect-AzAccount -AccessToken $token -AccountId $id -Scope Process } } catch { # use default, already connected user in this session } } Assert-AzureConnected $azProfile = [Microsoft.Azure.Commands.Common.Authentication.Abstractions.AzureRmProfileProvider]::Instance.Profile Write-Verbose "Az Account: $($azProfile.DefaultContext.Account.Id)" Write-Verbose "Az Subscription: $($azProfile.DefaultContext.Subscription.Name) - $($azProfile.DefaultContext.Subscription.Id)" } <# .SYNOPSIS Initializes (install or import) the Azure Az modules into current Powershell session .DESCRIPTION Initializes (install or import) the Azure Az modules into current Powershell session .Example Initialize-AzureModules #> function Initialize-AzureModules { if ($Global:AzureInitialized) { return } if ($null -eq (Get-Module -ListAvailable 'Az')) { Write-Host "Installing Az modules, can take some time." Install-Module -Name Az -AllowClobber -Scope CurrentUser -Repository PSGallery -Force } else { if (!(Get-Module -Name Az)) { Import-Module Az -Scope local -Force } } if ($null -eq (Get-Module -ListAvailable 'Az.Accounts')) { Install-Module -Name Az.Accounts -AllowClobber -Scope CurrentUser -Repository PSGallery -Force } else { if (!(Get-Module -Name Az.Accounts)) { Import-Module Az.Accounts -Scope local -Force } } if ($null -eq (Get-Module -ListAvailable 'Az.KeyVault')) { Install-Module -Name Az.KeyVault -AllowClobber -Scope CurrentUser -Repository PSGallery -Force } else { if (!(Get-Module -Name Az.KeyVault)) { Import-Module Az.KeyVault -Scope local -Force } } $Global:AzureInitialized = $true } $Global:AzureInitialized = $false <# .SYNOPSIS Select the Azure default subscription .DESCRIPTION Select the Azure default subscription .PARAMETER SubscriptionId The Azure subscription Id .Example Select-AzureDefaultSubscription -SubscriptionId 'myid' #> function Select-AzureDefaultSubscription([Parameter(Mandatory = $true)][ValidateNotNullOrEmpty()]$SubscriptionId) { Assert-AzureConnected $ctxList = Get-AzContext -ListAvailable foreach ($ctx in $ctxList) { if ($ctx.Subscription.Id -eq $SubscriptionId) { Write-Verbose "Select context: $($ctx.Name)" Select-AzContext -Name $ctx.Name return } } Throw "Azure subscription '$SubscriptionId' not found" } <# .SYNOPSIS Test if logged-in to Azure with powershell Az modules .DESCRIPTION Test if logged-in to Azure with powershell Az modules .Example Test-AzureConnected #> function Test-AzureConnected { Initialize-AzureModules try { $azProfile = [Microsoft.Azure.Commands.Common.Authentication.Abstractions.AzureRmProfileProvider]::Instance.Profile return !(-not $azProfile.Accounts.Count) } catch { return $false } } <# .SYNOPSIS Get tokens from config repository and add them to token collection .DESCRIPTION Get tokens from xml config repository and add them to token collection .PARAMETER ConfigPath Root path of the xml config files .PARAMETER Tokens HashTable to add tokens to .PARAMETER Env Token environment filter, filter the tokens by environment like local, develop, test etc... .Example $Tokens = @{} Add-TokensFromConfig -ConfigPath "$PSScriptRoot/config" -Tokens $Tokens -Env 'local' #> function Add-TokensFromConfig([Parameter(Mandatory = $true)][ValidateNotNullOrEmpty()]$ConfigPath, [Parameter(Mandatory = $true)]$Tokens, [Parameter(Mandatory = $true)][ValidateNotNullOrEmpty()]$Env, $Module) { function Add-Var($Nodes, $NameProp = 'name', $ValueProp = 'value', $Prefix) { foreach ($node in $Nodes) { $name = '' $value = $null if (Test-PSProperty $node $NameProp) { $name = $node."$NameProp" } if (Test-PSProperty $node $ValueProp) { $value = Get-PSPropertyValue $node "$ValueProp" if ($value -and $value.StartsWith('$')) { $value = Invoke-Expression "Write-Output `"$($value)`"" } } $pre = $Prefix if ($node.LocalName -eq 'node') { if ($node.ParentNode.ParentNode.name -ne $Env) { continue } } elseif ($node.LocalName -eq 'system-user') { if ($node.ParentNode.LocalName -eq 'application') { $name = '' $pre = "$Prefix$($node.ParentNode.name)" } } if ($pre) { $kn = "$pre$name" Write-Host "Adding variable '$kn' = '$value' to Token Store" if (!$Tokens.ContainsKey($kn)) { $Tokens.Add($kn, $value) } } else { if (!$Tokens.ContainsKey($name)) { Write-Host "Adding variable '$name' = '$value' to Token Store" $Tokens.Add($name, $value) } } } } function Add-Modules($Nodes, $Module) { foreach ($node in $Nodes) { if ($Module -and ($node.name -ne $Module)) { continue } Write-Host "Adding module '$($node.name)' to Token Store" $Tokens.Add("module-$($node.name)", $node.name) $Tokens.Add("module-$($node.name)-role", (Get-PSPropertyValue $node role)) $Tokens.Add("module-$($node.name)-depends", (Get-PSPropertyValue $node depends)) $Tokens.Add("module-$($node.name)-folder", (Get-PSPropertyValue $node folder)) $nodeApps = $node.SelectNodes(".//application") foreach ($nodeApp in $NodeApps) { Write-Host "Adding module '$($node.name)' application '$($nodeApp.name)' to Token Store" $Tokens.Add("module-$($node.name)-application-$($nodeApp.name)", $nodeApp.name) $Tokens.Add("module-$($node.name)-application-$($nodeApp.name)-type", (Get-PSPropertyValue $nodeApp type)) $Tokens.Add("module-$($node.name)-application-$($nodeApp.name)-role", (Get-PSPropertyValue $nodeApp role)) $Tokens.Add("module-$($node.name)-application-$($nodeApp.name)-service", (Get-PSPropertyValue $nodeApp service)) $Tokens.Add("module-$($node.name)-application-$($nodeApp.name)-exe", (Get-PSPropertyValue $nodeApp exe)) $Tokens.Add("module-$($node.name)-application-$($nodeApp.name)-dotnet-version", (Get-PSPropertyValue $nodeApp 'dotnet-version')) if (!$Tokens.ContainsKey("application-$($nodeApp.name)")) { $Tokens.Add("application-$($nodeApp.name)", $($node.name)) } else { Write-Warning "Duplicate application name '$("application-$($nodeApp.name)")' found" } } } } $modules = @() Get-ChildItem "$ConfigPath\*.xml" -Recurse | ForEach-Object { $doc = [xml] (Get-Content $_.FullName) $nodes = $doc.SelectNodes("//variable[@environment='$Env' or not(@environment)]") Add-Var $nodes $nodes = $doc.SelectNodes("//node") if ($nodes.Count -gt 0) { Add-Var $nodes -NameProp 'role' -ValueProp 'name' -Prefix 'node-' } $nodes = $doc.SelectNodes("//service[@environment='$Env' or not(@environment)]") if ($nodes.Count -gt 0) { Add-Var $nodes -Prefix 'service-' Add-Var $nodes -Prefix 'service-cert-hash-' -ValueProp 'cert-hash' Add-Var $nodes -Prefix 'service-cert-name-' -ValueProp 'cert-name' Add-Var $nodes -Prefix 'service-type-' -ValueProp 'type' Add-Var $nodes -Prefix 'service-healthcheck-' -ValueProp 'healthcheck' Add-Var $nodes -Prefix 'service-healthcheck-type-' -ValueProp 'healthcheck-type' Add-Var $nodes -Prefix 'service-healthcheck-interval-' -ValueProp 'healthcheck-interval' } $nodes = $doc.SelectNodes("//system-user[@environment='$Env' or not(@environment)]") if ($nodes.Count -gt 0) { Add-Var $nodes -NameProp 'system-user' -ValueProp 'name' -Prefix 'system-user-' } $nodes = $doc.SelectNodes("//module") if ($nodes.Count -gt 0) { Add-Modules -Nodes $nodes -Module $Module $nodes | ForEach-Object { $modules += $_.name } } $envNode = $doc.SelectSingleNode("//environment[@name='$Env']") if ($envNode) { $Tokens.Add('env-name', $envNode.'name') $Tokens.Add('env-group', (Get-PSPropertyValue $envNode 'group')) $Tokens.Add('env-name-short', (Get-PSPropertyValue $envNode 'name-short')) $Tokens.Add('env-name-suffix', (Get-PSPropertyValue $envNode 'name-suffix')) $Tokens.Add('env-type', (Get-PSPropertyValue $envNode 'type')) $Tokens.Add('env-active', (Get-PSPropertyValue $envNode 'active')) $Tokens.Add('env-domain', (Get-PSPropertyValue $envNode 'domain')) $Tokens.Add('env-domain-full', (Get-PSPropertyValue $envNode 'domain-full')) $Tokens.Add('env-domain-description', (Get-PSPropertyValue $envNode 'description')) $Tokens.Add('env-domain-owner', (Get-PSPropertyValue $envNode 'owner')) $Tokens.Add('env-domain-notes', (Get-PSPropertyValue $envNode 'notes')) $Tokens.Add('env-ps-remote-user', (Get-PSPropertyValue $envNode 'ps-remote-user')) $Tokens.Add('env-subscription-id', (Get-PSPropertyValue $envNode 'subscription-id')) $Tokens.Add('env-vault', (Get-PSPropertyValue $envNode 'vault')) } } $Tokens.Add('modules', $modules) } <# .SYNOPSIS Convert the tokens in file to their actual values .DESCRIPTION Convert the tokens in file to their actual values .PARAMETER FileName Name of the file to convert .PARAMETER PrefixToken Token prefix .PARAMETER SuffixToken Token suffix .PARAMETER DestFileName File name of converted file .PARAMETER ShowTokensUsed Switch to echo tokens replaced .PARAMETER SecondPass Switch to signal that same file is used in multiple conversions .PARAMETER Tokens Hashtable to add tokens to .Example $Tokens = @{} Add-TokensFromConfig -ConfigPath "$PSScriptRoot/config" -Tokens $Tokens -Env 'local' Get-ChildItem .\$ConfigLocation\*.* | ForEach-Object { $destFile = Join-Path $ArtifactsLocation $_.Name Convert-TokensInFile -FileName $_.Fullname -DestFileName $destFile -Tokens $Tokens } #> function Convert-TokensInFile([Parameter(Mandatory = $true)][ValidateNotNullOrEmpty()]$FileName, $PrefixToken = '__', $SuffixToken = '__', $DestFileName, [Switch]$ShowTokensUsed, [Switch]$SecondPass, $Tokens) { if (!$DestFileName) { $DestFileName = $FileName } if (Test-Path $FileName) { $regex = [regex] "${PrefixToken}((?:(?!${SuffixToken}).)*)${SuffixToken}" $content = [System.IO.File]::ReadAllText($FileName); if (!$Tokens) { $Tokens = @{} } $script:cnt = 0 $callback = { param([System.Text.RegularExpressions.Match] $Match) $value = $Match.Groups[1].Value # check env first $newTokenValue = [Environment]::GetEnvironmentVariable($value) if ($null -eq $newTokenValue) { if ($Tokens.ContainsKey($value)) { $v = $Tokens[$value] if ($null -eq $v) { $v = '' } if ($v -is [PSCredential]) { $newTokenValue = $v.GetNetworkCredential().Password } else { $newTokenValue = $v.ToString() # detect expression in variable if ($newTokenValue.StartsWith('$')) { $newTokenValue = Invoke-Expression "Write-Output `"$($newTokenValue)`"" } } } } if ($null -eq $newTokenValue) { $script:HasReplaceVarErrors = $true; Write-Warning "Token not found in replace: '$value'" return "" } $script:cnt++ if ($ShowTokensUsed.IsPresent -or ($Global:VerbosePreference -eq 'Continue')) { Write-Host "Replacing token '$value' with '$newTokenValue'" } return $newTokenValue } $content = $regex.Replace($content, $callback) New-Item -ItemType Directory (Split-Path -Path $DestFileName) -Force -ErrorAction Ignore | Out-Null Set-Content -Path $DestFileName -Value $content -Encoding UTF8 if ( ($Global:VerbosePreference -eq 'Continue') -or ( ($script:cnt -gt 0) -and $ShowTokensUsed.IsPresent ) ) { if ($SecondPass.IsPresent -and ($script:cnt -eq 0) ) { Write-Host "$($script:cnt) Tokens replaced in '$FileName'" } else { Write-Host "$($script:cnt) Tokens replaced in '$FileName'" } } } else { Throw "Convert-TokensInFile error: file not found '$FileName'" } } function Invoke-CloneGitRepo($Root, $RepoUrl, [switch]$Reset, $RepoName, $RepoDefaultBranch, $Depth = 0) { New-Item -Path $Root -ItemType Directory -ErrorAction Ignore -Force | Out-Null $uri = [System.Uri]$RepoUrl if ($uri.Segments.Count -gt 0) { $defBranch = 'master' $folder = $uri.Segments[$uri.Segments.Count - 1] $repoLocation = Join-Path $Root $folder Write-Host "Repo: $repoLocation" if (Test-Path $repoLocation) { Push-Location -Path $repoLocation try { $output = &git status if ($output) { Write-Host $output $hasChanges = !$output.Contains("nothing to commit, working tree clean") if ($reset.IsPresent) { &git reset --hard &git clean -xdf $hasChanges = $false } if (!$hasChanges) { #&git fetch Invoke-Git "fetch" # detect main branch name #&git branch --remotes --list '*/HEAD' $br = Invoke-Git "branch --remotes --list '*/HEAD'" if ($null -ne $br -and $br.Contains('/main')) { $defBranch = 'main' } #&git checkout master Invoke-Git "checkout $defBranch" #&git pull Invoke-Git "pull" Write-Host -ForegroundColor Green " Repo $($RepoName) switched to $defBranch and updated." } else { Write-Host -ForegroundColor Yellow " Repo $($RepoName) contains changes." } } else { Write-Host -ForegroundColor Yellow " Repo $($RepoName) not found, no .git folder? or no repo?" } } finally { Pop-Location } } else { Write-Host -ForegroundColor Yellow " Repo $($RepoName) not found locally. Cloning..." Push-Location $Root try { #&git clone $r.RemoteUrl if ($Depth -gt 0) { Invoke-Git "clone --depth $($Depth) $($RepoUrl)" } else { Invoke-Git "clone $($RepoUrl)" $folder = $uri.Segments[$uri.Segments.Count - 1] $repoLocation = Join-Path $Root $folder if ( (Test-Path $repoLocation) -and ($RepoDefaultBranch -ne '')) { Push-Location $repoLocation try { # detect main branch name #&git branch --remotes --list '*/HEAD' $br = Invoke-Git "branch --remotes --list '*/HEAD'" if ($null -ne $br -and $br.Contains('/main')) { $defBranch = 'main' } #&git checkout master Invoke-Git "checkout $defBranch" } finally { Pop-Location } } else { Write-Warning "Repo $($RepoName) not cloned see error above" } } } finally { Pop-Location } } } } function Invoke-CloneGitRepos($Root, $Repos, [switch]$Reset, $Depth = 0) { # use repo's from Get-AdoAllRepositories # use git.exe for cloning $repos = $Repos | Sort-Object -Property Name, Project | Where-Object { $_ } foreach ($r in $repos) { Invoke-CloneGitRepo -Root $Root -RepoUrl $r.RemoteUrl -Reset:$Reset -RepoName $r.Name -RepoDefaultBranch $r.DefaultBranch -Depth $Depth } } function Invoke-Git($Command, $WorkingDirectory) { $invokeErrors = New-Object System.Collections.ArrayList 256 $currentEncoding = [Console]::OutputEncoding $errorCount = $global:Error.Count $prevErrorActionPreference = $ErrorActionPreference try { $ErrorActionPreference = 'Continue' $LastExitCode = 0 Invoke-Expression "git $Command" *>&1 } finally { if ($currentEncoding.IsSingleByte) { [Console]::OutputEncoding = $currentEncoding } $ErrorActionPreference = $prevErrorActionPreference if ($global:Error.Count -gt $errorCount) { $numNewErrors = $global:Error.Count - $errorCount $invokeErrors.InsertRange(0, $global:Error.GetRange(0, $numNewErrors)) if ($invokeErrors.Count -gt 256) { $invokeErrors.RemoveRange(256, ($invokeErrors.Count - 256)) } $global:Error.RemoveRange(0, $numNewErrors) for ($i = 0; $i -lt $numNewErrors; $i++) { Write-Host "Git result $LastExitCode $($invokeErrors[$i].Exception.Message)" } } } } function New-SecureStringStorage([ValidateNotNullOrEmpty()]$String) { return [SecureStringStorage]::New($String) } function Read-ObjectFromJsonFile($Path, $Depth = 10) { if (Test-Path $Path) { $object = Get-Content -Path $Path | ConvertFrom-Json -Depth $Depth } else { $object = [PSCustomObject]@{} } function Set-Props($Object) { foreach ($prop in $Object.PsObject.Properties) { if ($prop.Value -is [HashTable]) { if ($prop.Value.ContainsKey('TypeName') -and ($prop.Value.TypeName -eq 'SecureStringStorage') ) { $prop.Value = [SecureStringStorage]$prop.Value } } elseif ($prop.Value -is [PSCustomObject]) { if ($prop.Value.TypeName -and ($prop.Value.TypeName -eq 'SecureStringStorage') ) { $prop.Value = [SecureStringStorage]$prop.Value } else { Set-Props $prop.Value } } } } # fix SecureString references Set-Props $object return $object } function Save-ObjectToJsonFile($Path, $Object, $Depth = 10) { function Set-Props($Object) { foreach ($prop in $Object.PsObject.Properties) { if ($prop.Value -is [SecureString]) { $prop.Value = [SecureStringStorage]$prop.Value } } } # fix SecureString references Set-Props $object $Object | ConvertTo-Json -Depth $Depth | Set-Content -Path $Path -Force } class SecureStringStorage { hidden [String] $String [String] $TypeName = 'SecureStringStorage' SecureStringStorage($String) { if (($String -is [PSCustomObject]) -and ($String.TypeName -eq 'SecureStringStorage') ) { $this.String = $String.String } elseif (($String -is [SecureString])) { $this.String = $String | ConvertFrom-SecureString } else { $this.String = ConvertTo-SecureString -String $String -AsPlainText -Force | ConvertFrom-SecureString } } [string]ToString() { return $this.String } [SecureString]GetSecureString() { $secureString = ConvertTo-SecureString -String $this.String -Force return $secureString } [string]GetPlainString() { $plain = ConvertTo-SecureString -String $this.String -Force | ConvertFrom-SecureString -AsPlainText return $plain } } function Test-IsSecureStringStorageObject([ValidateNotNull()]$Object) { return ($Object -is [SecureStringStorage]) } <# .SYNOPSIS Send a msg to Slack Channel .DESCRIPTION Send a msg to Slack Channel via the Incoming Webhook integration App. See in slack: Browse Apps / Custom Integrations / Incoming WebHook or see notes below .PARAMETER Msg The message to send .PARAMETER Channel The Channel to send to .PARAMETER Username The user of the message .PARAMETER IconUrl The url of the icon to display in the message, otherwise use emoji .PARAMETER Emoji The emoji to use like ':ghost:' or ':bom:' see slack documentation for more Emoji. Use IconUrl for custom emoji .PARAMETER AsUser Send msg as this User .PARAMETER Token The Incoming WebHook Token .PARAMETER Attachments The json structured attachment. See Slack documentation like $attachment = @{ fallback = $msg pretext = "Sample message: <http://url_to_task|Test out Slack message attachments>" color = "danger" # good, warning fields = @( @{ title = "[Alert]]" value = "This is much easier than I thought it would be. <https://www.sample.com/logo.png>|Logo" short = "false" } ) } .Example Send-ToSlack -m 'Hello' -c 'TestChannel' -u 'me' -e ':bomb:' -t 'mytoken...' .NOTES for documentation about configuring Slack/Acquire token see https://api.slack.com/messaging/webhooks or https://api.slack.com/legacy/custom-integrations #> function Send-ToSlack ([alias('m')]$Msg, [alias('c')]$Channel, [alias('u')]$Username, [alias('iu')]$IconUrl, [alias('e')]$Emoji, [alias('a')][Switch]$AsUser, [alias('t')]$Token, $Attachments) { $slackUri = "https://hooks.slack.com/services/$Token" if ($Channel -and !($Channel.StartsWith('@'))) { $channel = "#$Channel" } else { $channel = $Channel } $body = @{ channel = $channel username = $Username text = $Msg icon_url = $IconUrl icon_emoji = $Emoji } if ($null -eq $Emoji) { $body.Remove('icon_emoji') } if ($null -eq $IconUrl ) { $body.Remove('icon_url') } if ($Attachments) { [void]$body.Add('attachments', $Attachments) } try { [Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12 $response = Invoke-RestMethod -Uri $slackUri -Method Post -Body ($body | ConvertTo-Json -Compress -Depth 10) -ContentType 'application/json' } catch { Throw "Send-ToSlack error: $($_.Exception.Message)" } if ($response -ne 'ok') { Throw "Send-ToSlack error: $($response)" } } function Convert-ObjectToHashTable([object[]]$Object) { foreach ($o in $Object) { $output = @{} $o | Get-Member -MemberType *Property | ForEach-Object { $value = $o.($_.name) if ($value -is [PSCustomObject]) { $value = Convert-ObjectToHashTable -Object $value } $output.($_.name) = $value } $output } } function ConvertTo-TitleCase([alias('t')]$Text, [alias('c')][string] $Culture = 'en-US') { $c = New-Object System.Globalization.CultureInfo($Culture) return ($c.TextInfo.ToTitleCase($Text)) } function Copy-ObjectPropertyValues($FromObject, $ToObject, [switch]$Deep) { if ($Deep.IsPresent) { throw "Deep copy properties not supported in Copy-ObjectPropertyValues" } foreach ($prop in $FromObject.PSObject.Properties) { if (Test-PSProperty $ToObject $prop.Name) { $ToObject."$($prop.Name)" = $prop.Value } } return $ToObject } function Get-ArrayItemCount($Array) { if ($Array -is [array] -or $Array -is [System.Collections.ArrayList]) { return $Array.Count } elseif ($Array) { return 1 } else { return 0; } } <# .SYNOPSIS Gets an environment variable .DESCRIPTION Gets an environment variable, supports empty environment variable and case sensitivity .PARAMETER Name Name of the environment variable .PARAMETER Default Default value of the environment variable when not found .PARAMETER IgnoreCasing Ignores casing by checking ToLower and ToUpper variants #> function Get-EnvironmentVar { param([alias('n')][string]$Name, [alias('d')][string]$Default = $null, [switch]$IgnoreCasing) $r = [Environment]::GetEnvironmentVariable($Name); if ($null -eq $r -and $IgnoreCasing.IsPresent) { $r = [Environment]::GetEnvironmentVariable($Name.ToLower()); if ($null -eq $r) { $r = [Environment]::GetEnvironmentVariable($Name.ToUpper()); } } if ($r -eq [char]0x2422) { $r = '' } if (($r -eq '') -or ($null -eq $r)) { $r = $Default } if ($r -eq '') { return $null } else { return $r } } <# .SYNOPSIS Gets property value from Object .DESCRIPTION Gets property value from Object, first checks if property exists, if not returns default value. In Set-StrictMode -Latest every property used is checked for existence --> runtime exception .PARAMETER Object Object to get property value from .PARAMETER Name Name of property .PARAMETER Default Default value if property does not exists #> function Get-PSPropertyValue { param([alias('o')][object]$Object, [alias('p')][string]$Name, [alias('d')]$Default = '') if (Test-PSProperty -o $Object -p $Name -Exact) { return $Object."$Name" } else { return $Default } } function Get-RandomString($Length = 20) { $chars = 65..90 + 97..122 $chars += 48..57 $s = $null Get-Random -Count $Length -Input ($chars) | ForEach-Object { $s += [char]$_ } return $s.ToString() } <# .SYNOPSIS Get an Unique Id, default it's a guid .DESCRIPTION Get an Unique Id, default it's a guid. Decrease size when you need shorter unique id but sacrifice on id accuracy / collision possibility .PARAMETER Size Size of Id, default 32 characters #>function Get-UniqueId([ValidateRange(6, 32)][Int]$Size = 32) { return ([Guid]::NewGuid().ToString('n')).SubString(0, $Size) } function Invoke-RetryBlock([alias('c', 'Code')][ScriptBlock]$ScriptBlock, [alias('r', 'Retry')][int]$RetryCnt = 3, [alias('w', 'WaitSec', 'DelaySec')][int]$RetryDelaySec = 5, [switch][bool]$NoException, [alias('Msg', 'm')]$Message, [alias('mn')]$MutexName = $null) { $stopLoop = $false [int]$retryCount = 1 $m = $null if ($MutexName) { $m = Wait-OnMutex -Name $MutexName } try { do { try { Invoke-Command -ScriptBlock $ScriptBlock -ErrorAction Stop $stopLoop = $true } catch { if ($retryCount -ge $RetryCnt) { $stopLoop = $true if (!($NoException.IsPresent)) { Write-Verbose "Retry block failed after $RetryCnt retries with delay of $RetryDelaySec"; Throw } } else { $retryCount ++ if ($Message) { Write-Host "$Message retry '$retryCount' delay $($RetryDelaySec)s" } else { Write-Verbose "In retry '$retryCount' with delay of $($RetryDelaySec)s" } Write-Verbose $_.Exception.Message Start-Sleep -Seconds $RetryDelaySec } } } while (!$stopLoop) } finally { if ($m) { Exit-Mutex $m Close-Mutex $m } } } function Merge-Objects($Objects) { $props = @{} foreach ($o in $Objects) { foreach ($property in $o.PSObject.Properties) { if ($props.ContainsKey($property.Name)) { # ignore duplicates } else { [void]$props.Add($property.Name, $property.value) } } } return [PSCustomObject]$props } <# .SYNOPSIS Checks if property exists on Object .DESCRIPTION Checks if property exists on Object. In Set-StrictMode -Latest every property used is checked for existence --> runtime exception .PARAMETER Object Object to test for property .PARAMETER Name Name of property .PARAMETER Exact Use exact match in property name checking #> function Test-PSProperty { param([alias('o')][object]$Object, [alias('p')][string]$Name, [alias('e')][switch]$Exact) try { foreach ($prop in $Object.PSObject.Properties) { if ($Exact.IsPresent) { if ($prop.Name -eq $Name) { return $true } elseif ($prop.Name -match 'Keys') { if ($prop.Value -eq $Name) { return $true } } } else { if ($prop.Name -match $Name) { return $true } elseif ($prop.Name -match 'Keys') { if ($prop.Value -match $Name) { return $true } } } } } catch { # not found } return $false } <# .SYNOPSIS Write script header to console host .DESCRIPTION Write script header to console host, useful for logging and debugging your PowerShell scripts .PARAMETER Title Script title .PARAMETER Invocation Invocation to use like $PSCommandPath .PARAMETER ExtraParams Extra parameters you want to write to console .PARAMETER ShowHost Show also console details .EXAMPLE Write-ScriptHeader -Title 'My Script' -Invocation $PSCommandPath -ExtraParams @{MyVar='hello'} -ShowHost .REMARKS $PSCommandPath contains information about the invoker or calling script, not the current script #> function Write-Header($Title, $Invocation, $ExtraParams, [switch]$ShowHost) { $header = '' if ($Invocation) { if ($Invocation -is [System.Management.Automation.InvocationInfo]) { $header = $Invocation.MyCommand.Name } else { $header = Split-Path $Invocation -Leaf -ErrorAction Ignore } } Write-Host ''.PadRight(78, '-'); Write-Host "$Title $header" Write-Host ''.PadRight(78, '-'); if ($Invocation) { Write-Host 'Parameters' Write-Params $Invocation } if ($ExtraParams) { if ($ExtraParams.Count -gt 0) { if ($Invocation) { Write-Host '' } Write-Host 'More Parameters' foreach ($k in $ExtraParams.GetEnumerator()) { $n = $k.Name Write-Host "$($n.PadLeft(20)): $($k.value)" } } } if ($ShowHost.IsPresent) { Write-Host '' Write-HostDetails } if ($Invocation -or $ExtraParams -or $ShowHost.IsPresent) { Write-Host ''.PadRight(78, '-'); } } function Write-HostDetails { Write-Host 'Host details' Write-Host " Time: $(Get-Date -Format s)" Write-Host " Computer: $([Environment]::MachineName)/$(hostname)" Write-Host " WhoAmI: $([Environment]::UserName)" Write-Host " Powershell: $($PSVersionTable.PsVersion)" Write-Host " OS: $([Environment]::OSVersion.VersionString)" Write-Host " Culture: $(Get-Culture)" Write-Host " Current Folder: $(Get-Location)" } <# .SYNOPSIS Write parameter names & values to console host .DESCRIPTION Write or echo's parameter names and values to console host, useful for logging and debugging your PowerShell scripts .PARAMETER Invocation Invocation to use like $PSCommandPath or $MyInvocation .EXAMPLE Write-Params -Invocation $PSCommandPath .REMARKS $PSCommandPath contains information about the invoker or calling script, not the current script $MyInvocation contains information about current context #> function Write-Params($Invocation) { if ($Invocation) { $ivo = $Invocation } else { try { $ivo = $PSCmdlet.MyInvocation } catch { return; } } try { $i = Get-Command -Name $ivo -ErrorAction SilentlyContinue if (!$i) { $i = Get-Command -Name $ivo.InvocationName -ErrorAction SilentlyContinue } if ($i) { $parameterList = $i.ParameterSets.Parameters if (!$parameterList) { return; } } else { return } } catch { Write-Host 'Unable to write parameters' return; } # detect unwrap if ($parameterList -is [System.Management.Automation.CommandParameterInfo]) { $list = @($parameterList) } else { $list = $parameterList } foreach ($key in $list.GetEnumerator()) { $var = Get-Variable -Name $key.Name -ErrorAction SilentlyContinue; if ($var) { $n = $var.name foreach ($alias in $key.Aliases) { if ($var.name -like "*$alias*") { $n = $alias } } if ($n -in 'pw', 'pwd', 'password', 'secret') { Write-Host "$($n.PadLeft(20)): *************" } else { if ($var.value -and $var.value -is [HashTable]) { Write-Host "$($n.PadLeft(20)) " foreach ($item in $var.Value.Keys) { Write-Host "$($item.PadLeft(24)): $($var.value[$item])" } } else { Write-Host "$($n.PadLeft(20)): $($var.value)" } } } } } # SIG # Begin signature block # MII9+gYJKoZIhvcNAQcCoII96zCCPecCAQExDzANBglghkgBZQMEAgEFADB5Bgor # BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG # KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCD4PzDUK/L9dxjm # /Hol47E74fHOR6Qu2RibD3TWt8yWuKCCIsAwggXMMIIDtKADAgECAhBUmNLR1FsZ # lUgTecgRwIeZMA0GCSqGSIb3DQEBDAUAMHcxCzAJBgNVBAYTAlVTMR4wHAYDVQQK # ExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xSDBGBgNVBAMTP01pY3Jvc29mdCBJZGVu # dGl0eSBWZXJpZmljYXRpb24gUm9vdCBDZXJ0aWZpY2F0ZSBBdXRob3JpdHkgMjAy # MDAeFw0yMDA0MTYxODM2MTZaFw00NTA0MTYxODQ0NDBaMHcxCzAJBgNVBAYTAlVT # MR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xSDBGBgNVBAMTP01pY3Jv # c29mdCBJZGVudGl0eSBWZXJpZmljYXRpb24gUm9vdCBDZXJ0aWZpY2F0ZSBBdXRo # b3JpdHkgMjAyMDCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoCggIBALORKgeD # Bmf9np3gx8C3pOZCBH8Ppttf+9Va10Wg+3cL8IDzpm1aTXlT2KCGhFdFIMeiVPvH # or+Kx24186IVxC9O40qFlkkN/76Z2BT2vCcH7kKbK/ULkgbk/WkTZaiRcvKYhOuD # PQ7k13ESSCHLDe32R0m3m/nJxxe2hE//uKya13NnSYXjhr03QNAlhtTetcJtYmrV # qXi8LW9J+eVsFBT9FMfTZRY33stuvF4pjf1imxUs1gXmuYkyM6Nix9fWUmcIxC70 # ViueC4fM7Ke0pqrrBc0ZV6U6CwQnHJFnni1iLS8evtrAIMsEGcoz+4m+mOJyoHI1 # vnnhnINv5G0Xb5DzPQCGdTiO0OBJmrvb0/gwytVXiGhNctO/bX9x2P29Da6SZEi3 # W295JrXNm5UhhNHvDzI9e1eM80UHTHzgXhgONXaLbZ7LNnSrBfjgc10yVpRnlyUK # xjU9lJfnwUSLgP3B+PR0GeUw9gb7IVc+BhyLaxWGJ0l7gpPKWeh1R+g/OPTHU3mg # trTiXFHvvV84wRPmeAyVWi7FQFkozA8kwOy6CXcjmTimthzax7ogttc32H83rwjj # O3HbbnMbfZlysOSGM1l0tRYAe1BtxoYT2v3EOYI9JACaYNq6lMAFUSw0rFCZE4e7 # swWAsk0wAly4JoNdtGNz764jlU9gKL431VulAgMBAAGjVDBSMA4GA1UdDwEB/wQE # AwIBhjAPBgNVHRMBAf8EBTADAQH/MB0GA1UdDgQWBBTIftJqhSobyhmYBAcnz1AQ # T2ioojAQBgkrBgEEAYI3FQEEAwIBADANBgkqhkiG9w0BAQwFAAOCAgEAr2rd5hnn # LZRDGU7L6VCVZKUDkQKL4jaAOxWiUsIWGbZqWl10QzD0m/9gdAmxIR6QFm3FJI9c # Zohj9E/MffISTEAQiwGf2qnIrvKVG8+dBetJPnSgaFvlVixlHIJ+U9pW2UYXeZJF # xBA2CFIpF8svpvJ+1Gkkih6PsHMNzBxKq7Kq7aeRYwFkIqgyuH4yKLNncy2RtNwx # AQv3Rwqm8ddK7VZgxCwIo3tAsLx0J1KH1r6I3TeKiW5niB31yV2g/rarOoDXGpc8 # FzYiQR6sTdWD5jw4vU8w6VSp07YEwzJ2YbuwGMUrGLPAgNW3lbBeUU0i/OxYqujY # lLSlLu2S3ucYfCFX3VVj979tzR/SpncocMfiWzpbCNJbTsgAlrPhgzavhgplXHT2 # 6ux6anSg8Evu75SjrFDyh+3XOjCDyft9V77l4/hByuVkrrOj7FjshZrM77nq81YY # uVxzmq/FdxeDWds3GhhyVKVB0rYjdaNDmuV3fJZ5t0GNv+zcgKCf0Xd1WF81E+Al # GmcLfc4l+gcK5GEh2NQc5QfGNpn0ltDGFf5Ozdeui53bFv0ExpK91IjmqaOqu/dk # ODtfzAzQNb50GQOmxapMomE2gj4d8yu8l13bS3g7LfU772Aj6PXsCyM2la+YZr9T # 03u4aUoqlmZpxJTG9F9urJh4iIAGXKKy7aIwggb0MIIE3KADAgECAhMzAAHe0xte # W4jVjyJ4AAAAAd7TMA0GCSqGSIb3DQEBDAUAMFoxCzAJBgNVBAYTAlVTMR4wHAYD # VQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKzApBgNVBAMTIk1pY3Jvc29mdCBJ # RCBWZXJpZmllZCBDUyBBT0MgQ0EgMDIwHhcNMjQxMTEzMDY1MjI1WhcNMjQxMTE2 # MDY1MjI1WjBzMQswCQYDVQQGEwJOTDEVMBMGA1UECBMMWnVpZC1Ib2xsYW5kMREw # DwYDVQQHEwhTY2hpZWRhbTEcMBoGA1UEChMTVGVkb24gVGVjaG5vbG9neSBCVjEc # MBoGA1UEAxMTVGVkb24gVGVjaG5vbG9neSBCVjCCAaIwDQYJKoZIhvcNAQEBBQAD # ggGPADCCAYoCggGBAKZW92d65qK/W7/EQ9M8AQNhXJBF7omjvZl54Wm3r7KRcMxT # pPJKJKiXVps/fPhCohOsLaFj7CLEwbRzihrDb8Ty6q3UtCM9JgFIQM+2cBHSLhet # 4jaZNaDBpcvGhCWawaXB9ZrEJx6xNdmWtlPFHTXJ08h9V7J2UfT0+o55cAj8MGXu # dl/y5VK+LGWYvRL9PrSjE9Qw9U22qjwh4zvpji0+1/pcLPdI8rkkpUnd0pfsBiQP # CwRNPtlnJejD9cGIZr6IjpH6ZuG20S/NsiQVt5hof5rdvYeN+TT4O+OkYFL+MvpI # /kve6jGl7mu4FkPgrEUSkXY8YbRBa5mUHU1sCcRdK9ASh4cMPCDRA/KKbUOsQMT/ # IIZ+iYf16k4JPbLC6yf5bLs78+r+kqx8NCi4+sG/j63hFh8x7SwwfF8P+G73HP6i # eLoJ866UtnJPvYGfS04yEQtz3EO9/rhcqYJNKEhx3A01Y9htJtWPgwuom7ah6XBq # BpvoQz3HszggUXXQUwIDAQABo4ICGDCCAhQwDAYDVR0TAQH/BAIwADAOBgNVHQ8B # Af8EBAMCB4AwOwYDVR0lBDQwMgYKKwYBBAGCN2EBAAYIKwYBBQUHAwMGGisGAQQB # gjdh0ve1PoH1m9Uegby1myWPs8FcMB0GA1UdDgQWBBTrcQzycmGFkTjDJyr+3YFo # MNgROjAfBgNVHSMEGDAWgBQkRZmhd5AqfMPKg7BuZBaEKvgsZzBnBgNVHR8EYDBe # MFygWqBYhlZodHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2NybC9NaWNy # b3NvZnQlMjBJRCUyMFZlcmlmaWVkJTIwQ1MlMjBBT0MlMjBDQSUyMDAyLmNybDCB # pQYIKwYBBQUHAQEEgZgwgZUwZAYIKwYBBQUHMAKGWGh0dHA6Ly93d3cubWljcm9z # b2Z0LmNvbS9wa2lvcHMvY2VydHMvTWljcm9zb2Z0JTIwSUQlMjBWZXJpZmllZCUy # MENTJTIwQU9DJTIwQ0ElMjAwMi5jcnQwLQYIKwYBBQUHMAGGIWh0dHA6Ly9vbmVv # Y3NwLm1pY3Jvc29mdC5jb20vb2NzcDBmBgNVHSAEXzBdMFEGDCsGAQQBgjdMg30B # ATBBMD8GCCsGAQUFBwIBFjNodHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpb3Bz # L0RvY3MvUmVwb3NpdG9yeS5odG0wCAYGZ4EMAQQBMA0GCSqGSIb3DQEBDAUAA4IC # AQCJqDmC/o5ZLbS48wGDX4OW6bPw377CRcMnx2rn/cirTqu/s9PurlKHmV2hyTeG # s0PhhtZXnv/CliF4P6z5dTszTyz9ketMy9LmWckzXwY1nyNRlVwwUtbkGrXVkCCy # pkAY9iQXgNbdL0Co3nzj1p53JFvjlMQlO0rJ78/BuzKgX8ovh5QbnNKMUAN0l3zL # tK4c3OymiwsJkQVLZySi8vdCU//Ln+I+II4n28R+QCTofHMZTTNgINdSCOpuama+ # gnvqwMyLboNoZWN0gl1awmoPQfrkX3NefS63+Dss38kFOYo7Pv4wbKAwTsYPJTxw # gA3mEOtNNVecqx4P7LUX0tKXSZIXIJumMiLmOtpFfOp38v2XMyvB57RMtVTbUJzN # /A/NS9H1XmxzDraicf+Fmi4sjYQvIOGqG/5+ZkMqcD+SQeGpslMNR18C9gPNsslF # Nf8QQjHjSd3h8+SS2Qn0l6x2FTCti1KV9RdYzBeRHqr4NAfImjv6Ig+V5Qb5DN8C # cn9N21CkRNOx6sPZE+iZz3Ui7sajfZjZZK5Zp40g/QXEvWkz181fhZ5CO21JvWK7 # ipfMQuysMhKReBr5cQrw4Akxu99/t45RgDxt9a7RFSScVtTuDkwgt/C0GlFzzJvu # PlcvDj9e+L3L7otSUzZlSGsWVj/1v/8QGYPIB9z0nMSIwTCCBvQwggTcoAMCAQIC # EzMAAd7TG15biNWPIngAAAAB3tMwDQYJKoZIhvcNAQEMBQAwWjELMAkGA1UEBhMC # VVMxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjErMCkGA1UEAxMiTWlj # cm9zb2Z0IElEIFZlcmlmaWVkIENTIEFPQyBDQSAwMjAeFw0yNDExMTMwNjUyMjVa # Fw0yNDExMTYwNjUyMjVaMHMxCzAJBgNVBAYTAk5MMRUwEwYDVQQIEwxadWlkLUhv # bGxhbmQxETAPBgNVBAcTCFNjaGllZGFtMRwwGgYDVQQKExNUZWRvbiBUZWNobm9s # b2d5IEJWMRwwGgYDVQQDExNUZWRvbiBUZWNobm9sb2d5IEJWMIIBojANBgkqhkiG # 9w0BAQEFAAOCAY8AMIIBigKCAYEAplb3Z3rmor9bv8RD0zwBA2FckEXuiaO9mXnh # abevspFwzFOk8kokqJdWmz98+EKiE6wtoWPsIsTBtHOKGsNvxPLqrdS0Iz0mAUhA # z7ZwEdIuF63iNpk1oMGly8aEJZrBpcH1msQnHrE12Za2U8UdNcnTyH1XsnZR9PT6 # jnlwCPwwZe52X/LlUr4sZZi9Ev0+tKMT1DD1TbaqPCHjO+mOLT7X+lws90jyuSSl # Sd3Sl+wGJA8LBE0+2Wcl6MP1wYhmvoiOkfpm4bbRL82yJBW3mGh/mt29h435NPg7 # 46RgUv4y+kj+S97qMaXua7gWQ+CsRRKRdjxhtEFrmZQdTWwJxF0r0BKHhww8INED # 8optQ6xAxP8ghn6Jh/XqTgk9ssLrJ/lsuzvz6v6SrHw0KLj6wb+PreEWHzHtLDB8 # Xw/4bvcc/qJ4ugnzrpS2ck+9gZ9LTjIRC3PcQ73+uFypgk0oSHHcDTVj2G0m1Y+D # C6ibtqHpcGoGm+hDPcezOCBRddBTAgMBAAGjggIYMIICFDAMBgNVHRMBAf8EAjAA # MA4GA1UdDwEB/wQEAwIHgDA7BgNVHSUENDAyBgorBgEEAYI3YQEABggrBgEFBQcD # AwYaKwYBBAGCN2HS97U+gfWb1R6BvLWbJY+zwVwwHQYDVR0OBBYEFOtxDPJyYYWR # OMMnKv7dgWgw2BE6MB8GA1UdIwQYMBaAFCRFmaF3kCp8w8qDsG5kFoQq+CxnMGcG # A1UdHwRgMF4wXKBaoFiGVmh0dHA6Ly93d3cubWljcm9zb2Z0LmNvbS9wa2lvcHMv # Y3JsL01pY3Jvc29mdCUyMElEJTIwVmVyaWZpZWQlMjBDUyUyMEFPQyUyMENBJTIw # MDIuY3JsMIGlBggrBgEFBQcBAQSBmDCBlTBkBggrBgEFBQcwAoZYaHR0cDovL3d3 # dy5taWNyb3NvZnQuY29tL3BraW9wcy9jZXJ0cy9NaWNyb3NvZnQlMjBJRCUyMFZl # cmlmaWVkJTIwQ1MlMjBBT0MlMjBDQSUyMDAyLmNydDAtBggrBgEFBQcwAYYhaHR0 # cDovL29uZW9jc3AubWljcm9zb2Z0LmNvbS9vY3NwMGYGA1UdIARfMF0wUQYMKwYB # BAGCN0yDfQEBMEEwPwYIKwYBBQUHAgEWM2h0dHA6Ly93d3cubWljcm9zb2Z0LmNv # bS9wa2lvcHMvRG9jcy9SZXBvc2l0b3J5Lmh0bTAIBgZngQwBBAEwDQYJKoZIhvcN # AQEMBQADggIBAImoOYL+jlkttLjzAYNfg5bps/DfvsJFwyfHauf9yKtOq7+z0+6u # UoeZXaHJN4azQ+GG1lee/8KWIXg/rPl1OzNPLP2R60zL0uZZyTNfBjWfI1GVXDBS # 1uQatdWQILKmQBj2JBeA1t0vQKjefOPWnnckW+OUxCU7Ssnvz8G7MqBfyi+HlBuc # 0oxQA3SXfMu0rhzc7KaLCwmRBUtnJKLy90JT/8uf4j4gjifbxH5AJOh8cxlNM2Ag # 11II6m5qZr6Ce+rAzItug2hlY3SCXVrCag9B+uRfc159Lrf4OyzfyQU5ijs+/jBs # oDBOxg8lPHCADeYQ6001V5yrHg/stRfS0pdJkhcgm6YyIuY62kV86nfy/ZczK8Hn # tEy1VNtQnM38D81L0fVebHMOtqJx/4WaLiyNhC8g4aob/n5mQypwP5JB4amyUw1H # XwL2A82yyUU1/xBCMeNJ3eHz5JLZCfSXrHYVMK2LUpX1F1jMF5Eeqvg0B8iaO/oi # D5XlBvkM3wJyf03bUKRE07Hqw9kT6JnPdSLuxqN9mNlkrlmnjSD9BcS9aTPXzV+F # nkI7bUm9YruKl8xC7KwyEpF4GvlxCvDgCTG733+3jlGAPG31rtEVJJxW1O4OTCC3 # 8LQaUXPMm+4+Vy8OP174vcvui1JTNmVIaxZWP/W//xAZg8gH3PScxIjBMIIHWjCC # BUKgAwIBAgITMwAAAASWUEvS2+7LiAAAAAAABDANBgkqhkiG9w0BAQwFADBjMQsw # CQYDVQQGEwJVUzEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMTQwMgYD # VQQDEytNaWNyb3NvZnQgSUQgVmVyaWZpZWQgQ29kZSBTaWduaW5nIFBDQSAyMDIx # MB4XDTIxMDQxMzE3MzE1MloXDTI2MDQxMzE3MzE1MlowWjELMAkGA1UEBhMCVVMx # HjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjErMCkGA1UEAxMiTWljcm9z # b2Z0IElEIFZlcmlmaWVkIENTIEFPQyBDQSAwMjCCAiIwDQYJKoZIhvcNAQEBBQAD # ggIPADCCAgoCggIBAOHOoOgzomOmwDsAj2wZUBdrY6N3JFGbmm+WaKzJ0aeKzpsG # Q4k2yKcxZGf5PJOIrwSVdcOf2/6MpCPnlwKmmsTHcgDtDKHZxFuyJ30Pq05MpBMx # 8UWwjYOig7E52HP2HS+yCIiZYvJOdbqWhyy+wmJvWDXNEhWL5WhY9jtB4zvcvzUZ # nFjY2pmTpUY8VtnFoFLFHWs0h4EQnpPO1dmzP9e2/qPFl1FvdSKYIEWrJomeuVhB # R1ym8oZti24QSumVpkKBXhPhlqylghiv6v+EYk2jDYR11r1r/v/yOfFLTsVYtw2i # tX0OmC8iCBh8w+AprXKxor8bqav3K6x7pxjQe//0JrpdmT/R3DpmP2qbYFJ8E/tt # IPwN+4g37rlcOskti6NP5Kf42/ifLxOBTKiIsMRgci+PNjzFQQt6nfzWxUGvDJo+ # np7FPhxKr/Wq/gG3CsLpm2aiSSpkKxmkjXVn5NjaHYHFjpqu48oW8cGTo5y49P28 # J7FDXDQHtPb/qoqM8kEHrPAN1Fz3EUG/BvnNMmjtiAon1kyu8krslCfPJNZrTdtg # jX7W44rYgHmn6GfVZoZ+UX2/kvyuWq1b03C7pLeT3Uw0MZeeexCBOgPulxQaXbIz # s5C83RIexC5PD1TzI0HzwoCrSfOHNe33dgvfqcRdZREFBV2P2LQi/jZrPXFlAgMB # AAGjggIOMIICCjAOBgNVHQ8BAf8EBAMCAYYwEAYJKwYBBAGCNxUBBAMCAQAwHQYD # VR0OBBYEFCRFmaF3kCp8w8qDsG5kFoQq+CxnMFQGA1UdIARNMEswSQYEVR0gADBB # MD8GCCsGAQUFBwIBFjNodHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpb3BzL0Rv # Y3MvUmVwb3NpdG9yeS5odG0wGQYJKwYBBAGCNxQCBAweCgBTAHUAYgBDAEEwEgYD # VR0TAQH/BAgwBgEB/wIBADAfBgNVHSMEGDAWgBTZQSmwDw9jbO9p1/XNKZ6kSGow # 5jBwBgNVHR8EaTBnMGWgY6Bhhl9odHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtp # b3BzL2NybC9NaWNyb3NvZnQlMjBJRCUyMFZlcmlmaWVkJTIwQ29kZSUyMFNpZ25p # bmclMjBQQ0ElMjAyMDIxLmNybDCBrgYIKwYBBQUHAQEEgaEwgZ4wbQYIKwYBBQUH # MAKGYWh0dHA6Ly93d3cubWljcm9zb2Z0LmNvbS9wa2lvcHMvY2VydHMvTWljcm9z # b2Z0JTIwSUQlMjBWZXJpZmllZCUyMENvZGUlMjBTaWduaW5nJTIwUENBJTIwMjAy # MS5jcnQwLQYIKwYBBQUHMAGGIWh0dHA6Ly9vbmVvY3NwLm1pY3Jvc29mdC5jb20v # b2NzcDANBgkqhkiG9w0BAQwFAAOCAgEAZy04XZWzDSKJHSrc0mvIqPqRDveQnN1T # smP4ULCCHHTMpNoSTsy7fzNVl30MhJQ5P0Lci81+t03Tm+SfpzvLdKc88Iu2WLzI # jairwEDudLDDiZ9094Qj6acTTYaBhVcc9lMokOG9rzq3LCyvUzhBV1m1DCTm0fTz # NMGbAASIbuJOlVS8RA3tBknkF/2ROzx304OOC7n7eCCqmJp79QrqLKd4JRWLFXoC # 5zFmVGfFLTvRfEAogKLiWIS+TpQpLIA2/b3vx0ISxZ3pX4OnULmyBbKgfSJQqJ2C # iWfx2jGb2LQO8vRDkSuHMZb03rQlwB2soklx9LnhP0/dsFRtHLL+VXVMo+sla5tt # r5SmAJFyDSrwzgfPrOIfk4EoZVGtgArthVp+yc5U0m6ZNCBPERLmJpLshPwU5JPd # 1gzMez8C55+CfuX5L2440NPDnsH6TIYfErj3UCqpmeNCOFtlMiSjDE23rdeiRYpk # qgwoYJwgepcJaXtIH26Pe1O6a6W3wSqegdpNn+2Pk41q0GDfjnXDzskAHcRhjwcC # UmiRt6IXZJQsYACeWpwsXmJe0o0ORLmumrYyHlYTdCnzyxT6WM+QkFPiQth+/ceH # fzumDhUfWmHuePwhrqe3UVCHy0r9f49Az3OhJX92MlsZaFo/MnmN5B62RWgJUTMI # QF8j0N6xF/cwggeeMIIFhqADAgECAhMzAAAAB4ejNKN7pY4cAAAAAAAHMA0GCSqG # SIb3DQEBDAUAMHcxCzAJBgNVBAYTAlVTMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29y # cG9yYXRpb24xSDBGBgNVBAMTP01pY3Jvc29mdCBJZGVudGl0eSBWZXJpZmljYXRp # b24gUm9vdCBDZXJ0aWZpY2F0ZSBBdXRob3JpdHkgMjAyMDAeFw0yMTA0MDEyMDA1 # MjBaFw0zNjA0MDEyMDE1MjBaMGMxCzAJBgNVBAYTAlVTMR4wHAYDVQQKExVNaWNy # b3NvZnQgQ29ycG9yYXRpb24xNDAyBgNVBAMTK01pY3Jvc29mdCBJRCBWZXJpZmll # ZCBDb2RlIFNpZ25pbmcgUENBIDIwMjEwggIiMA0GCSqGSIb3DQEBAQUAA4ICDwAw # ggIKAoICAQCy8MCvGYgo4t1UekxJbGkIVQm0Uv96SvjB6yUo92cXdylN65Xy96q2 # YpWCiTas7QPTkGnK9QMKDXB2ygS27EAIQZyAd+M8X+dmw6SDtzSZXyGkxP8a8Hi6 # EO9Zcwh5A+wOALNQbNO+iLvpgOnEM7GGB/wm5dYnMEOguua1OFfTUITVMIK8faxk # P/4fPdEPCXYyy8NJ1fmskNhW5HduNqPZB/NkWbB9xxMqowAeWvPgHtpzyD3PLGVO # mRO4ka0WcsEZqyg6efk3JiV/TEX39uNVGjgbODZhzspHvKFNU2K5MYfmHh4H1qOb # U4JKEjKGsqqA6RziybPqhvE74fEp4n1tiY9/ootdU0vPxRp4BGjQFq28nzawuvaC # qUUF2PWxh+o5/TRCb/cHhcYU8Mr8fTiS15kRmwFFzdVPZ3+JV3s5MulIf3II5FXe # ghlAH9CvicPhhP+VaSFW3Da/azROdEm5sv+EUwhBrzqtxoYyE2wmuHKws00x4GGI # x7NTWznOm6x/niqVi7a/mxnnMvQq8EMse0vwX2CfqM7Le/smbRtsEeOtbnJBbtLf # oAsC3TdAOnBbUkbUfG78VRclsE7YDDBUbgWt75lDk53yi7C3n0WkHFU4EZ83i83a # bd9nHWCqfnYa9qIHPqjOiuAgSOf4+FRcguEBXlD9mAInS7b6V0UaNwIDAQABo4IC # NTCCAjEwDgYDVR0PAQH/BAQDAgGGMBAGCSsGAQQBgjcVAQQDAgEAMB0GA1UdDgQW # BBTZQSmwDw9jbO9p1/XNKZ6kSGow5jBUBgNVHSAETTBLMEkGBFUdIAAwQTA/Bggr # BgEFBQcCARYzaHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3BraW9wcy9Eb2NzL1Jl # cG9zaXRvcnkuaHRtMBkGCSsGAQQBgjcUAgQMHgoAUwB1AGIAQwBBMA8GA1UdEwEB # /wQFMAMBAf8wHwYDVR0jBBgwFoAUyH7SaoUqG8oZmAQHJ89QEE9oqKIwgYQGA1Ud # HwR9MHsweaB3oHWGc2h0dHA6Ly93d3cubWljcm9zb2Z0LmNvbS9wa2lvcHMvY3Js # L01pY3Jvc29mdCUyMElkZW50aXR5JTIwVmVyaWZpY2F0aW9uJTIwUm9vdCUyMENl # cnRpZmljYXRlJTIwQXV0aG9yaXR5JTIwMjAyMC5jcmwwgcMGCCsGAQUFBwEBBIG2 # MIGzMIGBBggrBgEFBQcwAoZ1aHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3BraW9w # cy9jZXJ0cy9NaWNyb3NvZnQlMjBJZGVudGl0eSUyMFZlcmlmaWNhdGlvbiUyMFJv # b3QlMjBDZXJ0aWZpY2F0ZSUyMEF1dGhvcml0eSUyMDIwMjAuY3J0MC0GCCsGAQUF # BzABhiFodHRwOi8vb25lb2NzcC5taWNyb3NvZnQuY29tL29jc3AwDQYJKoZIhvcN # AQEMBQADggIBAH8lKp7+1Kvq3WYK21cjTLpebJDjW4ZbOX3HD5ZiG84vjsFXT0OB # +eb+1TiJ55ns0BHluC6itMI2vnwc5wDW1ywdCq3TAmx0KWy7xulAP179qX6VSBNQ # kRXzReFyjvF2BGt6FvKFR/imR4CEESMAG8hSkPYso+GjlngM8JPn/ROUrTaeU/BR # u/1RFESFVgK2wMz7fU4VTd8NXwGZBe/mFPZG6tWwkdmA/jLbp0kNUX7elxu2+HtH # o0QO5gdiKF+YTYd1BGrmNG8sTURvn09jAhIUJfYNotn7OlThtfQjXqe0qrimgY4V # poq2MgDW9ESUi1o4pzC1zTgIGtdJ/IvY6nqa80jFOTg5qzAiRNdsUvzVkoYP7bi4 # wLCj+ks2GftUct+fGUxXMdBUv5sdr0qFPLPB0b8vq516slCfRwaktAxK1S40MCvF # bbAXXpAZnU20FaAoDwqq/jwzwd8Wo2J83r7O3onQbDO9TyDStgaBNlHzMMQgl95n # HBYMelLEHkUnVVVTUsgC0Huj09duNfMaJ9ogxhPNThgq3i8w3DAGZ61AMeF0C1M+ # mU5eucj1Ijod5O2MMPeJQ3/vKBtqGZg4eTtUHt/BPjN74SsJsyHqAdXVS5c+ItyK # Wg3Eforhox9k3WgtWTpgV4gkSiS4+A09roSdOI4vrRw+p+fL4WrxSK5nMYIakDCC # GowCAQEwcTBaMQswCQYDVQQGEwJVUzEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBv # cmF0aW9uMSswKQYDVQQDEyJNaWNyb3NvZnQgSUQgVmVyaWZpZWQgQ1MgQU9DIENB # IDAyAhMzAAHe0xteW4jVjyJ4AAAAAd7TMA0GCWCGSAFlAwQCAQUAoF4wEAYKKwYB # BAGCNwIBDDECMAAwGQYJKoZIhvcNAQkDMQwGCisGAQQBgjcCAQQwLwYJKoZIhvcN # AQkEMSIEIKLIdZrVwyvubyGtkdlLdIZO6o7qWoZEXiCcKx+TQj2qMA0GCSqGSIb3 # DQEBAQUABIIBgCAJOqaBIBjiklL6+doK+AV15fc10pcCtQSUkh1zGUKj0HcWVo6l # hnRuvkfS9AI8P0STJObopOTHRCG/ytLdc2IuVvR90xzlIQ2unQK3iV1AlTYEPOVR # 4Y3sYSWhqymsC/uTG2zCx/duUX4UnBNoKLd+0c4swjWDY7pF2n/l1QRkM5fFxi6C # YDD5BPcnZ53/ON7+jxzI9AUXJKLU8pCe9K9F5n12d4jh0DPU4vJfoORf3AWiM147 # WUSbx1EiK553x001nu0K+VmlSMlhXbQ+B4kTavZcrSZ98YOFia8txu/TLobAdhZ5 # RPs7j4Tr/LJiir8c90RHFw2/KACNgHDZT5j/bXHlhTW3n020fwh0DfjY/Vdb3T8m # /VFfcuWtkKGU11RRQlpXlcN1phuApk3kqWWN0N9JIA5OIKjX5lVNf43qnC8XHynH # xRt+sr9oCZH0/HdbJA9ApxLiJlN39T4o0KufurLMylrJKAB6q4rfjGHcfYxSNLeW # szRRmtUB3KZ0DqGCGBAwghgMBgorBgEEAYI3AwMBMYIX/DCCF/gGCSqGSIb3DQEH # AqCCF+kwghflAgEDMQ8wDQYJYIZIAWUDBAIBBQAwggFhBgsqhkiG9w0BCRABBKCC # AVAEggFMMIIBSAIBAQYKKwYBBAGEWQoDATAxMA0GCWCGSAFlAwQCAQUABCBch/TQ # TjB1S6kyrGTDKK6Rp30kSc+3FKUzcr7Vuerp1gIGZxqNQnANGBIyMDI0MTExMzE0 # MDk1Ny4zN1owBIACAfSggeGkgd4wgdsxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpX # YXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQg # Q29ycG9yYXRpb24xJTAjBgNVBAsTHE1pY3Jvc29mdCBBbWVyaWNhIE9wZXJhdGlv # bnMxJzAlBgNVBAsTHm5TaGllbGQgVFNTIEVTTjo3ODAwLTA1RTAtRDk0NzE1MDMG # A1UEAxMsTWljcm9zb2Z0IFB1YmxpYyBSU0EgVGltZSBTdGFtcGluZyBBdXRob3Jp # dHmggg8hMIIHgjCCBWqgAwIBAgITMwAAAAXlzw//Zi7JhwAAAAAABTANBgkqhkiG # 9w0BAQwFADB3MQswCQYDVQQGEwJVUzEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBv # cmF0aW9uMUgwRgYDVQQDEz9NaWNyb3NvZnQgSWRlbnRpdHkgVmVyaWZpY2F0aW9u # IFJvb3QgQ2VydGlmaWNhdGUgQXV0aG9yaXR5IDIwMjAwHhcNMjAxMTE5MjAzMjMx # WhcNMzUxMTE5MjA0MjMxWjBhMQswCQYDVQQGEwJVUzEeMBwGA1UEChMVTWljcm9z # b2Z0IENvcnBvcmF0aW9uMTIwMAYDVQQDEylNaWNyb3NvZnQgUHVibGljIFJTQSBU # aW1lc3RhbXBpbmcgQ0EgMjAyMDCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoC # ggIBAJ5851Jj/eDFnwV9Y7UGIqMcHtfnlzPREwW9ZUZHd5HBXXBvf7KrQ5cMSqFS # HGqg2/qJhYqOQxwuEQXG8kB41wsDJP5d0zmLYKAY8Zxv3lYkuLDsfMuIEqvGYOPU # RAH+Ybl4SJEESnt0MbPEoKdNihwM5xGv0rGofJ1qOYSTNcc55EbBT7uq3wx3mXht # VmtcCEr5ZKTkKKE1CxZvNPWdGWJUPC6e4uRfWHIhZcgCsJ+sozf5EeH5KrlFnxpj # KKTavwfFP6XaGZGWUG8TZaiTogRoAlqcevbiqioUz1Yt4FRK53P6ovnUfANjIgM9 # JDdJ4e0qiDRm5sOTiEQtBLGd9Vhd1MadxoGcHrRCsS5rO9yhv2fjJHrmlQ0EIXmp # 4DhDBieKUGR+eZ4CNE3ctW4uvSDQVeSp9h1SaPV8UWEfyTxgGjOsRpeexIveR1MP # TVf7gt8hY64XNPO6iyUGsEgt8c2PxF87E+CO7A28TpjNq5eLiiunhKbq0XbjkNoU # 5JhtYUrlmAbpxRjb9tSreDdtACpm3rkpxp7AQndnI0Shu/fk1/rE3oWsDqMX3jjv # 40e8KN5YsJBnczyWB4JyeeFMW3JBfdeAKhzohFe8U5w9WuvcP1E8cIxLoKSDzCCB # Ou0hWdjzKNu8Y5SwB1lt5dQhABYyzR3dxEO/T1K/BVF3rV69AgMBAAGjggIbMIIC # FzAOBgNVHQ8BAf8EBAMCAYYwEAYJKwYBBAGCNxUBBAMCAQAwHQYDVR0OBBYEFGtp # KDo1L0hjQM972K9J6T7ZPdshMFQGA1UdIARNMEswSQYEVR0gADBBMD8GCCsGAQUF # BwIBFjNodHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpb3BzL0RvY3MvUmVwb3Np # dG9yeS5odG0wEwYDVR0lBAwwCgYIKwYBBQUHAwgwGQYJKwYBBAGCNxQCBAweCgBT # AHUAYgBDAEEwDwYDVR0TAQH/BAUwAwEB/zAfBgNVHSMEGDAWgBTIftJqhSobyhmY # BAcnz1AQT2ioojCBhAYDVR0fBH0wezB5oHegdYZzaHR0cDovL3d3dy5taWNyb3Nv # ZnQuY29tL3BraW9wcy9jcmwvTWljcm9zb2Z0JTIwSWRlbnRpdHklMjBWZXJpZmlj # YXRpb24lMjBSb290JTIwQ2VydGlmaWNhdGUlMjBBdXRob3JpdHklMjAyMDIwLmNy # bDCBlAYIKwYBBQUHAQEEgYcwgYQwgYEGCCsGAQUFBzAChnVodHRwOi8vd3d3Lm1p # Y3Jvc29mdC5jb20vcGtpb3BzL2NlcnRzL01pY3Jvc29mdCUyMElkZW50aXR5JTIw # VmVyaWZpY2F0aW9uJTIwUm9vdCUyMENlcnRpZmljYXRlJTIwQXV0aG9yaXR5JTIw # MjAyMC5jcnQwDQYJKoZIhvcNAQEMBQADggIBAF+Idsd+bbVaFXXnTHho+k7h2ESZ # JRWluLE0Oa/pO+4ge/XEizXvhs0Y7+KVYyb4nHlugBesnFqBGEdC2IWmtKMyS1OW # IviwpnK3aL5JedwzbeBF7POyg6IGG/XhhJ3UqWeWTO+Czb1c2NP5zyEh89F72u9U # Iw+IfvM9lzDmc2O2END7MPnrcjWdQnrLn1Ntday7JSyrDvBdmgbNnCKNZPmhzoa8 # PccOiQljjTW6GePe5sGFuRHzdFt8y+bN2neF7Zu8hTO1I64XNGqst8S+w+RUdie8 # fXC1jKu3m9KGIqF4aldrYBamyh3g4nJPj/LR2CBaLyD+2BuGZCVmoNR/dSpRCxlo # t0i79dKOChmoONqbMI8m04uLaEHAv4qwKHQ1vBzbV/nG89LDKbRSSvijmwJwxRxL # LpMQ/u4xXxFfR4f/gksSkbJp7oqLwliDm/h+w0aJ/U5ccnYhYb7vPKNMN+SZDWyc # U5ODIRfyoGl59BsXR/HpRGtiJquOYGmvA/pk5vC1lcnbeMrcWD/26ozePQ/TWfNX # KBOmkFpvPE8CH+EeGGWzqTCjdAsno2jzTeNSxlx3glDGJgcdz5D/AAxw9Sdgq/+r # Y7jjgs7X6fqPTXPmaCAJKVHAP19oEjJIBwD1LyHbaEgBxFCogYSOiUIr0Xqcr1nJ # fiWG2GwYe6ZoAF1bMIIHlzCCBX+gAwIBAgITMwAAADuKaVm+FAVkcQAAAAAAOzAN # BgkqhkiG9w0BAQwFADBhMQswCQYDVQQGEwJVUzEeMBwGA1UEChMVTWljcm9zb2Z0 # IENvcnBvcmF0aW9uMTIwMAYDVQQDEylNaWNyb3NvZnQgUHVibGljIFJTQSBUaW1l # c3RhbXBpbmcgQ0EgMjAyMDAeFw0yNDAyMTUyMDM2MTJaFw0yNTAyMTUyMDM2MTJa # MIHbMQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMH # UmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSUwIwYDVQQL # ExxNaWNyb3NvZnQgQW1lcmljYSBPcGVyYXRpb25zMScwJQYDVQQLEx5uU2hpZWxk # IFRTUyBFU046NzgwMC0wNUUwLUQ5NDcxNTAzBgNVBAMTLE1pY3Jvc29mdCBQdWJs # aWMgUlNBIFRpbWUgU3RhbXBpbmcgQXV0aG9yaXR5MIICIjANBgkqhkiG9w0BAQEF # AAOCAg8AMIICCgKCAgEAqDdrWVe9AA4HgK0iqMLze7A9Vo/XdnSg8zbEqUGUg95M # FH7T/aguKP3g7788fwMz7SaZFuSaQ6mChiJNzUsslhZWNdpaC+poZETvCt5Sy4Gf # cAK+vM/tVtDS7NAXePEFLS33JAIk6HpJ3bKihT9vI2TigVON51tkoixC9VqNiVBx # VuQq8NegZJrN2/FPXrUCnBKzQ4E21J8RW3O9w6+O3peqabMumTBSu2ls68oymWXy # cEtRJoE9gk0OF2Pao9hXfct4EljZT/l6xsgoj0N6EOXHa/TLOfZ2ozWtFsR20ewf # AzyMV0Q8QpnUMR8Nxy/TfEgtNe3L8AOIRLgTH4sdoAu8Yg8jPqU5JdvAWdQDZwc5 # xDGbPa2x7SkKcs9m7DTtEWET/sayGbVnbr8AlhAepNh+VB0mBKzFE5tk+FTkHhrI # z0RXKPrf+bKRajwbFK/+++IuGfnwHw/dQ9QxYIiuQlWYIJNUrShVQ30EilOWEVyP # 02jOG1aHAFt0va1YKUFwnFiP1iRAcWGZ+kieXROOVZQsMguxxGbwjq7TNNqxC5Qn # F2xnSAi9xZbT4fQNmbA8NBwOv+zVxd5ocmd+8kN7Ka0vzIJW+XXWN/yi+58gn3oV # bkA4xQ9kv4exQpDNbRRTiZx65/lB2gbFkvy48inQS0itug/wukT2zOpuTKniUCMC # AwEAAaOCAcswggHHMB0GA1UdDgQWBBQZg5Epzt2JMd0FrPd98JDZpxzxFTAfBgNV # HSMEGDAWgBRraSg6NS9IY0DPe9ivSek+2T3bITBsBgNVHR8EZTBjMGGgX6Bdhlto # dHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2NybC9NaWNyb3NvZnQlMjBQ # dWJsaWMlMjBSU0ElMjBUaW1lc3RhbXBpbmclMjBDQSUyMDIwMjAuY3JsMHkGCCsG # AQUFBwEBBG0wazBpBggrBgEFBQcwAoZdaHR0cDovL3d3dy5taWNyb3NvZnQuY29t # L3BraW9wcy9jZXJ0cy9NaWNyb3NvZnQlMjBQdWJsaWMlMjBSU0ElMjBUaW1lc3Rh # bXBpbmclMjBDQSUyMDIwMjAuY3J0MAwGA1UdEwEB/wQCMAAwFgYDVR0lAQH/BAww # CgYIKwYBBQUHAwgwDgYDVR0PAQH/BAQDAgeAMGYGA1UdIARfMF0wUQYMKwYBBAGC # N0yDfQEBMEEwPwYIKwYBBQUHAgEWM2h0dHA6Ly93d3cubWljcm9zb2Z0LmNvbS9w # a2lvcHMvRG9jcy9SZXBvc2l0b3J5Lmh0bTAIBgZngQwBBAIwDQYJKoZIhvcNAQEM # BQADggIBACqwLunRSWLugSoSzHQMZxDM3isyTjLp8jngjF/VQv5nlRbnVEct0SmT # GFKtGBakNAbJn7n7MBrM8H0p6mqtdev36JomKJMQQ0FP69rvLF6HejX0mg/P8cf6 # QBUlNvGBWCYeOvsHZUd9MIH/vLiSTJaWfdHxomdnK08NCmSVlkoOdzJV02pQT+2X # qZ6FafTZnEQ/Qg8PtyHZI8x9cgp3421qdB3wSXb+1iVZXJ0TOOTGKlF9cfuSwnng # 5wcNqU493AyjzTbTYW/AR0XEyUh/OLY1UU7aQrXNV2RObvrtINbQsy0puwJkfkmY # 6Apcs4p7kLqpP/JMemEaMO2PMAYmYz+S364ka3mgxqZve3n84ZMFSnLGbCp8NNOx # oT0UFs+dn0oDLEc4Oq1sejEQb93PpAXHn4C1VRCN4ILoHo/TcA11J5h/gwuoq+TU # 0N2VS4cANhY25/q3LXF3qMz+YPwkvUMeAvEaZL8mRrwRAQ8jRXVPa9h8jLxT/zWl # AiNMQu6C3XuRTjXkRSNNYrUl5NTe0fNCVFu46kSr8u1HqoOk+j8FnwHf0fr4e6EF # 4Sx/fHTyTDg893HQrcOTHgJ33H1AxBPG+psySuYiyW5ymCEPqPU/wHEtANcgogpW # gWQU6HImhU+SUrbwnuwg871FlQWN++Xs0PpejN7U88utxqQQ6IUjMYIHQzCCBz8C # AQEweDBhMQswCQYDVQQGEwJVUzEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0 # aW9uMTIwMAYDVQQDEylNaWNyb3NvZnQgUHVibGljIFJTQSBUaW1lc3RhbXBpbmcg # Q0EgMjAyMAITMwAAADuKaVm+FAVkcQAAAAAAOzANBglghkgBZQMEAgEFAKCCBJww # EQYLKoZIhvcNAQkQAg8xAgUAMBoGCSqGSIb3DQEJAzENBgsqhkiG9w0BCRABBDAc # BgkqhkiG9w0BCQUxDxcNMjQxMTEzMTQwOTU3WjAvBgkqhkiG9w0BCQQxIgQgckCB # kGbDvST75U8LkzvQUnrvPeXrEWxO10kKhPzxF1owgbkGCyqGSIb3DQEJEAIvMYGp # MIGmMIGjMIGgBCCT2ycyxJ4mJM8KXMA60ErMCSf8r156/dSj4jtvwZau3DB8MGWk # YzBhMQswCQYDVQQGEwJVUzEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9u # MTIwMAYDVQQDEylNaWNyb3NvZnQgUHVibGljIFJTQSBUaW1lc3RhbXBpbmcgQ0Eg # MjAyMAITMwAAADuKaVm+FAVkcQAAAAAAOzCCA14GCyqGSIb3DQEJEAISMYIDTTCC # A0mhggNFMIIDQTCCAikCAQEwggEJoYHhpIHeMIHbMQswCQYDVQQGEwJVUzETMBEG # A1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWlj # cm9zb2Z0IENvcnBvcmF0aW9uMSUwIwYDVQQLExxNaWNyb3NvZnQgQW1lcmljYSBP # cGVyYXRpb25zMScwJQYDVQQLEx5uU2hpZWxkIFRTUyBFU046NzgwMC0wNUUwLUQ5 # NDcxNTAzBgNVBAMTLE1pY3Jvc29mdCBQdWJsaWMgUlNBIFRpbWUgU3RhbXBpbmcg # QXV0aG9yaXR5oiMKAQEwBwYFKw4DAhoDFQApTtyEDHUj3Lv5f7jeOCak0Ihv96Bn # MGWkYzBhMQswCQYDVQQGEwJVUzEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0 # aW9uMTIwMAYDVQQDEylNaWNyb3NvZnQgUHVibGljIFJTQSBUaW1lc3RhbXBpbmcg # Q0EgMjAyMDANBgkqhkiG9w0BAQsFAAIFAOrewQQwIhgPMjAyNDExMTMwNjA5MDha # GA8yMDI0MTExNDA2MDkwOFowdDA6BgorBgEEAYRZCgQBMSwwKjAKAgUA6t7BBAIB # ADAHAgEAAgIfMjAHAgEAAgITNjAKAgUA6uAShAIBADA2BgorBgEEAYRZCgQCMSgw # JjAMBgorBgEEAYRZCgMCoAowCAIBAAIDB6EgoQowCAIBAAIDAYagMA0GCSqGSIb3 # DQEBCwUAA4IBAQCfrHrG3h6ZP+EkTCk369ZlGwPjzFze5Ezbxhi5ZuropFhH63J5 # sr1WY4+XHBX0GEG6K4TZB1t0sxUogEzGmNgZUbFXDXI6fqAAY1IXFrKtzHiLSJxD # FCUJ2m9WHdyO0aBERK8qR+fF5paXz7QrAVM5qZkLlKE+bkTRmZ3TG718Cvv5BwxW # 1sHrFfEDaujxb1jhqE4bcYqh59loSYYPxVAO+4/R0Fiy9GJ5G4qVTUkdZqYHP4Dk # zufwzvG8stXSoFVZEyPHcpId+OijA+FloiP0f/I4lp7wGD33MpCzfkVz5ER1Y+XX # hP/bbSUWD+SbSk2ZYdOTxqX+bE1mzXMfBaULMA0GCSqGSIb3DQEBAQUABIICAI29 # +fhJbhwZwLjCO+bXDsYa1jkB02Aii4fE0YPyMuRJ93CNkuoY+NzJfGOvaVOXqIjJ # svXhNfLPDoUnruh5L0iUyhgLPpHVz2BSIgfqZ9QUev+w6dURAmBQL7uq9uoTQxSa # M9ObDbH6y6drZn4VwjMFBDzxzD7UZCMon+nX7TwQggF2fjgT9JyapLACew3u5x62 # x6NGDJM4wQoomNzA69nZONoWuD/cvsvmZXwtW1MJx8EIx42x/l2IhjCQI+PQpv3e # joymzPAB4FmgkmZo4fQMHQ//L3usb8Qn/KAq9Gz8GcBMPICtrxsY8MNLJrJaCgVp # LHf/0vxbpvPFUQ8sjx+omJLJj3Dck0gqhv1FPMlZ/qvmM+Y+goLCLdHfTaByiJwg # lrr+jsRoxSxVZTYWtHwCvpM/QQ3N8ybKUjKfYDiE2ssuc/vci2O50N2/Wde2eol4 # GTZBEoVWIrZRH1hRG/kALjSF/B/HldsxQFTrYeMbu5gF05+wz8JOB4fVlSQx65Nc # dn1wZ2kIf0ENwNqTTZIXmTWCB1ZtnZcCsQS9V5jGEjDLi8RayTDgd9bCHz520Rp5 # B6l7jvX5SaDAxrSaCgAGFnQ3u9Mc9nEOMtwAadpTMkiUIsPAWs7fiwdSDdGSamCF # piebr242TEiGZMxH8Upm2f2g1o4PR6H90ULQXlB2 # SIG # End signature block |