Query Details
Device Visualize Numberof Deviceswithdifferent SKU
Query
// Visualize Number of Devices with different SKU (Pro and Enterprise Versions) IntuneDevices | where OS == "Windows" | where todatetime(LastContact) > ago(30d) // filter for devices that have contacted intune in the last 30 days | summarize arg_max(TimeGenerated, *) by DeviceName | summarize Number=count() by SkuFamily | render piechart
Explanation
This query is used to create a pie chart that visualizes the number of devices with different SKU (Stock Keeping Unit) families, specifically Pro and Enterprise versions, that are using Windows as their operating system. It only considers devices that have been in contact with Intune in the last 30 days. The data is summarized by device name and SKU family.
Details
Ugur Koc
Released: July 4, 2022
Tables
IntuneDevices
Keywords
Visualize,Number,Devices,SKU,Pro,Enterprise,Versions,IntuneDevices,Windows,LastContact,Filter,Days,Arg_max,TimeGenerated,DeviceName,Count,SkuFamily,Piechart
Operators
wheretodatetimeagosummarizearg_maxcountrender