KQL Search

Query Details

Intune Not Compliant

Query

IntuneDeviceComplianceOrg
| where ComplianceState <> "Not Compliant" and isnotempty(ComplianceState)
| project TimeGenerated , ComplianceState , DeviceName , DeviceId , OS , UserName , UserEmail

Explanation

This query retrieves information about Intune device compliance for an organization. It filters out devices that are not compliant and have a non-empty compliance state. The resulting data includes the time it was generated, compliance state, device name, device ID, operating system, username, and user email.