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)