Query Details
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, Ownership
Explanation
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
IntuneDevices,OS,iOS,Version,OSVersion,DeviceName,User,Ownership,Corporate
Operators
hastodecimalwhereextendproject<!===