Query Details

Compliance Intune Devices That Are Compliant With OS OS Version

Query

// Intune devices that are compliant with OS, OS Version, and number of devices
// See here: https://github.com/rod-trent/SentinelKQL/blob/master/IntuneisCompliantByOSandOSVersion.txt
IntuneDeviceComplianceOrg 
| where isnotempty(DeviceName)
| where ComplianceState == "Compliant"
| summarize count() by OSDescription, OSVersion

Explanation

This query retrieves information about Intune devices that are compliant with the operating system (OS), OS version, and the number of devices. It filters out devices with empty names and only includes devices that have a compliance state of "Compliant". The query then summarizes the count of devices based on the OS description and OS version.