Query Details
Device Number Of Devices And Manufacturers
Query
// List of device models and Manufacturers and number of devices for each model IntuneDevices | where OS == "Windows" | summarize count(DeviceName) by Model, Manufacturer
Explanation
This query is pulling a list of device models and their manufacturers from a group of devices managed by Intune that are running the Windows operating system. It also counts the number of devices for each specific model.
Details
Ugur Koc
Released: July 16, 2022
Tables
IntuneDevices
Keywords
IntuneDevices,OS,Windows,DeviceName,Model,Manufacturer
Operators
wheresummarizecountby