Examples of Advanced Queries
It is true that WMI queries are limited in functionality in contrast to SQL queries. However, combining all the query elements discussed in this chapter produces queries of certain complexity. Often times, these queries cannot be displayed in the ConfigMgr console because the graphical user interface (GUI) simply lacks the capability to show all the components.
The next sections provide examples of advanced queries; you should find these useful as a basis for constructing your own queries, using them as-is to tease out data for quick reporting, or applying a complex filter to isolate clients for targeting.
Example: Querying for Devices with a Hardware Scan in the Last 15 Days
The query in this section retrieves any ...