Limitations of Extended WQL in ConfigMgr
Extended WQL has certain limitations in Configuration Manager (either inherently or because of the SMS Provider) to be aware of when writing queries. The following list explains these limitations:
• The use of COUNT does not display properly in query results and is therefore not useful for querying through the Configuration Manager console.
• COUNT and DISTINCT cannot be used together in a WQL query.
• Although supported, UPPER and LOWER is not helpful because WQL is entirely case-insensitive.
• The SMS Provider does not support querying against system properties. These properties are easily identifiable because they all begin with a double underscore like __CLASS, __NAMESPACE, __PATH, and so on.
• If ...
Get System Center 2012 Configuration Manager Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
