This shows what updates should have been applied but are still missing, based on a deployment to an update group. Using an Update Group as a filter, show me all the missing updates that SCCM thinks are required. Given: A computer or list of computers Change the computer name(s) in Where clause at the bottom … Continue reading Windows updates deployed through an update group but missing from a system or collection
Find advertisements (packages) where a system reported a status in the last N days. For example, what advertisements were applied last night? Or in the last week? Includes old advertisements that were recently applied, so it helps with cleanup of old packages.
A nice SQL query for showing what Software Updates are pending.
The information you want is in SMS_UserMachineIntelligence (WQL) or v_UserMachineIntelligence (SQL)