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.
This returns a list of updates applied to a system, including timestamp and KB number.
This returns a list of all package-based deployments to a single or set of computers. Useful when determining what was deployed last night. Includes code for selecting the last 72 hours, for example.
The information you want is in SMS_UserMachineIntelligence (WQL) or v_UserMachineIntelligence (SQL)
Views are the foundation for the WQL queries that SCCM exposes. Here are some tricks for finding the names of views.