My Favorite CMPivot Queries

There are plenty of CMPivot examples out there, but here are a few of my favorites that I use pretty much every week. Enjoy 🙂

Lookup installed application by product name

InstalledSoftware | where (ProductName like '%Stifler%')

Lookup installed application count by product name

InstalledSoftware | summarize count() by ProductName, ProductVersion | where (ProductName like '%Stifler%')

Get Free Disk Space in GB

Disk
| where Name == 'C:'
| project Device,Name,Description,TotalSizeInGB=(Size/1024/1024/1024),FreeSpaceInGB=(FreeSpace/1024/1024/1024)