Examples of WQL search for systems with or without a particular software version installed. Internet Explorer used for example.
This WQL query shows systems with both Shockwave player 11 and Shockwave Player 12.
Using SCCM and compliance settings, you want to search for old profiles (unused for 90 days). You want to make sure only Domain (not local ) account profiles are wiped out. And you want an exception list, stored in an AD group. When found, you want to report on Compliance (if no outdated profiles) and you want to remediate if found.
To create a query with a prompt, use the ##PRM:[fieldname]## structure. This example will list all users and computers in a collection.
The new operating system uses branches to control when updates are applied. Make collections to show Windows 10 Current Branch, Current Business Branch, etc.
The tables in SCCM for WQL queries against the WMI namespace are easily found using the WMIExplorer utility. SCCM exposes all the classes through WMI, so you can find the right namespace, class, instance, and properties.
The information you want is in SMS_UserMachineIntelligence (WQL) or v_UserMachineIntelligence (SQL)