Query Details
Device Devices And Primary User
Query
// List of Devices and the assigned PrimaryUser. Filtering devices without a PrimaryUser. IntuneDevices //| where OS == "Windows" | where PrimaryUser !startswith "000000" | project DeviceName, PrimaryUser
Explanation
This query is pulling a list of devices and their assigned primary users from the IntuneDevices database. It is specifically filtering out any devices that do not have a primary user assigned to them. The results will only show the device name and the primary user.
Details
Ugur Koc
Released: July 19, 2022
Tables
IntuneDevices
Keywords
Devices,Intune,PrimaryUser
Operators
wherestartswithproject