KQL Search

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 profile picture

Ugur Koc

Released: July 19, 2022

Tables

IntuneDevices

Keywords

DevicesIntunePrimaryUser

Operators

wherestartswithproject

Actions

GitHub