Query Details
Device Visualize Android Versions
Query
// Visualize Android Versions and filtering for devices that had a connection to intune in the last 30 days. IntuneDevices | where OS contains "Android" | where todatetime(LastContact) > ago(30d) | summarize arg_max(TimeGenerated, *) by DeviceName | summarize Versionen=count() by OSVersion | sort by Versionen desc | render piechart with (title="Android Versions")
Explanation
This query is designed to visualize the different versions of Android operating systems used on devices that have connected to Intune in the past 30 days. It filters out devices based on their operating system and last contact time, then groups them by device name and Android version. It then counts the number of devices using each Android version and sorts this data in descending order. The results are displayed in a pie chart titled "Android Versions".
Details
Ugur Koc
Released: August 13, 2022
Tables
IntuneDevices
Keywords
Visualize,AndroidVersions,Devices,Intune,Connection,Last30Days,TimeGenerated,DeviceName,OSVersion,Piechart,Title
Operators
containstodatetimeagosummarizearg_maxbycountsortrenderpiechartwhere