1 min read

CMPivot - count bios version by model

Got asked if we could see what bios versions were out there, and how many, sorted by model, CMPivot to the rescue!

ComputerSystem
| distinct Device, Model 
| join bios 
| project Model, SMBIOSBIOSVersion 
| summarize count() by SMBIOSBIOSVersion, Model