SCCM Status Message 10025 tells me a computer has a problem:
Download of the content "666e73df-99fa-4ceb-8f87-c428cf173384" - "1" has failed..
Possible cause: The content can not be found on the network, or the content could not be accessed.
Package ID : 666e73df-99fa-4ceb-8f87-c428cf173384
Client SMS Unique ID : GUID:B2C5EE67-9B68-4539-AF4B-DF9D6B6DE90A
If I have a look at the updates store log on the specific computer having a problem , I can now see what the update is that is failing:
Queried Update (666e73df-99fa-4ceb-8f87-c428cf173384): Status=Missing, Title=Update for Windows 7 for x64-based Systems (KB2952664), BulletinID=, QNumbers=2952664, LocaleID=, ProductID=cd5ffd1e-e932-4e3a-bf74-18bf0b1bbd83, UpdateClassification = cd5ffd1e-e932-4e3a-bf74-18bf0b1bbd83, ExcludeForStateReporting=FALSE.
My question is , how in powershell can I use the SCCM Cmdlets or WIM queries to the Primary server ( I have one site only and DPs) to translate "666e73df-99fa-4ceb-8f87-c428cf173384" through to the Product ID "cd5ffd1e-e932-4e3a-bf74-18bf0b1bbd83" or Title "Update for Windows 7 for x64-based Systems (KB2952664)" or something similar.
I wish to avoid any SQL queries if possible