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
Released: August 17, 2020
Tables
IntuneDeviceComplianceOrg
Keywords
Intune,Device,Compliance,Org,TimeGenerated,ComplianceState,DeviceName,DeviceId,OS,UserName,UserEmail
Operators
| where<> andisnotemptyproject