Find an Update based on CI ID in Configuration Manager

Get-UpdateNamefromCIID.ps1

#Sometimes your ADR will fail to download content for a specific update ID, and all you have is rule engine. Sometimes SQL is too bothersome, so here is powershell
#To take the update ID and get the name of the udpate that is failing. 
#GLHF

#Enter the site code here instead
$siteCode = "XYZ"
#Enter the CI ID
$ciID = "11111111"
Get-CimInstance -ClassName SMS_SoftwareUpdate -Namespace "root\SMS\site_$($SiteCode)" -Filter "CI_ID = $($ciID)" | Select-Object LocalizedDisplayName,DateCreated