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)
About the author

Johan Arwidmark

5 2 votes
Article Rating
Subscribe
Notify of
guest
1 Comment
Newest
Oldest Most Voted
Inline Feedbacks
View all comments
Nilanshu
Nilanshu
2 months ago

Awesome


>