I AM INTERESTED :) Hey, how do you organize your devices in the console? Ours just enroll as "Jim's iPhone" I get that there is a GUID for each one. I would like to see the Primary User in the console as a column but that doesn't seem possible. And the built in reports are either weak or I am not noticing a folder.
We will have 9000 devices managed by 200 people. Computers are organized by state and City. Not grokking this part yet. Thanks, Ivan From: [email protected] [mailto:[email protected]] On Behalf Of Marcum, John Sent: Wednesday, February 24, 2016 3:28 PM To: [email protected] Subject: [mssms] Report of Enrolled Mobile Devices I should probably blog this kind of thing but I'm too busy or too lazy. Maybe someone will find this handy though. For reason the IsManged flag for mobile devices in ConfigMgr is always set to true. I needed to know which devices connected to EAS were enrolled in MDM and which are not so I came up with this. Hope someone finds it helpful....... SELECT CASE WHEN IsCompliant = '1' THEN 'Device is enrolled' ELSE 'Device is not enrolled' END as 'Enrollment Status', deviceid as 'Device ID', FriendlyName 'Device Name', UserName 'User', DeviceOS 'Operating System', DeviceType 'Device Type', DeviceModel 'Device Model', ExchangeServer 'Exchange Server Connected', max ((left (FirstSyncTimeUTC, 11))) as 'First Sync Time', max ((left (LastSuccessSyncTimeUTC, 11))) as 'Last Sync Time' FROM EAS_Property where DATEDIFF(d,LastSuccessSyncTimeUTC,GetDate()) < 7 and IsCompliant = '0' group by IsCompliant, deviceid, FriendlyName, UserName, DeviceOS, DeviceType, DeviceModel, ExchangeServer, FirstSyncTimeUTC, LastSuccessSyncTimeUTC ________________________________ John Marcum MCITP, MCTS, MCSA Desktop Architect Bradley Arant Boult Cummings LLP ________________________________ [MVP] <https://mvp.microsoft.com/en-us/overview> [MMS] <http://mmsmoa.com/> ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer. ________________________________ NOTICE: The information contained in this message is proprietary and/or confidential and may be privileged. If you are not the intended recipient of this communication, you are hereby notified to: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately.
