KQL Search

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.

Details

Ugur Koc profile picture

Ugur Koc

Released: December 29, 2022

Tables

IntuneDeviceComplianceOrg

Keywords

IntuneDevicesOSOSVersion

Operators

whereisnotempty==summarizecount()by

Actions

GitHub