Useful ConfigMgr query for Intune Enrolled Devices

The following SQL query was shared by Gerjan Eghuizen an Unified Communications Consultant working at Enexis and Niels Buit (Microsoft), useful for anyone who has Mobile Devices enrolled via Microsoft Intune in ConfigMgr 2012 R2. The end-result is a report with this information (clickable): The SQL query: CREATE TABLE          #machines          (          DeviceID uniqueidentifier, — Remove…

1