Device Unsupported Android Versions
Query
// Out-of-support Android Versions
IntuneDevices
| where OS has "Android"
| extend Version = todecimal(OSVersion)
| where Version < 10
| where DeviceName != "User deleted for this device"
| where Ownership == "Corporate"
| project DeviceName, UserName , Version, OwnershipExplanation
This query is looking for Android devices in the IntuneDevices database that are running on an Android version less than 10, which are considered out-of-support versions. It excludes any devices where the user has been deleted and only includes devices that are owned by the corporation. The query then displays the device name, username, Android version, and ownership status.
Details
Ugur Koc
Released: August 4, 2022
Tables
IntuneDevices
Keywords
IntuneDevicesOSAndroidVersionOSVersionDeviceNameUserOwnershipCorporateUserName
Operators
hastodecimalwhereextendproject<!===