O'Reilly logo

System Center 2012 Configuration Manager Unleashed by Greg Ramsey., Jason Sandys, Marcus Oh, Byron Holt, Kerrie Meyler

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required