public/Get-KbUpdate.ps1
|
function Get-KbUpdate { <# .SYNOPSIS Gets download links and detailed information for KB files (SPs/hotfixes/CUs, etc) from local db, catalog.update.microsoft.com or WSUS. .DESCRIPTION Gets detailed information including download links for KB files (SPs/hotfixes/CUs, etc) from local db, catalog.update.microsoft.com or WSUS. By default, the local sqlite database (updated regularly) is searched first and if no result is found, the catalog will be searched as a failback. Because Microsoft's RSS feed does not work, this can result in slowness. Use the Simple parameter for simplified output and faster results when using the web option. If you'd prefer searching and downloading from a local WSUS source, this is an option as well. See the examples for more information. .PARAMETER Pattern Any pattern. Can be the KB name, number or even MSRC numbrer. For example, KB4057119, 4057119, or MS15-101. .PARAMETER Architecture Can be x64, x86, ia64, or ARM. .PARAMETER Language Cumulative Updates come in one file for all languages, but Service Packs have a file for every language. If you want to get only a specific language, use this parameter. You you can press tab for auto-complete or use the two letter code that is used for Accept-Language HTTP header, e. g. "en" for English or "de" for German. .PARAMETER OperatingSystem Specify one or more operating systems. Tab complete to see what's available. If anything is missing, please file an issue. .PARAMETER ComputerName Used to connect to a remote host - gets the Operating System and architecture information automatically .PARAMETER Credential The optional alternative credential to be used when connecting to ComputerName .PARAMETER Product Specify one or more products (SharePoint, SQL Server, etc). Tab complete to see what's available. If anything is missing, please file an issue. .PARAMETER Latest Filters out any patches that have been superseded by other patches in the batch .PARAMETER Force When using Latest, the Web is required to get the freshest data unless Force is used. Also when Force is used, the cache is ignored. .PARAMETER Exclude Exclude matches for pattern .PARAMETER Simple A lil faster. Returns, at the very least: Title, Architecture, Language, UpdateId and Link .PARAMETER Source Search source. By default, Database is searched first, then if no matches are found, it tries finding it on the web. .PARAMETER Multithread Multithread when three or more matches are returned. This is a lot faster than the default singlethread but also a lot less reliable. .PARAMETER Exact Search for exact matches only. Basically, the search will be in quotes. .PARAMETER Since Only return results newer than this date. .PARAMETER CustomQuery Perform a custom query on the kbupdate-library sqlite database. Sets the Source to Database. A common query looks like this: select *, NULL AS SupersededBy, NULL AS Supersedes, NULL AS Link from kb where UpdateId in (select UpdateId from kb where UpdateId = '$kb' or Title like '%$kb%' or Id like '%$kb%' or Description like '%$kb%' or MSRCNumber like '%$kb%') and SupportedProducts in ('$oses') COLLATE NOCASE and UpdateId not in (select UpdateId from kb where UpdateId = '$ex' or Title like '%$ex%' or Id like '%$ex%' or Description like '%$ex%') .PARAMETER MaxPages Maximum number of pages to parse when using the web source, each page returns 25 results. Defaults to 1 for a total of 25 max results from the web. Unless you set -Source Web, more than 25xMaxPages may be returned (because db lookups are faster and dont need to care about paging). .PARAMETER EnableException By default, when something goes wrong we try to catch it, interpret it and give you a friendly warning message. This avoids overwhelming you with "sea of red" exceptions, but is inconvenient because it basically disables advanced scripting. Using this switch turns this "nice by default" feature off and enables you to catch exceptions with your own try/catch. .NOTES Author: Chrissy LeMaire (@cl), netnerds.net Copyright: (c) licensed under MIT License: MIT https://opensource.org/licenses/MIT .EXAMPLE PS C:\> Get-KbUpdate KB4057119 Gets detailed information about KB4057119. .EXAMPLE PS C:\> Get-KbUpdate -Pattern KB4057119, 4057114 -Source Database Gets detailed information about KB4057119 and KB4057114. Only searches the database (useful for offline enviornments). .EXAMPLE PS C:\> Get-KbUpdate -Pattern MS15-101 -Source Web Downloads KBs related to MSRC MS15-101 to the current directory. Only searches the web and not the local db or WSUS. .EXAMPLE PS C:\> Connect-KbWsusServer -ComputerName server1 -SecureConnection PS C:\> Get-KbUpdate -Pattern KB2764916 This command will make a secure connection (Default: 443) to a WSUS server. Then use Wsus as a source for Get-KbUpdate. .EXAMPLE PS C:\> Connect-KbWsusServer -ComputerName server1 -SecureConnection PS C:\> Get-KbUpdate -Pattern KB2764916 -Source Database Search the database even if you've connected to WSUS in the same session. .EXAMPLE PS C:\> Get-KbUpdate -Pattern KB4057119, 4057114 -Simple A lil faster when using web as a source. Returns, at the very least: Title, Architecture, Language, UpdateId and Link .EXAMPLE PS C:\> Get-KbUpdate -Pattern "KB2764916 Nederlands" -Simple An alternative way to search for language specific packages .EXAMPLE PS C:\> Get-KbUpdate -OperatingSystem 'Windows Server 2019' -Latest -Architecture x64 -Pattern KB5015878 -Exclude 20H2, 21h2 Gets the latest KB for KB5015878 for Windows Server 2019 x64, but excludes results for builds 20H2 and 21H2. .EXAMPLE PS C:\> Get-KbUpdate -Pattern "Windows Server 2019" -MaxPages 2 -Source Web Gets KBs for Windows Server 2019 from the web, and returns 2 pages (up to 50 results) instead of 1 (25 max). #> [CmdletBinding()] param( [Parameter(ValueFromPipeline)] [Alias("UpdateId", "Id", "KBUpdate", "HotfixId", "Name")] [string[]]$Pattern, [string[]]$Architecture, [string[]]$OperatingSystem, [string[]]$Exclude, [PSFComputer[]]$ComputerName, [pscredential]$Credential, [string[]]$Product, [string]$Language, [switch]$Simple, [switch]$Exact, [switch]$Latest, [switch]$Force, [switch]$Multithread, [ValidateSet("Wsus", "Web", "Database")] [string[]]$Source = (Get-PSFConfigValue -FullName kbupdate.app.source), [int]$MaxPages = 1, [datetime]$Since, [string]$CustomQuery, [switch]$EnableException ) begin { $script:MaxPages = $MaxPages if ($NoMultithreading) { Write-PSFMessage -Level Warning -Message "Multithreading now disabled by default. This parameter will likely be removed in future versions." } if ($PSBoundParameters.Language) { Write-PSFMessage -Level Verbose -Message "Language specified, switching to web source only" $Source = "Web" } if ($script:ConnectedWsus -and -not $PSBoundParameters.Source) { Write-PSFMessage -Level Verbose -Message "Source not specified and WSUS connection detected. Setting source to Wsus." $Source = "Wsus" } if ($PSBoundParameters.Query -or $PSBoundParameters.Since) { Write-PSFMessage -Level Verbose -Message "Query or Since specified, switching to database source only" if (-not $Pattern) { $Pattern = "%" } $Source = "Database" } if ($script:importjob.State -eq "Completed") { $global:kbupdate = $script:importjob | Receive-Job -Wait -AutoRemoveJob $null = Remove-Variable -Name importjob -Scope Script } Write-PSFMessage -Level Verbose -Message "Source set to $Source" if ($OperatingSystem) { Write-PSFMessage -Level Verbose -Message "Operating system set to $OperatingSystem" } $script:allresults = @() function Get-KbItemFromDb { [CmdletBinding()] param($kb, $os, $arch, $lang, $exclude, $since, $customquery) process { if (-not $kb) { continue } Write-PSFMessage -Level Verbose -Message "Processing $kb" # Join to dupe and check dupe $kb = $kb.ToLower() if ($customquery) { $query = $customquery } else { $query = "select *, NULL AS SupersededBy, NULL AS Supersedes, NULL AS Link from kb where UpdateId in (select UpdateId from kb where UpdateId = '$kb' or Title like '%$kb%' or Id like '%$kb%' or Description like '%$kb%' or MSRCNumber like '%$kb%')" if ($Since) { $date = $Since.ToString("yyyy-MM-dd") $query = "$query and DateAdded > '$date'" } if ($os) { $oses = $os -join "', '" $query = "$query and SupportedProducts in ('$oses') COLLATE NOCASE" } if ($arch) { $arch = $arch -join "', '" $query = "$query and Architecture in ('$arch') COLLATE NOCASE" } if ($lang) { $lang = $lang -join "', '" $query = "$query and Language in ('$lang') COLLATE NOCASE" } if ($exclude) { foreach ($ex in $exclude) { $query = "$query and UpdateId not in (select UpdateId from kb where UpdateId = '$ex' or Title like '%$ex%' or Id like '%$ex%' or Description like '%$ex%')" } } } Write-PSFMessage -Level Verbose -Message "Query: $query" $allitems = Invoke-SqliteQuery -DataSource $script:basedb -Query $query | Where-Object UpdateId -notin $script:allresults | Sort-Object UpdateId -Unique if ($allitems.UpdateId) { Write-PSFMessage -Level Verbose -Message "Found $([array]($allitems.UpdateId).count) in the database for $kb" } foreach ($item in $allitems) { $script:allresults += $item.UpdateId if ($global:kbupdate) { # cache has finished importing $item.SupersededBy = $global:kbupdate["superbyhash"][$item.UpdateId] $item.Supersedes = $global:kbupdate["superhash"][$item.UpdateId] $item.Link = $global:kbupdate["linkhash"][$item.UpdateId] } else { # I do wish my import didn't return empties but sometimes it does so check for length of 3 $item.SupersededBy = Invoke-SqliteQuery -DataSource $script:basedb -Query "select KB, Description from SupersededBy where UpdateId = '$($item.UpdateId)' COLLATE NOCASE and LENGTH(kb) > 3" $item.Supersedes = Invoke-SqliteQuery -DataSource $script:basedb -Query "select KB, Description from Supersedes where UpdateId = '$($item.UpdateId)' COLLATE NOCASE and LENGTH(kb) > 3" $item.Link = (Invoke-SqliteQuery -DataSource $script:basedb -Query "select DISTINCT Link from Link where UpdateId = '$($item.UpdateId)' COLLATE NOCASE").Link } if ($item.SupportedProducts -match "\|") { $item.SupportedProducts = $item.SupportedProducts -split "\|" } if ($item.Architecture -eq "n/a") { $item.Architecture = $null } if ($item.title -match "ia32") { $item.Architecture = "IA32" } if ($item.title -match "ia64") { $item.Architecture = "IA64" } if ($item.title -match "64-Bit" -and $item.title -notmatch "32-Bit" -and -not $item.Architecture) { $item.Architecture = "x64" } if ($item.title -notmatch "64-Bit" -and $item.title -match "32-Bit" -and -not $item.Architecture) { $item.Architecture = "x86" } if ($item.title -match "x64" -or $item.title -match "AMD64") { $item.Architecture = "x64" } if ($item.title -match "x86") { $item.Architecture = "x86" } if ($item.title -match "ARM64") { $item.Architecture = "ARM64" } if ($item.title -match "ARM-based") { $item.Architecture = "ARM32" } if ($item.link -match "x64" -or $item.link -match "AMD64" -and -not $item.Architecture) { $item.Architecture = "x64" } if ($item.link -match "x86" -and -not $item.Architecture) { $item.Architecture = "x86" } if ($item.link -match "ARM64" -and -not $item.Architecture) { $item.Architecture = "ARM64" } if ($item.link -match "ARM-based" -and -not $item.Architecture) { $item.Architecture = "ARM32" } if ($item.LastModified) { $item.LastModified = Repair-Date $item.LastModified } foreach ($super in $item.Supersedes) { $null = $super | Add-Member -MemberType ScriptMethod -Name ToString -Value { $this.Description } -Force } foreach ($superby in $item.SupersededBy) { $null = $superby | Add-Member -MemberType ScriptMethod -Name ToString -Value { $this.Description } -Force } $item } if (-not $item -and $Source -eq "Database") { Write-PSFMessage -Level Verbose -Message "No results found for $kb in the local database" } } } function Get-KbItemFromWsusApi ($kb) { Write-PSFMessage -Level Verbose -Message "Executing 'Get-PSWSUSUpdate -Update $kb'" $results = Get-PSWSUSUpdate -Update $kb foreach ($wsuskb in $results) { # cacher $guid = $wsuskb.UpdateID $script:allresults += $guid $hashkey = "$guid-$Simple" if ($script:kbcollection.ContainsKey($hashkey)) { if ($Force) { $script:kbcollection.Remove($hashkey) } else { $script:kbcollection[$hashkey] continue } } $severity = $wsuskb.MsrcSeverity | Select-Object -First 1 $alert = $wsuskb.SecurityBulletins | Select-Object -First 1 if ($severity -eq "MsrcSeverity") { $severity = $null } if ($alert -eq "") { $alert = $null } $file = $wsuskb | Get-PSWSUSInstallableItem | Get-PSWSUSUpdateFile $link = $file.FileURI if ($null -ne $link -and "" -ne $link) { $link = $file.OriginUri } if ($link -eq "") { $link = $null } if ($title -match "ia32") { $arch = "IA32" } if ($title -match "ia64") { $arch = "IA64" } if ($title -match "64-Bit" -and $title -notmatch "32-Bit" -and -not $arch) { $arch = "x64" } if ($title -notmatch "64-Bit" -and $title -match "32-Bit" -and -not $arch) { $arch = "x86" } if ($title -match "x64" -or $title -match "AMD64") { $arch = "x64" } if ($title -match "x86") { $arch = "x86" } if ($title -match "ARM64") { $arch = "ARM64" } if ($title -match "ARM-based") { $arch = "ARM32" } if ($link -match "x64" -or $link -match "AMD64" -and -not $arch) { $arch = "x64" } if ($link -match "x86" -and -not $arch) { $arch = "x86" } if ($link -match "ARM64" -and -not $arch) { $arch = "ARM64" } if ($link -match "ARM-based" -and -not $arch) { $arch = "ARM32" } if ($wsuskb.ArrivalDate) { $lastmod = Repair-Date $wsuskb.ArrivalDate } # reset values for the loop $supersededby = $null $supersedes = $null if ($guid) { if ($global:kbupdate) { # cache has finished importing try { $supersededby = $global:kbupdate["superbyhash"][$guid] $supersedes = $global:kbupdate["superhash"][$guid] if (-not $link) { $link = $global:kbupdate["linkhash"][$guid] } } catch { #whatever } } else { # I do wish my import didn't return empties but sometimes it does so check for length of 3 $supersededby = Invoke-SqliteQuery -DataSource $script:basedb -Query "select KB, Description from SupersededBy where UpdateId = '$($guid)' COLLATE NOCASE and LENGTH(kb) > 3" $supersedes = Invoke-SqliteQuery -DataSource $script:basedb -Query "select KB, Description from Supersedes where UpdateId = '$($guid)' COLLATE NOCASE and LENGTH(kb) > 3" $link = (Invoke-SqliteQuery -DataSource $script:basedb -Query "select DISTINCT Link from Link where UpdateId = '$($guid)' COLLATE NOCASE").Link } } $null = $script:kbcollection.Add($hashkey, ( [pscustomobject]@{ Title = $wsuskb.Title Id = ($wsuskb.KnowledgebaseArticles | Select-Object -First 1) Architecture = $null Language = $null Hotfix = $null Description = $wsuskb.Description LastModified = $lastmod Size = $wsuskb.Size Classification = $wsuskb.UpdateClassificationTitle SupportedProducts = $wsuskb.ProductTitles MSRCNumber = $alert MSRCSeverity = $severity RebootBehavior = $wsuskb.InstallationBehavior.RebootBehavior RequestsUserInput = $wsuskb.InstallationBehavior.CanRequestUserInput ExclusiveInstall = $null NetworkRequired = $wsuskb.InstallationBehavior.RequiresNetworkConnectivity UninstallNotes = $null # $wsuskb.uninstallnotes UninstallSteps = $null # $wsuskb.uninstallsteps UpdateId = $guid Supersedes = $supersedes SupersededBy = $supersededby Link = $link InputObject = $kb })) $script:kbcollection[$hashkey] } } function Get-GuidsFromWeb ($kb) { Write-PSFMessage -Level Verbose -Message "$kb" if ($kb -match '^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}$') { Write-PSFMessage -Level Verbose -Message "Guid passed in, skipping initial web search" $guids = @() $guids += [PSCustomObject]@{ Guid = $kb Title = $kb } } else { Write-Progress -Activity "Searching catalog for $kb" -Id 1 -Status "Contacting catalog.update.microsoft.com" if ($OperatingSystem) { $os = $OperatingSystem -join '" "' $url = "https://www.catalog.update.microsoft.com/Search.aspx?q=$kb+`"$os`"" Write-PSFMessage -Level Verbose -Message "Accessing $url" $results = Invoke-TlsWebRequest -Uri $url $kbids = $results.InputFields | Where-Object { $_.type -eq 'Button' -and ($_.Value -eq 'Download' -or $_.class -eq 'flatBlueButtonDownload focus-only') } | Select-Object -ExpandProperty ID } if (-not $kbids) { $url = "https://www.catalog.update.microsoft.com/Search.aspx?q=$kb" $boundparams.OperatingSystem = $OperatingSystem Write-PSFMessage -Level Verbose -Message "Failing back to $url" $results = Invoke-TlsWebRequest -Uri $url $kbids = $results.InputFields | Where-Object { $_.type -eq 'Button' -and ($_.Value -eq 'Download' -or $_.class -eq 'flatBlueButtonDownload focus-only') } | Select-Object -ExpandProperty ID } Write-Progress -Activity "Searching catalog for $kb" -Id 1 -Completed if (-not $kbids) { try { $null = Invoke-TlsWebRequest -Uri "https://support.microsoft.com/en-us/topic/$kb" Stop-PSFFunction -EnableException:$EnableException -Message "Matches were found for $kb, but the results no longer exist in the catalog" return } catch { Write-PSFMessage -Level Verbose -Message "No results found for $kb at microsoft.com" return } } Write-PSFMessage -Level Verbose -Message "$kbids" # Thanks! https://keithga.wordpress.com/2017/05/21/new-tool-get-the-latest-windows-10-cumulative-updates/ $resultlinks = $results.Links | Where-Object ID -match '_link' | Where-Object { $_.OuterHTML -match ( "(?=.*" + ( $Filter -join ")(?=.*" ) + ")" ) } # get the title too $guids = @() foreach ($resultlink in $resultlinks) { $itemguid = $resultlink.id.replace('_link', '') $itemtitle = ($resultlink.outerHTML -replace '<[^>]+>', '').Trim() if ($itemguid -in $kbids) { $guids += [pscustomobject]@{ Guid = $itemguid Title = $itemtitle } } } } $guids | Where-Object Guid -notin $script:allresults } function Get-KbItemFromWeb ($kb, $exact, $exclude) { if ($Exact) { $kb = "`"$kb`"" } if ($Exclude) { $excludestr = $exclude -join '" -"' $kb = "$kb -`"$excludestr`"" } # Wishing Microsoft offered an RSS feed. Since they don't, we are forced to parse webpages. function Get-Info ($Text, $Pattern) { if ($Pattern -match "labelTitle") { if ($Pattern -match "SupportedProducts") { # no idea what the regex below does but it's not working for SupportedProducts # do it the manual way instead $block = [regex]::Match($Text, $Pattern + '[\s\S]*?\s*(.*?)\s*<\/div>').Groups[0].Value $supported = $block -split "</span>" | Select-Object -Last 1 $supported.Trim().Replace("</div>","").Split(",").Trim() } else { # this should work... not accounting for multiple divs however? [regex]::Match($Text, $Pattern + '[\s\S]*?\s*(.*?)\s*<\/div>').Groups[1].Value } } elseif ($Pattern -match "span ") { [regex]::Match($Text, $Pattern + '(.*?)<\/span>').Groups[1].Value } else { [regex]::Match($Text, $Pattern + "\s?'?(.*?)'?;").Groups[1].Value } } function Get-SuperInfo ($Text, $Pattern) { # this works, but may also summon cthulhu $span = [regex]::match($Text, $pattern + '[\s\S]*?<div id') switch -Wildcard ($span.Value) { "*div style*" { $regex = '">\s*(.*?)\s*<\/div>' } "*a href*" { $regex = "<div[\s\S]*?'>(.*?)<\/a" } default { $regex = '"\s?>\s*(\S+?)\s*<\/div>' } } $spanMatches = [regex]::Matches($span, $regex).ForEach( { $_.Groups[1].Value }) if ($spanMatches -eq 'n/a') { $spanMatches = $null } if ($spanMatches) { foreach ($superMatch in $spanMatches) { $detailedMatches = [regex]::Matches($superMatch, '\b[kK][bB]([0-9]{6,})\b') # $null -ne $detailedMatches can throw cant index null errors, get more detailed if ($null -ne $detailedMatches.Groups) { [PSCustomObject] @{ 'KB' = $detailedMatches.Groups[1].Value 'Description' = $superMatch } | Add-Member -MemberType ScriptMethod -Name ToString -Value { $this.Description } -PassThru -Force } } } } try { if ($kb) { $guids = Get-GuidsFromWeb -kb $kb } else { $guids = $null } foreach ($item in $guids) { $guid = $item.Guid $itemtitle = $item.Title $hashkey = "$guid-$Simple" if ($script:kbcollection.ContainsKey($hashkey)) { if ($Force) { $script:kbcollection.Remove($hashkey) } else { $guids = $guids | Where-Object Guid -notin $guid $script:kbcollection[$hashkey] continue } } } $scriptblock = { $completed++ $guid = $psitem.Guid $itemtitle = $psitem.Title Write-PSFMessage -Level Verbose -Message "Downloading information for $itemtitle" $total = ($guids.Count) + 2 Write-ProgressHelper -TotalSteps $total -StepNumber $completed -Activity "Searching catalog" -Message "Downloading information for $itemtitle" $post = @{ size = 0; updateID = $guid; uidInfo = $guid } | ConvertTo-Json -Compress $body = @{ updateIDs = "[$post]" } Invoke-TlsWebRequest -Uri 'https://www.catalog.update.microsoft.com/DownloadDialog.aspx' -Method Post -Body $body | Select-Object -ExpandProperty Content } if ($guids.Count -gt 2 -and $Multithread) { $downloaddialogs = $guids | Invoke-Parallel -ImportVariables -ImportFunctions -ScriptBlock $scriptblock -ErrorAction Stop -RunspaceTimeout 60 -Activity "Parsing catalog.update.microsoft.com" } else { $completed = 0 $downloaddialogs = $guids | ForEach-Object -Process $scriptblock Write-Progress -Activity "Searching catalog" -Id 1 -Completed } $completed = 0 foreach ($downloaddialog in $downloaddialogs) { $completed++ $title = Get-Info -Text $downloaddialog -Pattern 'enTitle =' $total = ($downloaddialogs.Count) + 2 Write-ProgressHelper -TotalSteps $total -StepNumber $completed -Activity "Downloading details" -Message "Getting details for $title" $arch = $null $longlang = Get-Info -Text $downloaddialog -Pattern 'longLanguages =' if ($Pattern -match '^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}$') { $updateid = "$Pattern" } else { $updateid = Get-Info -Text $downloaddialog -Pattern 'updateID =' } $ishotfix = Get-Info -Text $downloaddialog -Pattern 'isHotFix =' $hashkey = "$updateid-$Simple" if ($ishotfix) { $ishotfix = "True" } else { $ishotfix = "False" } if ($longlang -eq "all") { $longlang = "All" } if ($title -match "ia32") { $arch = "IA32" } if ($title -match "ia64") { $arch = "IA64" } if ($title -match "64-Bit" -and $title -notmatch "32-Bit" -and -not $arch) { $arch = "x64" } if ($title -notmatch "64-Bit" -and $title -match "32-Bit" -and -not $arch) { $arch = "x86" } if ($title -match "x64" -or $title -match "AMD64") { $arch = "x64" } if ($title -match "x86") { $arch = "x86" } if ($title -match "ARM64") { $arch = "ARM64" } if ($title -match "ARM-based") { $arch = "ARM32" } if (-not $Simple) { # Multi-byte character is corrupted if passing BasicHtmlWebResponseObject to Get-Info -Text. $detaildialog = Invoke-TlsWebRequest -Uri "https://www.catalog.update.microsoft.com/ScopedViewInline.aspx?updateid=$updateid" | Select-Object -ExpandProperty Content $description = Get-Info -Text $detaildialog -Pattern '<span id="ScopedViewHandler_desc">' $lastmodified = Get-Info -Text $detaildialog -Pattern '<span id="ScopedViewHandler_date">' $size = Get-Info -Text $detaildialog -Pattern '<span id="ScopedViewHandler_size">' $classification = Get-Info -Text $detaildialog -Pattern '<span id="ScopedViewHandler_labelClassification_Separator" class="labelTitle">' if (-not $arch) { $arch = Get-Info -Text $detaildialog -Pattern '<span id="ScopedViewHandler_labelArchitecture_Separator" class="labelTitle">' } $supportedproducts = Get-Info -Text $detaildialog -Pattern '<span id="ScopedViewHandler_labelSupportedProducts_Separator" class="labelTitle">' $msrcnumber = Get-Info -Text $detaildialog -Pattern '<span id="ScopedViewHandler_labelSecurityBulliten_Separator" class="labelTitle">' $msrcseverity = Get-Info -Text $detaildialog -Pattern '<span id="ScopedViewHandler_msrcSeverity">' $kbnumbers = Get-Info -Text $detaildialog -Pattern '<span id="ScopedViewHandler_labelKBArticle_Separator" class="labelTitle">' $rebootbehavior = Get-Info -Text $detaildialog -Pattern '<span id="ScopedViewHandler_rebootBehavior">' $requestuserinput = Get-Info -Text $detaildialog -Pattern '<span id="ScopedViewHandler_userInput">' $exclusiveinstall = Get-Info -Text $detaildialog -Pattern '<span id="ScopedViewHandler_installationImpact">' $networkrequired = Get-Info -Text $detaildialog -Pattern '<span id="ScopedViewHandler_connectivity">' $uninstallnotes = Get-Info -Text $detaildialog -Pattern '<span id="ScopedViewHandler_labelUninstallNotes_Separator" class="labelTitle">' $uninstallsteps = Get-Info -Text $detaildialog -Pattern '<span id="ScopedViewHandler_labelUninstallSteps_Separator" class="labelTitle">' # Thanks @klorgas! https://github.com/potatoqualitee/kbupdate/issues/131 $supersededby = Get-SuperInfo -Text $detaildialog -Pattern '<div id="supersededbyInfo".*>' $supersedes = Get-SuperInfo -Text $detaildialog -Pattern '<div id="supersedesInfo".*>' if ($uninstallsteps -eq "n/a") { $uninstallsteps = $null } if ($msrcnumber -eq "n/a" -or $msrcnumber -eq "Unspecified") { $msrcnumber = $null } } $downloaddialog = $downloaddialog.Replace('www.download.windowsupdate', 'download.windowsupdate') $links = $downloaddialog | Select-String -AllMatches -Pattern "(http[s]?\://.*download\.windowsupdate\.com\/[^\'\""]*)" | Select-Object -Unique foreach ($link in $links) { if ($arch -eq "n/a") { $arch = $null } if ($link -match "x64" -or $link -match "AMD64") { $arch = "x64" } if ($link -match "x86") { $arch = "x86" } if ($link -match "ARM64") { $arch = "ARM64" } if ($link -match "ARM-based") { $arch = "ARM32" } if ($kbnumbers -eq "n/a") { $kbnumbers = $null } $properties = $baseproperties if ($Simple) { $properties = $properties | Where-Object { $PSItem -notin "Language", "LastModified", "Description", "Size", "Classification", "SupportedProducts", "MSRCNumber", "MSRCSeverity", "RebootBehavior", "RequestsUserInput", "ExclusiveInstall", "NetworkRequired", "UninstallNotes", "UninstallSteps", "SupersededBy", "Supersedes" } } $ishotfix = switch ($ishotfix) { 'Yes' { $true } 'No' { $false } default { $ishotfix } } $requestuserinput = switch ($requestuserinput) { 'Yes' { $true } 'No' { $false } default { $requestuserinput } } $exclusiveinstall = switch ($exclusiveinstall) { 'Yes' { $true } 'No' { $false } default { $exclusiveinstall } } $networkrequired = switch ($networkrequired) { 'Yes' { $true } 'No' { $false } default { $networkrequired } } if ('n/a' -eq $uninstallnotes) { $uninstallnotes = $null } if ('n/a' -eq $uninstallsteps) { $uninstallsteps = $null } # may fix later $ishotfix = $null $lastmod = Repair-Date $lastmodified if (-not $script:kbcollection[$hashkey]) { $null = $script:kbcollection.Add($hashkey, ( [pscustomobject]@{ Title = $title Id = $kbnumbers Architecture = $arch Language = $Language Hotfix = $ishotfix Description = $description LastModified = $lastmod Size = $size Classification = $classification SupportedProducts = $supportedproducts MSRCNumber = $msrcnumber MSRCSeverity = $msrcseverity RebootBehavior = $rebootbehavior RequestsUserInput = $requestuserinput ExclusiveInstall = $exclusiveinstall NetworkRequired = $networkrequired UninstallNotes = $uninstallnotes UninstallSteps = $uninstallsteps UpdateId = $updateid Supersedes = $supersedes SupersededBy = $supersededby Link = $link.matches.value InputObject = $kb })) } $script:kbcollection[$hashkey] } } } catch { Stop-PSFFunction -EnableException:$EnableException -Message "Failure" -ErrorRecord $_ -Continue } } $properties = "Title", "Id", "Description", "Architecture", "Language", "Classification", "SupportedProducts", "MSRCNumber", "MSRCSeverity", "Size", "UpdateId", "RebootBehavior", "RequestsUserInput", "ExclusiveInstall", "NetworkRequired", "UninstallNotes", "UninstallSteps", "SupersededBy", "Supersedes", "LastModified", "Link" if ($Simple) { $properties = "Title", "Architecture", "UpdateId", "Link" } if ($Source -eq "WSUS") { $properties = $properties | Where-Object { $PSItem -notin "Architecture", "Language", "Size", "ExclusiveInstall", "UninstallNotes", "UninstallSteps" } } # if latest is used, needs a collection $allkbs = @() } process { if ($Source -contains "Wsus" -and -not $script:ConnectedWsus) { Stop-PSFFunction -Message "Please use Connect-KbWsusServer before selecting WSUS as a Source" -EnableException:$EnableException return } if ($Latest -and $Simple) { Write-PSFMessage -Level Warning -Message "Simple is ignored when Latest is specified, as latest requires detailed data" $Simple = $false } if ($Latest -and $PSBoundParameters.Source -and $Source -eq "Database" -and -not $Force) { Write-PSFMessage -Level Verbose -Message "Source is ignored when Latest is specified, as latest requires the freshest data from the web. Use -Force to override this." $PSBoundParameters.Source = $null $Source = "Web" } foreach ($computer in $Computername) { # tempting to add language but for now I won't $results = $script:compcollection[$computer] if (-not $results) { try { $results = Invoke-PSFCommand -ComputerName $computer -Credential $Credential -ScriptBlock { $proc = $env:PROCESSOR_ARCHITECTURE if ($proc -eq "AMD64") { $proc = "x64" } $os = Get-CimInstance Win32_OperatingSystem | Select-Object -ExpandProperty Caption $os = $os.Replace("Standard", "").Replace("Microsoft ", "").Replace(" Pro", "").Replace("Professional", "").Replace("Home", "").Replace("Enterprise", "").Replace("Datacenter", "").Trim() [pscustomobject]@{ Architecture = $proc OperatingSystem = $os } } -ErrorAction Stop } catch { Stop-PSFFunction -Message "Failure" -ErrorRecord $_ -EnableException:$EnableException return } $null = $script:compcollection.Add($computer, $results) } if ($results.Architecture) { if ($results.Architecture -notin $Architecture) { Write-PSFMessage -Level Verbose -Message "Adding $($results.Architecture)" $Architecture += $results.Architecture } } <# # This just makes it too strict because 21H2 is also Windows Server 2022 if ($results.OperatingSystem) { if ($results.OperatingSystem -notin $OperatingSystem) { Write-PSFMessage -Level Verbose -Message "Adding $($results.OperatingSystem)" $OperatingSystem += $results.OperatingSystem } } #> } $boundparams = @{ Source = $Source Product = $PSBoundParameters.Product } if ($Source -ne "Database") { $boundparams.Architecture = $Architecture $boundparams.Language = $PSBoundParameters.Language $boundparams.OperatingSystem = $OperatingSystem } foreach ($kb in $Pattern) { if (-not $kb.Trim()) { continue } $results = @() if ($Latest) { if ($Source -contains "Wsus") { $results += Get-KbItemFromWsusApi -kb $kb -exact $exact -exclude $exclude } if ($Source -contains "Database") { $results += Get-KbItemFromDb -kb $kb -os $OperatingSystem -lang $Language -arch $Architecture -exclude $exclude -since $Since -customquery $CustomQuery } if ($Source -contains "Web") { $results += Get-KbItemFromWeb -kb $kb -exact $exact -exclude $exclude } $allkbs += $results } elseif ($Source.Count -eq 1 -and $Source -eq "Database") { if ($Since -or $CustomQuery) { Get-KbItemFromDb -kb $kb -os $OperatingSystem -lang $Language -arch $Architecture -exclude $exclude -since $Since -customquery $CustomQuery | Select-DefaultView -Property $properties } else { Get-KbItemFromDb -kb $kb -os $OperatingSystem -lang $Language -arch $Architecture -exclude $exclude -since $Since -customquery $CustomQuery | Search-Kb @boundparams | Select-DefaultView -Property $properties } } else { if ($Source -contains "Wsus") { $results += Get-KbItemFromWsusApi -kb $kb -exact $exact -exclude $exclude } if ($Source -contains "Database") { $results += Get-KbItemFromDb -kb $kb -os $OperatingSystem -lang $Language -arch $Architecture -exclude $exclude -since $Since -customquery $CustomQuery } if ($Source -contains "Web") { $results += Get-KbItemFromWeb -kb $kb -exact $exact -exclude $exclude } $allkbs += $results } } } end { # I'm not super awesome with the pipeline, and am open to suggestions if this is not the best way if ($Latest -and $allkbs) { $allkbs | Search-Kb @boundparams | Select-KbLatest | Select-DefaultView -Property $properties } elseif ($allkbs) { $allkbs | Search-Kb @boundparams | Select-DefaultView -Property $properties } } } # SIG # Begin signature block # MIIjYAYJKoZIhvcNAQcCoIIjUTCCI00CAQExDzANBglghkgBZQMEAgEFADB5Bgor # BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG # KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCAY+29qe2cNyL7R # EvL/yKN+NCuNkA3A8kCbjc/sfzlBOKCCHVkwggUaMIIEAqADAgECAhADBbuGIbCh # Y1+/3q4SBOdtMA0GCSqGSIb3DQEBCwUAMHIxCzAJBgNVBAYTAlVTMRUwEwYDVQQK # EwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xMTAvBgNV # BAMTKERpZ2lDZXJ0IFNIQTIgQXNzdXJlZCBJRCBDb2RlIFNpZ25pbmcgQ0EwHhcN # MjAwNTEyMDAwMDAwWhcNMjMwNjA4MTIwMDAwWjBXMQswCQYDVQQGEwJVUzERMA8G # A1UECBMIVmlyZ2luaWExDzANBgNVBAcTBlZpZW5uYTERMA8GA1UEChMIZGJhdG9v # bHMxETAPBgNVBAMTCGRiYXRvb2xzMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIB # CgKCAQEAvL9je6vjv74IAbaY5rXqHxaNeNJO9yV0ObDg+kC844Io2vrHKGD8U5hU # iJp6rY32RVprnAFrA4jFVa6P+sho7F5iSVAO6A+QZTHQCn7oquOefGATo43NAadz # W2OWRro3QprMPZah0QFYpej9WaQL9w/08lVaugIw7CWPsa0S/YjHPGKQ+bYgI/kr # EUrk+asD7lvNwckR6pGieWAyf0fNmSoevQBTV6Cd8QiUfj+/qWvLW3UoEX9ucOGX # 2D8vSJxL7JyEVWTHg447hr6q9PzGq+91CO/c9DWFvNMjf+1c5a71fEZ54h1mNom/ # XoWZYoKeWhKnVdv1xVT1eEimibPEfQIDAQABo4IBxTCCAcEwHwYDVR0jBBgwFoAU # WsS5eyoKo6XqcQPAYPkt9mV1DlgwHQYDVR0OBBYEFPDAoPu2A4BDTvsJ193ferHL # 454iMA4GA1UdDwEB/wQEAwIHgDATBgNVHSUEDDAKBggrBgEFBQcDAzB3BgNVHR8E # cDBuMDWgM6Axhi9odHRwOi8vY3JsMy5kaWdpY2VydC5jb20vc2hhMi1hc3N1cmVk # LWNzLWcxLmNybDA1oDOgMYYvaHR0cDovL2NybDQuZGlnaWNlcnQuY29tL3NoYTIt # YXNzdXJlZC1jcy1nMS5jcmwwTAYDVR0gBEUwQzA3BglghkgBhv1sAwEwKjAoBggr # BgEFBQcCARYcaHR0cHM6Ly93d3cuZGlnaWNlcnQuY29tL0NQUzAIBgZngQwBBAEw # gYQGCCsGAQUFBwEBBHgwdjAkBggrBgEFBQcwAYYYaHR0cDovL29jc3AuZGlnaWNl # cnQuY29tME4GCCsGAQUFBzAChkJodHRwOi8vY2FjZXJ0cy5kaWdpY2VydC5jb20v # RGlnaUNlcnRTSEEyQXNzdXJlZElEQ29kZVNpZ25pbmdDQS5jcnQwDAYDVR0TAQH/ # BAIwADANBgkqhkiG9w0BAQsFAAOCAQEAj835cJUMH9Y2pBKspjznNJwcYmOxeBcH # Ji+yK0y4bm+j44OGWH4gu/QJM+WjZajvkydJKoJZH5zrHI3ykM8w8HGbYS1WZfN4 # oMwi51jKPGZPw9neGS2PXrBcKjzb7rlQ6x74Iex+gyf8z1ZuRDitLJY09FEOh0BM # LaLh+UvJ66ghmfIyjP/g3iZZvqwgBhn+01fObqrAJ+SagxJ/21xNQJchtUOWIlxR # kuUn9KkuDYrMO70a2ekHODcAbcuHAGI8wzw4saK1iPPhVTlFijHS+7VfIt/d/18p # MLHHArLQQqe1Z0mTfuL4M4xCUKpebkH8rI3Fva62/6osaXLD0ymERzCCBTAwggQY # oAMCAQICEAQJGBtf1btmdVNDtW+VUAgwDQYJKoZIhvcNAQELBQAwZTELMAkGA1UE # BhMCVVMxFTATBgNVBAoTDERpZ2lDZXJ0IEluYzEZMBcGA1UECxMQd3d3LmRpZ2lj # ZXJ0LmNvbTEkMCIGA1UEAxMbRGlnaUNlcnQgQXNzdXJlZCBJRCBSb290IENBMB4X # DTEzMTAyMjEyMDAwMFoXDTI4MTAyMjEyMDAwMFowcjELMAkGA1UEBhMCVVMxFTAT # BgNVBAoTDERpZ2lDZXJ0IEluYzEZMBcGA1UECxMQd3d3LmRpZ2ljZXJ0LmNvbTEx # MC8GA1UEAxMoRGlnaUNlcnQgU0hBMiBBc3N1cmVkIElEIENvZGUgU2lnbmluZyBD # QTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAPjTsxx/DhGvZ3cH0wsx # SRnP0PtFmbE620T1f+Wondsy13Hqdp0FLreP+pJDwKX5idQ3Gde2qvCchqXYJawO # eSg6funRZ9PG+yknx9N7I5TkkSOWkHeC+aGEI2YSVDNQdLEoJrskacLCUvIUZ4qJ # RdQtoaPpiCwgla4cSocI3wz14k1gGL6qxLKucDFmM3E+rHCiq85/6XzLkqHlOzEc # z+ryCuRXu0q16XTmK/5sy350OTYNkO/ktU6kqepqCquE86xnTrXE94zRICUj6whk # PlKWwfIPEvTFjg/BougsUfdzvL2FsWKDc0GCB+Q4i2pzINAPZHM8np+mM6n9Gd8l # k9ECAwEAAaOCAc0wggHJMBIGA1UdEwEB/wQIMAYBAf8CAQAwDgYDVR0PAQH/BAQD # AgGGMBMGA1UdJQQMMAoGCCsGAQUFBwMDMHkGCCsGAQUFBwEBBG0wazAkBggrBgEF # BQcwAYYYaHR0cDovL29jc3AuZGlnaWNlcnQuY29tMEMGCCsGAQUFBzAChjdodHRw # Oi8vY2FjZXJ0cy5kaWdpY2VydC5jb20vRGlnaUNlcnRBc3N1cmVkSURSb290Q0Eu # Y3J0MIGBBgNVHR8EejB4MDqgOKA2hjRodHRwOi8vY3JsNC5kaWdpY2VydC5jb20v # RGlnaUNlcnRBc3N1cmVkSURSb290Q0EuY3JsMDqgOKA2hjRodHRwOi8vY3JsMy5k # aWdpY2VydC5jb20vRGlnaUNlcnRBc3N1cmVkSURSb290Q0EuY3JsME8GA1UdIARI # MEYwOAYKYIZIAYb9bAACBDAqMCgGCCsGAQUFBwIBFhxodHRwczovL3d3dy5kaWdp # Y2VydC5jb20vQ1BTMAoGCGCGSAGG/WwDMB0GA1UdDgQWBBRaxLl7KgqjpepxA8Bg # +S32ZXUOWDAfBgNVHSMEGDAWgBRF66Kv9JLLgjEtUYunpyGd823IDzANBgkqhkiG # 9w0BAQsFAAOCAQEAPuwNWiSz8yLRFcgsfCUpdqgdXRwtOhrE7zBh134LYP3DPQ/E # r4v97yrfIFU3sOH20ZJ1D1G0bqWOWuJeJIFOEKTuP3GOYw4TS63XX0R58zYUBor3 # nEZOXP+QsRsHDpEV+7qvtVHCjSSuJMbHJyqhKSgaOnEoAjwukaPAJRHinBRHoXpo # aK+bp1wgXNlxsQyPu6j4xRJon89Ay0BEpRPw5mQMJQhCMrI2iiQC/i9yfhzXSUWW # 6Fkd6fp0ZGuy62ZD2rOwjNXpDd32ASDOmTFjPQgaGLOBm0/GkxAG/AeB+ova+YJJ # 92JuoVP6EpQYhS6SkepobEQysmah5xikmmRR7zCCBY0wggR1oAMCAQICEA6bGI75 # 0C3n79tQ4ghAGFowDQYJKoZIhvcNAQEMBQAwZTELMAkGA1UEBhMCVVMxFTATBgNV # BAoTDERpZ2lDZXJ0IEluYzEZMBcGA1UECxMQd3d3LmRpZ2ljZXJ0LmNvbTEkMCIG # A1UEAxMbRGlnaUNlcnQgQXNzdXJlZCBJRCBSb290IENBMB4XDTIyMDgwMTAwMDAw # MFoXDTMxMTEwOTIzNTk1OVowYjELMAkGA1UEBhMCVVMxFTATBgNVBAoTDERpZ2lD # ZXJ0IEluYzEZMBcGA1UECxMQd3d3LmRpZ2ljZXJ0LmNvbTEhMB8GA1UEAxMYRGln # aUNlcnQgVHJ1c3RlZCBSb290IEc0MIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIIC # CgKCAgEAv+aQc2jeu+RdSjwwIjBpM+zCpyUuySE98orYWcLhKac9WKt2ms2uexuE # DcQwH/MbpDgW61bGl20dq7J58soR0uRf1gU8Ug9SH8aeFaV+vp+pVxZZVXKvaJNw # wrK6dZlqczKU0RBEEC7fgvMHhOZ0O21x4i0MG+4g1ckgHWMpLc7sXk7Ik/ghYZs0 # 6wXGXuxbGrzryc/NrDRAX7F6Zu53yEioZldXn1RYjgwrt0+nMNlW7sp7XeOtyU9e # 5TXnMcvak17cjo+A2raRmECQecN4x7axxLVqGDgDEI3Y1DekLgV9iPWCPhCRcKtV # gkEy19sEcypukQF8IUzUvK4bA3VdeGbZOjFEmjNAvwjXWkmkwuapoGfdpCe8oU85 # tRFYF/ckXEaPZPfBaYh2mHY9WV1CdoeJl2l6SPDgohIbZpp0yt5LHucOY67m1O+S # kjqePdwA5EUlibaaRBkrfsCUtNJhbesz2cXfSwQAzH0clcOP9yGyshG3u3/y1Yxw # LEFgqrFjGESVGnZifvaAsPvoZKYz0YkH4b235kOkGLimdwHhD5QMIR2yVCkliWzl # DlJRR3S+Jqy2QXXeeqxfjT/JvNNBERJb5RBQ6zHFynIWIgnffEx1P2PsIV/EIFFr # b7GrhotPwtZFX50g/KEexcCPorF+CiaZ9eRpL5gdLfXZqbId5RsCAwEAAaOCATow # ggE2MA8GA1UdEwEB/wQFMAMBAf8wHQYDVR0OBBYEFOzX44LScV1kTN8uZz/nupiu # HA9PMB8GA1UdIwQYMBaAFEXroq/0ksuCMS1Ri6enIZ3zbcgPMA4GA1UdDwEB/wQE # AwIBhjB5BggrBgEFBQcBAQRtMGswJAYIKwYBBQUHMAGGGGh0dHA6Ly9vY3NwLmRp # Z2ljZXJ0LmNvbTBDBggrBgEFBQcwAoY3aHR0cDovL2NhY2VydHMuZGlnaWNlcnQu # Y29tL0RpZ2lDZXJ0QXNzdXJlZElEUm9vdENBLmNydDBFBgNVHR8EPjA8MDqgOKA2 # hjRodHRwOi8vY3JsMy5kaWdpY2VydC5jb20vRGlnaUNlcnRBc3N1cmVkSURSb290 # Q0EuY3JsMBEGA1UdIAQKMAgwBgYEVR0gADANBgkqhkiG9w0BAQwFAAOCAQEAcKC/ # Q1xV5zhfoKN0Gz22Ftf3v1cHvZqsoYcs7IVeqRq7IviHGmlUIu2kiHdtvRoU9BNK # ei8ttzjv9P+Aufih9/Jy3iS8UgPITtAq3votVs/59PesMHqai7Je1M/RQ0SbQyHr # lnKhSLSZy51PpwYDE3cnRNTnf+hZqPC/Lwum6fI0POz3A8eHqNJMQBk1RmppVLC4 # oVaO7KTVPeix3P0c2PR3WlxUjG/voVA9/HYJaISfb8rbII01YBwCA8sgsKxYoA5A # Y8WYIsGyWfVVa88nq2x2zm8jLfR+cWojayL/ErhULSd+2DrZ8LaHlv1b0VysGMNN # n3O3AamfV6peKOK5lDCCBq4wggSWoAMCAQICEAc2N7ckVHzYR6z9KGYqXlswDQYJ # KoZIhvcNAQELBQAwYjELMAkGA1UEBhMCVVMxFTATBgNVBAoTDERpZ2lDZXJ0IElu # YzEZMBcGA1UECxMQd3d3LmRpZ2ljZXJ0LmNvbTEhMB8GA1UEAxMYRGlnaUNlcnQg # VHJ1c3RlZCBSb290IEc0MB4XDTIyMDMyMzAwMDAwMFoXDTM3MDMyMjIzNTk1OVow # YzELMAkGA1UEBhMCVVMxFzAVBgNVBAoTDkRpZ2lDZXJ0LCBJbmMuMTswOQYDVQQD # EzJEaWdpQ2VydCBUcnVzdGVkIEc0IFJTQTQwOTYgU0hBMjU2IFRpbWVTdGFtcGlu # ZyBDQTCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoCggIBAMaGNQZJs8E9cklR # VcclA8TykTepl1Gh1tKD0Z5Mom2gsMyD+Vr2EaFEFUJfpIjzaPp985yJC3+dH54P # Mx9QEwsmc5Zt+FeoAn39Q7SE2hHxc7Gz7iuAhIoiGN/r2j3EF3+rGSs+QtxnjupR # PfDWVtTnKC3r07G1decfBmWNlCnT2exp39mQh0YAe9tEQYncfGpXevA3eZ9drMvo # hGS0UvJ2R/dhgxndX7RUCyFobjchu0CsX7LeSn3O9TkSZ+8OpWNs5KbFHc02DVzV # 5huowWR0QKfAcsW6Th+xtVhNef7Xj3OTrCw54qVI1vCwMROpVymWJy71h6aPTnYV # VSZwmCZ/oBpHIEPjQ2OAe3VuJyWQmDo4EbP29p7mO1vsgd4iFNmCKseSv6De4z6i # c/rnH1pslPJSlRErWHRAKKtzQ87fSqEcazjFKfPKqpZzQmiftkaznTqj1QPgv/Ci # PMpC3BhIfxQ0z9JMq++bPf4OuGQq+nUoJEHtQr8FnGZJUlD0UfM2SU2LINIsVzV5 # K6jzRWC8I41Y99xh3pP+OcD5sjClTNfpmEpYPtMDiP6zj9NeS3YSUZPJjAw7W4oi # qMEmCPkUEBIDfV8ju2TjY+Cm4T72wnSyPx4JduyrXUZ14mCjWAkBKAAOhFTuzuld # yF4wEr1GnrXTdrnSDmuZDNIztM2xAgMBAAGjggFdMIIBWTASBgNVHRMBAf8ECDAG # AQH/AgEAMB0GA1UdDgQWBBS6FtltTYUvcyl2mi91jGogj57IbzAfBgNVHSMEGDAW # gBTs1+OC0nFdZEzfLmc/57qYrhwPTzAOBgNVHQ8BAf8EBAMCAYYwEwYDVR0lBAww # CgYIKwYBBQUHAwgwdwYIKwYBBQUHAQEEazBpMCQGCCsGAQUFBzABhhhodHRwOi8v # b2NzcC5kaWdpY2VydC5jb20wQQYIKwYBBQUHMAKGNWh0dHA6Ly9jYWNlcnRzLmRp # Z2ljZXJ0LmNvbS9EaWdpQ2VydFRydXN0ZWRSb290RzQuY3J0MEMGA1UdHwQ8MDow # OKA2oDSGMmh0dHA6Ly9jcmwzLmRpZ2ljZXJ0LmNvbS9EaWdpQ2VydFRydXN0ZWRS # b290RzQuY3JsMCAGA1UdIAQZMBcwCAYGZ4EMAQQCMAsGCWCGSAGG/WwHATANBgkq # hkiG9w0BAQsFAAOCAgEAfVmOwJO2b5ipRCIBfmbW2CFC4bAYLhBNE88wU86/GPvH # UF3iSyn7cIoNqilp/GnBzx0H6T5gyNgL5Vxb122H+oQgJTQxZ822EpZvxFBMYh0M # CIKoFr2pVs8Vc40BIiXOlWk/R3f7cnQU1/+rT4osequFzUNf7WC2qk+RZp4snuCK # rOX9jLxkJodskr2dfNBwCnzvqLx1T7pa96kQsl3p/yhUifDVinF2ZdrM8HKjI/rA # J4JErpknG6skHibBt94q6/aesXmZgaNWhqsKRcnfxI2g55j7+6adcq/Ex8HBanHZ # xhOACcS2n82HhyS7T6NJuXdmkfFynOlLAlKnN36TU6w7HQhJD5TNOXrd/yVjmScs # PT9rp/Fmw0HNT7ZAmyEhQNC3EyTN3B14OuSereU0cZLXJmvkOHOrpgFPvT87eK1M # rfvElXvtCl8zOYdBeHo46Zzh3SP9HSjTx/no8Zhf+yvYfvJGnXUsHicsJttvFXse # GYs2uJPU5vIXmVnKcPA3v5gA3yAWTyf7YGcWoWa63VXAOimGsJigK+2VQbc61RWY # MbRiCQ8KvYHZE/6/pNHzV9m8BPqC3jLfBInwAM1dwvnQI38AC+R2AibZ8GV2QqYp # hwlHK+Z/GqSFD/yYlvZVVCsfgPrA8g4r5db7qS9EFUrnEw4d2zc4GqEr9u3WfPww # ggbAMIIEqKADAgECAhAMTWlyS5T6PCpKPSkHgD1aMA0GCSqGSIb3DQEBCwUAMGMx # CzAJBgNVBAYTAlVTMRcwFQYDVQQKEw5EaWdpQ2VydCwgSW5jLjE7MDkGA1UEAxMy # RGlnaUNlcnQgVHJ1c3RlZCBHNCBSU0E0MDk2IFNIQTI1NiBUaW1lU3RhbXBpbmcg # Q0EwHhcNMjIwOTIxMDAwMDAwWhcNMzMxMTIxMjM1OTU5WjBGMQswCQYDVQQGEwJV # UzERMA8GA1UEChMIRGlnaUNlcnQxJDAiBgNVBAMTG0RpZ2lDZXJ0IFRpbWVzdGFt # cCAyMDIyIC0gMjCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoCggIBAM/spSY6 # xqnya7uNwQ2a26HoFIV0MxomrNAcVR4eNm28klUMYfSdCXc9FZYIL2tkpP0GgxbX # kZI4HDEClvtysZc6Va8z7GGK6aYo25BjXL2JU+A6LYyHQq4mpOS7eHi5ehbhVsbA # umRTuyoW51BIu4hpDIjG8b7gL307scpTjUCDHufLckkoHkyAHoVW54Xt8mG8qjoH # ffarbuVm3eJc9S/tjdRNlYRo44DLannR0hCRRinrPibytIzNTLlmyLuqUDgN5YyU # XRlav/V7QG5vFqianJVHhoV5PgxeZowaCiS+nKrSnLb3T254xCg/oxwPUAY3ugjZ # Naa1Htp4WB056PhMkRCWfk3h3cKtpX74LRsf7CtGGKMZ9jn39cFPcS6JAxGiS7uY # v/pP5Hs27wZE5FX/NurlfDHn88JSxOYWe1p+pSVz28BqmSEtY+VZ9U0vkB8nt9Kr # FOU4ZodRCGv7U0M50GT6Vs/g9ArmFG1keLuY/ZTDcyHzL8IuINeBrNPxB9Thvdld # S24xlCmL5kGkZZTAWOXlLimQprdhZPrZIGwYUWC6poEPCSVT8b876asHDmoHOWIZ # ydaFfxPZjXnPYsXs4Xu5zGcTB5rBeO3GiMiwbjJ5xwtZg43G7vUsfHuOy2SJ8bHE # uOdTXl9V0n0ZKVkDTvpd6kVzHIR+187i1Dp3AgMBAAGjggGLMIIBhzAOBgNVHQ8B # Af8EBAMCB4AwDAYDVR0TAQH/BAIwADAWBgNVHSUBAf8EDDAKBggrBgEFBQcDCDAg # BgNVHSAEGTAXMAgGBmeBDAEEAjALBglghkgBhv1sBwEwHwYDVR0jBBgwFoAUuhbZ # bU2FL3MpdpovdYxqII+eyG8wHQYDVR0OBBYEFGKK3tBh/I8xFO2XC809KpQU31Kc # MFoGA1UdHwRTMFEwT6BNoEuGSWh0dHA6Ly9jcmwzLmRpZ2ljZXJ0LmNvbS9EaWdp # Q2VydFRydXN0ZWRHNFJTQTQwOTZTSEEyNTZUaW1lU3RhbXBpbmdDQS5jcmwwgZAG # CCsGAQUFBwEBBIGDMIGAMCQGCCsGAQUFBzABhhhodHRwOi8vb2NzcC5kaWdpY2Vy # dC5jb20wWAYIKwYBBQUHMAKGTGh0dHA6Ly9jYWNlcnRzLmRpZ2ljZXJ0LmNvbS9E # aWdpQ2VydFRydXN0ZWRHNFJTQTQwOTZTSEEyNTZUaW1lU3RhbXBpbmdDQS5jcnQw # DQYJKoZIhvcNAQELBQADggIBAFWqKhrzRvN4Vzcw/HXjT9aFI/H8+ZU5myXm93KK # mMN31GT8Ffs2wklRLHiIY1UJRjkA/GnUypsp+6M/wMkAmxMdsJiJ3HjyzXyFzVOd # r2LiYWajFCpFh0qYQitQ/Bu1nggwCfrkLdcJiXn5CeaIzn0buGqim8FTYAnoo7id # 160fHLjsmEHw9g6A++T/350Qp+sAul9Kjxo6UrTqvwlJFTU2WZoPVNKyG39+Xgmt # dlSKdG3K0gVnK3br/5iyJpU4GYhEFOUKWaJr5yI+RCHSPxzAm+18SLLYkgyRTzxm # lK9dAlPrnuKe5NMfhgFknADC6Vp0dQ094XmIvxwBl8kZI4DXNlpflhaxYwzGRkA7 # zl011Fk+Q5oYrsPJy8P7mxNfarXH4PMFw1nfJ2Ir3kHJU7n/NBBn9iYymHv+XEKU # gZSCnawKi8ZLFUrTmJBFYDOA4CPe+AOk9kVH5c64A0JH6EE2cXet/aLol3ROLtoe # HYxayB6a1cLwxiKoT5u92ByaUcQvmvZfpyeXupYuhVfAYOd4Vn9q78KVmksRAsiC # nMkaBXy6cbVOepls9Oie1FqYyJ+/jbsYXEP10Cro4mLueATbvdH7WwqocH7wl4R4 # 4wgDXUcsY6glOJcB0j862uXl9uab3H4szP8XTE0AotjWAQ64i+7m4HJViSwnGWH2 # dwGMMYIFXTCCBVkCAQEwgYYwcjELMAkGA1UEBhMCVVMxFTATBgNVBAoTDERpZ2lD # ZXJ0IEluYzEZMBcGA1UECxMQd3d3LmRpZ2ljZXJ0LmNvbTExMC8GA1UEAxMoRGln # aUNlcnQgU0hBMiBBc3N1cmVkIElEIENvZGUgU2lnbmluZyBDQQIQAwW7hiGwoWNf # v96uEgTnbTANBglghkgBZQMEAgEFAKCBhDAYBgorBgEEAYI3AgEMMQowCKACgACh # AoAAMBkGCSqGSIb3DQEJAzEMBgorBgEEAYI3AgEEMBwGCisGAQQBgjcCAQsxDjAM # BgorBgEEAYI3AgEVMC8GCSqGSIb3DQEJBDEiBCDLIAtJ72F/Lc7QV0Zzk4ANbujr # ZrmVYEGtZXguooYCcDANBgkqhkiG9w0BAQEFAASCAQB075KEQ0XoG9eY9S+D59Nk # MjXfTZpKRv5kxFLMMymqFZGAZIuxwmGV3pRNy+l4AJVbHdd8zm4X4NFKeCR7dlhf # X6cXhyfi8MwtLsUh9x4sl36q6HW8nUjS6aZXG+fjlICeXARx+bK/7C8Li2Pl4VIi # J27mD/MViPHvq/XYDVIJSEoHtJXtp8I0BH7t7VK4weZBYF36yugNNWf3cY2yqzxH # gY6Bl698yM90KC6agoBqerf3Yw+c3ppnUIKqU0+GAjysoIZ7BRzYHlmyWYCgeS6b # kTqmduOwTZBDmqN/JE7geQ8DSBlIm56wn3PqXimaQlGBIJm0OmgDem0XYSPlWvpQ # oYIDIDCCAxwGCSqGSIb3DQEJBjGCAw0wggMJAgEBMHcwYzELMAkGA1UEBhMCVVMx # FzAVBgNVBAoTDkRpZ2lDZXJ0LCBJbmMuMTswOQYDVQQDEzJEaWdpQ2VydCBUcnVz # dGVkIEc0IFJTQTQwOTYgU0hBMjU2IFRpbWVTdGFtcGluZyBDQQIQDE1pckuU+jwq # Sj0pB4A9WjANBglghkgBZQMEAgEFAKBpMBgGCSqGSIb3DQEJAzELBgkqhkiG9w0B # BwEwHAYJKoZIhvcNAQkFMQ8XDTIzMDUxMjAwMjUzNFowLwYJKoZIhvcNAQkEMSIE # ICozW4/xBqziZLwZSE0d4vUOqGb+KZQ+Z94IZnIxPEVYMA0GCSqGSIb3DQEBAQUA # BIICAMcJII6YpFcMkCvPlCLKtziHShOkfSc94Rdq3agQgFd9EEsBByneq31DMuah # o9PYg4PzBgbyA5E0ixTKa+XUa+nDNNh0VVw4lAKXVpMzUToHcsefFjaXB5JVO6D5 # mAvMn3EgiCppD8RbyGmR9wqkQn35LnmxhA8pjJBHfQAbTlo23Rcoe5GL/oCAJy2B # 1HVIfN6/OektKCzqAFIhHVlxLk7OYPFupRKoc73kYFlD0YdyhwstQ5UiOEa4Cp1U # dQfPiVpF6RwSKdxfWhH2isOOE1tBQZWuK45pW8pp38OOlHvqSQ4r1hzC1psdG2WK # 1Kdq43+QARm6PoC+6/9losFmhtQynxDDy/S5ceQrhtrNl2ZDO84OGZrb5k7E3dtI # YUoba5/Ow5u8xvJTXJkP5LFzP+z/1/xXvi/NL3ZjsUlOco4yMZrPRLUQ8xD7GM7i # 3zkvSepIzEnkm8eqy5mA152QXlHXXRMuXSrQWlHQXqaJBBX2qJO1LuyuHRyB4HCt # vkjztpNRCfIRXxYZLaOQ3tUqdNVa16pqw6a8B39urZRAuFI7gwBPV7/fYGJoEus3 # 02E6wILeQqyYqq4ukEOFtojl1g4bR1LtfDSxwQediTnN6+kYFaolx224gRrPWkER # A3SJXTKl+MCiWa1vwG5AEhvc8c/j4fhqZ+tqfiXfO/jBQxr+ # SIG # End signature block |