Forum Discussion
When querying via CMPivot with a summarize operator, the query results are always blank.
Hey Community, thought i'd open a discussion here to see if anyone else has come across this behaviour before....before I go and raise a MS Support case,which more often than not, only leads to pain and agony!
When querying via CMPivot with a summarize operator, the query results are always blank. If the query is not filtered / summarized, results are received fine. I can THEN run a summarize query and it will work but looks to only be on the cached results from the previous 'non-filtered/summarized' query.
Steps to replicate,
1. Open CMPivot on collection and query with summarize operator.
No results returned.
2. Remove summarize from query, results are returned.
InstalledSoftware | where (ProductName == 'some_software')
3. Append summarize back into query & hit Run Query, results are shown.
InstalledSoftware | where (ProductName == 'some_software') | summarize dcount(Device) by ProductVersion
Reviewing https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/cmpivot-tsg, smsprov does not show any execution of the query which is weird, maybe out of date doco?