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 , DeviceHealthThreatLevelExplanation
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.