Query Details
Compliance List Of Devices That Have Device Health Threat Level Status Of Secured
Query
// List of Devices that have DeviceHealthThreatLevel Status of Secured IntuneDeviceComplianceOrg | where isnotempty(DeviceHealthThreatLevel) | where DeviceHealthThreatLevel == "Secured" | project DeviceName, UserName , DeviceHealthThreatLevel
Explanation
This query is pulling a list of devices from the IntuneDeviceComplianceOrg database that have a status of "Secured" in the DeviceHealthThreatLevel field. It is specifically filtering out any entries where the DeviceHealthThreatLevel field is empty. The final output of this query will show the device name, the username associated with the device, and the device's health threat level.
Details
Ugur Koc
Released: June 25, 2022
Tables
IntuneDeviceComplianceOrg
Keywords
List,Devices,DeviceHealthThreatLevel,Status,Secured,IntuneDeviceComplianceOrg,Isnotempty,Project,DeviceName,UserName
Operators
IntuneDeviceComplianceOrgisnotempty()where==project