KQL Search

Query Details

HomeAI ToolsDevice Query

Device Visualizethe Windows Build Numbersandthenumberof Devices

Query

// Visualize the Windows Build Numbers and the number of Devices 
IntuneDevices
| where OS == "Windows"
| summarize arg_max(TimeGenerated, *) by DeviceName
| where todatetime(LastContact) > ago(30d) // Include only Devices that had a connection with Intune in the last 30 days.
| summarize Devices = count() by OSVersion
| where OSVersion != "0.0.0.0" // Exclude devices that have not reported the Windows Build.
| sort by Devices
| render columnchart // Visualize the output.
    with (
    kind=unstacked,
    ytitle="Device Count",
    xtitle="Windows Build",
    title="Number of Devices by Windows Build")

Explanation

This query is designed to visualize the number of devices running different versions of Windows that have connected to Intune in the last 30 days. It excludes devices that have not reported their Windows build version. The results are displayed in a column chart, with the number of devices on the y-axis and the Windows build version on the x-axis.

Details

Ugur Koc profile picture

Ugur Koc

Released: July 7, 2022

Tables

IntuneDevices

Keywords

Visualize,Windows,BuildNumbers,Devices,IntuneDevices,OS,TimeGenerated,DeviceName,LastContact,Days,OSVersion,DeviceCount,WindowsBuild,NumberofDevices

Operators

IntuneDeviceswhereOSsummarizearg_maxTimeGenerated*byDeviceNametodatetimeLastContactagocountOSVersionsortrendercolumnchartwithkindunstackedytitlextitletitle.

Actions