This can help clear up problems where the systems are orphaned and you are having trouble deploying to it through PXE.
Examples of WQL search for systems with or without a particular software version installed. Internet Explorer used for example.
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 WQL query shows systems with both Shockwave player 11 and Shockwave Player 12.
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.