Query Details
Intuneis Compliant By O Sand OS Version
Query
//Intune devices that are compliant with OS, OS Version, and number of existing IntuneDeviceComplianceOrg | where isnotempty(DeviceName) | where ComplianceState == "Compliant" | summarize count() by OSDescription, OSVersion
Explanation
This query is looking for Intune devices that are compliant with their operating system (OS), operating system version, and the number of existing devices. It filters out any devices that do not have a device name and only includes devices that have a compliance state of "Compliant". The query then summarizes the count of devices based on their OS description and OS version.
Details
Rod Trent
Released: July 14, 2020
Tables
IntuneDeviceComplianceOrg
Keywords
Intune,Devices,ComplianceState,DeviceName,OSDescription,OSVersion
Operators
whereisnotempty==summarizecount()by