public/Install-PDQPackage.ps1
|
function Install-PDQPackage { <# .SYNOPSIS Triggers deployment of PDQ package to specified target(s) .DESCRIPTION Starts deployment of specified PDQ Packages either by ID number or matching name, to specified target computers. If an exact match is not found for package name, any matches will be listed and the user will be prompted to select the corresponding ID for the package they wish to deploy. .PARAMETER Computer Target machine(s) to deploy package to .PARAMETER PackageID ID number of package to deploy .PARAMETER PackageName Name of package to deploy .PARAMETER Credential Specifies a user account that has permissions to perform this action. .EXAMPLE Install-PDQPackage -Computer WK01 -PackageName Chrome PackageID PackageName Version --------- ----------- ------- 6 Google Chrome Enterprise 74.0.3729.131 74.0.3729.131 47 Google Chrome Enterprise 73.0.3683.86 73.0.3683.86 58 Google Chrome Enterprise 73.0.3683.103 73.0.3683.103 65 Google Chrome Enterprise 74.0.3729.108 74.0.3729.108 Multiple matches, select Package ID: 6 Deploys package 6 to target WK01. As "Chrome" as a string matches multiple packages, the user was prompted to choose from those available. .NOTES Author: Chris Bayliss | Caleb Bartle Version: 1.1 Date: 2/6/2021 #> [CmdletBinding(SupportsShouldProcess = $True)] param ( [Parameter(Mandatory = $true, ValueFromPipelineByPropertyName)] [string[]][alias('Name')]$Computer, [Parameter(Mandatory = $true, ParameterSetName = 'ID', ValueFromPipelineByPropertyName)] [int[]]$PackageID, [Parameter(Mandatory = $true, ParameterSetName = 'Name', ValueFromPipelineByPropertyName)] [string[]]$PackageName, [PSCredential]$Credential ) process { Load-PDQConfig if ($PSCmdlet.ParameterSetName -eq 'ID') { $Package = @() $PackageID | Foreach-Object { $i = $_ $sql = "SELECT PackageID, Name FROM Packages WHERE PackageID = $i" $icmParams = @{ Computer = $Server ScriptBlock = { $args[0] | sqlite3.exe $args[1] } ArgumentList = $sql, $DatabasePath } if ($Credential) { $icmParams['Credential'] = $Credential } $packages = Invoke-Command @icmParams $packagesParsed = $packages | ForEach-Object { $p = $_ -split '\|' [PSCustomObject]@{ PackageID = $p[0] PackageName = $p[1] } } $Package += ($packagesParsed).PackageName } } if ($PSCmdlet.ParameterSetName -eq 'Name') { $Package = @() $PackageName | ForEach-Object { try { $n = $_ $sql = "SELECT PackageID, Name, Version FROM Packages WHERE Name LIKE '%%$n%%'" $icmParams = @{ Computer = $Server ScriptBlock = { $args[0] | sqlite3.exe $args[1] } Argumentlist = $sql, $DatabasePath } if ($Credential) { $icmParams['Credential'] = $Credential } $packages = Invoke-Command @icmParams $packagesParsed = $packages | ForEach-Object { $p = $_ -split '\|' [PSCustomObject]@{ PackageID = $p[0] PackageName = $p[1] Version = $p[2] } } if ($packagesParsed.Count -gt 1) { Write-Output "$($packagesParsed | Out-String)" $selection = Read-Host "Multiple matches, select Package ID" $Package += ($packagesParsed | Where-Object PackageID -eq $selection).PackageName } else { $Package += ($packagesParsed).PackageName } } catch { Throw "No packages found matching $n" } } } foreach ($pkg in $Package) { $icmParams = @{ Computer = $Server ScriptBlock = { PDQDeploy.exe Deploy -Package $Using:pkg -Targets $using:Computer } ArgumentList = $pkg, $computer } if ($Credential) { $icmParams['Credential'] = $Credential } Write-Verbose "Deploying $pkg to Target $Computer" Invoke-Command @icmParams } } } |