Computers that received a deployment
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)
Views are the foundation for the WQL queries that SCCM exposes. Here are some tricks for finding the names of views.