KQL Search

Query Details

HomeAI ToolsDevice Query

Device I OS Versions

Query

// Number of iPhones and iPads on Version 14, 15, 16
let version_16 =
IntuneDevices 
| where OS == "iOS/iPadOS"
| where OSVersion contains  "16"
| summarize ['iOS 16'] = count(DeviceName)
| extend Dummy = "Number of Devices";
let version_15 =
IntuneDevices 
| where OS == "iOS/iPadOS"
| where OSVersion contains  "15"
| summarize ['iOS 15'] = count(DeviceName)
| extend Dummy = "Number of Devices";
let version_14 =
IntuneDevices
| where OS == "iOS/iPadOS"
| where OSVersion contains  "14"
| summarize ['iOS 14'] = count(DeviceName)
| extend Dummy = "Number of Devices";
version_16
| join kind=inner version_15 on Dummy 
| join kind=inner version_14 on Dummy 
| distinct Dummy, ['iOS 14'], ['iOS 15'], ['iOS 16']

Explanation

This query is counting the number of iOS/iPadOS devices that are on OS versions 14, 15, and 16. It does this by filtering the IntuneDevices dataset for each OS version separately, counting the number of devices for each, and then joining these counts together. The final output is a table that shows the number of devices on each of these three OS versions.

Details

Ugur Koc profile picture

Ugur Koc

Released: July 30, 2022

Tables

IntuneDevices

Keywords

IntuneDevices,OS,iOS/iPadOS,OSVersion,DeviceName,NumberofDevices,iOS14,iOS15,iOS16

Operators

letIntuneDeviceswherecontainssummarizecountextendjoinkindinnerdistinct.

Actions