Does WMI query allow group by?

Question

I have a WMI query on Win32_Processor. When I test the query on a server that has 2 processors with 4 cores each it returns the same information for each core. Does WMI query allows group by, lets say, Win32_Processor.Caption when I send the query?

Answer 1

No, the WMI querys uses the WQL language which is a subset of the ANSI SQL and doesn't supports the group by clause.

Note : don't confuse with the WQL GROUP Clause which is valid only for event querys.