Messages

Is this also true for Regular Windows Updates patches? We are also considering migrating to Company Portal, but the visibility of Windows Updates and patches visible in the Software Center is not available in Company Portal.

This means that you cannot totally replace Software Center with Company Portal for Windows Patches and Operating System Update/Install deployment visibility?

Great

In the mean time to make my life easier I made a small powershell script for easier viewing the catalog and dump the selected lines into a csv

Code Select Expand

#!PowerShell
## This Script quickly lists the download URI and more of each PatchMyPC package in easy readable format.
## CopyRight (c) NRG ITS
## Author: M.A. Bernards
## Date: 11/9/2023
## Version: 1.0

# Slurp in the PatchMyPC XML data into an object stream
$LatestCatalog = "C:\Program Files\Patch My PC\Patch My PC Publishing Service\Latest Catalog\PatchMyPC.xml"
[xml]$Xml = Get-Content $LatestCatalog

# Iterate the catalog items and create a new object stream

$result = foreach ($Item in $xml.SystemsManagementCatalog.SoftwareDistributionPackage ) {
    [PSCustomObject]@{
        'Title' = $Item.LocalizedProperties.Title
        'CreationDate' = $Item.Properties.CreationDate
        'OriginUri'   = $Item.InstallableItem.OriginFile.OriginUri
        'SupportUrl' = $Item.Properties.SupportUrl
        'MoreInfoUrl' = $Item.Properties.MoreInfoUrl
        'KBArticleID' = $Item.UpdateSpecificData.KBArticleID
        'SecurityBulletinID' = $Item.UpdateSpecificData.SecurityBulletinID
        'MsrcSeverity' = $Item.UpdateSpecificData.MsrcSeverity
        'UpdateClassification' = $Item.UpdateSpecificData.UpdateClassification
        # 'CVE' = $Item.UpdateSpecificData.CveID Als listed in Description, need conversion to string from system.Object[]
        'Description' = $Item.LocalizedProperties.Description
    }
}

# Send it to a readable gridview and dump a CSV with selected items

$result | Out-GridView -PassThru | Export-CSV -NoTypeInformation -Path "$PSScriptRoot\PatchMyPCDownloads.csv"
"Created $PSScriptRoot\PatchMyPCDownloads.csv"

# $result | Export-CSV -NoTypeInformation -Path "$PSScriptRoot\AllPatchMyPCDownloads.csv" # Full Dump


The issue is for each application which the url is not reachable by the SCCM Site server.
We normally dont hook up our internal servers directly to the internet, but for specific services we use limited access filters in our firewalls, mostly microsoft cloud services related. for the applications with blocked URLs I keep an eye on the result mails and do some manual intervention picking up the URL and doing the download manually

Pretty much every application without direct connection do not report the download URL any more since this release.

Here is another example

Code Select Expand

Searching CitrixWorkspaceApp22.3.5000.5107.exe in D:\Sources\Software\PatchMyPC_Licensed or one of its subfolders... LocalContentManager 11/1/2023 7:01:42 PM 20 (0x0014)
Cannot find CitrixWorkspaceApp22.3.5000.5107.exe in the local content repository. LocalContentManager 11/1/2023 7:01:42 PM 20 (0x0014)
Configured Download Timeout: 15 minutes and 0 seconds WebClientEx 11/1/2023 7:01:42 PM 20 (0x0014)
WebClient reported an error during download: The underlying connection was closed: An unexpected error occurred on a send. FileDownloader 11/1/2023 7:01:43 PM 64 (0x0040)
A web error occurred while downloading the file:  SendFailure FileDownloader 11/1/2023 7:01:43 PM 20 (0x0014)
Removing download job 81faa6fa-75e2-4176-9078-d1beab946b23 [CitrixWorkspaceApp22.3.5000.5107.exe] from the processing queue. QueueManager 11/1/2023 7:01:43 PM 20 (0x0014)

Yeah, i noticed that too in the latest 2.1.18.0 version
Since the SCCM site server at our site has partially internet connection (mostly microsoft only) it needs some manual intervention for some applications, but now you have to dig up the URLs from {PMPINSTLOC}\Latest Catalog\PatchMyPC.xml