Query Details

Intune Devices Not Supported

Query

//Devices not supported by time, failure type, and operating system

IntuneOperationalLogs
| extend FailureCategory_ = tostring(parse_json(Properties).FailureCategory)
| where FailureCategory_ == "DeviceNotSupported"
| extend Os_ = tostring(parse_json(Properties).Os)
| project TimeGenerated , FailureCategory_ , Os_

Explanation

This query retrieves operational logs from Intune and filters for devices that are not supported based on the failure category, operating system, and time. It then projects the time generated, failure category, and operating system of these devices.

Details

Rod Trent profile picture

Rod Trent

Released: August 25, 2020

Tables

IntuneOperationalLogs

Keywords

Devices,Intune,User,FailureCategory,Os,TimeGenerated

Operators

extendtostringparse_jsonwhere==project

Actions