System Center 2012 Configuration Manager Unleashed

WMI Query Language

ConfigMgr query expressions are written in WQL. Using WQL lets you gather information from the site database by accessing information through the WMI provider. If you are familiar with Structured Query Language (SQL) queries, the format of WQL queries should look familiar because WQL is a subset of SQL.

WQL is a Microsoft implementation of the CIM Query Language (CQL). CQL is a query language designed for the Common Information Model (CIM), a standard created by the Distributed Management Task Force (DMTF). That is quite a history of acronyms!

Here is an example of a WQL query that lists devices with more than 1,024MB of RAM:

select * from  SMS_R_System inner join SMS_G_System_X86_PC_MEMORY onSMS_G_System_X86_PC_MEMORY.ResourceID ...