KQL Search

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 profile picture

Ugur Koc

Released: July 4, 2022

Tables

IntuneDevices

Keywords

VisualizeNumberDevicesSKUProEnterpriseVersionsIntuneDevicesWindowsLastContactFilterDaysArg_maxTimeGeneratedDeviceNameCountSkuFamilyPiechart

Operators

wheretodatetimeagosummarizearg_maxcountrender

Actions

GitHub