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.
When a "scheduled update" is applied to an operating system image, it uses the C: drive by default. It stores a copy of the WIM fil in C:\ConfigMgr_OfflineImageServicing. Needless to say, this might not be where you want it. You can change the location by editing the WIM data to reflect the new drive letter.
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