Query Details
Device Join Types
Query
// Show all devices and Join Types IntuneDevices | where OS == "Windows" | where isnotempty(JoinType) | distinct JoinType, DeviceName, DeviceRegistrationState // Show only Hybrid Azure AD Joined Devices: IntuneDevices | where OS == "Windows" | where isnotempty(JoinType) | where JoinType has "Hybrid" | distinct JoinType, DeviceName, DeviceRegistrationState // Show only Azure AD Joined Devices: IntuneDevices | where OS == "Windows" | where isnotempty(JoinType) | where JoinType == "Azure AD joined" | distinct JoinType, DeviceName, DeviceRegistrationState // Show only Azure AD registered Devices: IntuneDevices | where OS == "Windows" | where isnotempty(JoinType) | where JoinType == "Azure AD registered" | distinct JoinType, DeviceName, DeviceRegistrationState
Explanation
This query is used to filter and display information about different types of devices registered with Intune, specifically those running the Windows operating system.
The first part of the query shows all devices, regardless of their join type, as long as the join type field is not empty.
The second part of the query filters the devices further to only show those that are Hybrid Azure AD Joined.
The third part of the query shows only devices that are Azure AD Joined.
The final part of the query shows only devices that are Azure AD registered.
In all cases, the query returns distinct values for the join type, device name, and device registration state.
Details
Ugur Koc
Released: July 31, 2022
Tables
IntuneDevices
Keywords
IntuneDevices,Windows,JoinType,Hybrid,AzureADJoined,AzureADRegistered,DeviceName,DeviceRegistrationState
Operators
whereisnotemptyhasdistinct