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 SQL script returns the Windows 10 systems including Username, last logon, Activity, Last login, OS version, branch and Code Name.
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