Query Details
Device Devices Registered But Not Managed By Intune
Query
// Devices that are registered in Intune but not managed by it. Also shows User and Device Name as well when it was registered Intune. IntuneDevices | where DeviceState != "Managed" | where SourceSystem == "Microsoft Intune" | distinct UserName, DeviceName, SerialNumber, ['Joined Intune Date:'] = CreatedDate, JoinType
Explanation
This query is used to find devices that are registered with Microsoft Intune but are not managed by it. It provides information such as the username, device name, serial number, the date when the device was registered with Intune, and the type of join.
Details
Ugur Koc
Released: August 1, 2022
Tables
IntuneDevices
Keywords
IntuneDevices,DeviceState,SourceSystem,MicrosoftIntune,UserName,DeviceName,SerialNumber,JoinedIntuneDate,CreatedDate,JoinType
Operators
wheredistinct