Device Unsupportedi OS Versions
Query
// Out-of-support iOS Versions
IntuneDevices
| where OS has "iOS"
| extend Version = todecimal(OSVersion)
| where Version < 13
| where DeviceName != "User deleted for this device"
| where Ownership == "Corporate"
| project DeviceName, Version, OwnershipExplanation
This query is looking for devices in the IntuneDevices database that are running an iOS version less than 13, which are no longer supported. It excludes any devices where the user has been deleted and only includes devices that are corporately owned. The query then displays the device name, its iOS version, and ownership status.
Details
Ugur Koc
Released: August 5, 2022
Tables
IntuneDevices
Keywords
IntuneDevicesOSiOSVersionOSVersionDeviceNameUserOwnershipCorporate
Operators
hastodecimalwhereextendproject<!===