Run this against the SQL database to clean up the database.
Given a deployment ID, the shows the failed systems with username and status. Ideal for Path Tuesday remediation, to find the failed systems.
This will read the registry to (CCS/Services) to find the entry for the service, then follw that to the filename, and verify the version is at least the minimum version. Used for making sure the Trend Micro service is up to date.
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. Another version is at the bottom - I had to modify it to work with earlier versions … 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.
Computers that received a deployment