Query Details
Device Listofall Devicesthatwhereaddedto Intunewith OS Platforminformation
Query
// List of all Devices that where added to Intune with OS Platform information in a specific timeframe IntuneDevices | where CreatedDate contains "2022-06" # You can change the month and year if you want or delete the line completely | where Ownership == "Corporate" | project DeviceName, OS, OSVersion, UserName, CreatedDate | summarize count(DeviceName) by OS
Explanation
This query is used to generate a list of all corporate-owned devices that were added to Intune within a specified timeframe (in this case, June 2022). The query provides information about the device name, operating system (OS), OS version, the user associated with the device, and the date it was added. Finally, it counts the number of devices based on their operating system.
Details
Ugur Koc
Released: July 6, 2022
Tables
IntuneDevices
Keywords
IntuneDevices,CreatedDate,Corporate,DeviceName,OS,OSVersion,UserName
Operators
containswhereprojectsummarizecount