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.

Details

Rod Trent profile picture

Rod Trent

Released: August 17, 2020

Tables

IntuneDeviceComplianceOrg

Keywords

IntuneDeviceComplianceOrgTimeGeneratedComplianceStateDeviceNameDeviceIdOSUserNameUserEmail

Operators

| where<>andisnotemptyproject

Actions

GitHub