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 ...

Get System Center 2012 Configuration Manager Unleashed now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.