FYI.... Someone pointed out an error in the query below. I had put in "and
IsCompliant = '0'" for testing some stuff. I should have removed that before
posting the query.
________________________________
John Marcum
MCITP, MCTS, MCSA
Desktop Architect
Bradley Arant Boult Cummings LLP
________________________________
[MVP] <https://mvp.microsoft.com/en-us/overview>
[MMS] <http://mmsmoa.com/>
From: [email protected] [mailto:[email protected]] On
Behalf Of Marcum, John
Sent: Wednesday, February 24, 2016 2:52 PM
To: [email protected]
Subject: [mssms] RE: Report of Enrolled Mobile Devices
I think I put a thing on user voice to be able to add the user for the device.
As you know when CM12 was designed they weren't really thinking about mobile
devices. Since PC's can have multiple primary users having that column is not
possible, at least not in any collection that can also contain PC's. I don't
have nearly as many devices as you do but I just throw them all into a
collection and I don't really care where they are or who they belong to. If I
need to perform an action on Sue's iPhone I look up Sue and go to her primary
device. I also wrote a couple simple reports to link users to devices. Those I
did blog.
http://systemcenteradmin.com/?p=89
________________________________
John Marcum
MCITP, MCTS, MCSA
Desktop Architect
Bradley Arant Boult Cummings LLP
________________________________
[MVP] <https://mvp.microsoft.com/en-us/overview>
[MMS] <http://mmsmoa.com/>
From: [email protected]<mailto:[email protected]>
[mailto:[email protected]] On Behalf Of Lindenfeld, Ivan
Sent: Wednesday, February 24, 2016 2:44 PM
To: [email protected]<mailto:[email protected]>
Subject: [mssms] RE: Report of Enrolled Mobile Devices
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]>
[mailto:[email protected]] On Behalf Of Marcum, John
Sent: Wednesday, February 24, 2016 3:28 PM
To: [email protected]<mailto:[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.
