Tuesday, February 10, 2009

How to query your BES database for a list of users

I was asked to generate a list of all our BES users, including their name, phone number, PIN, IMEI and device number.  Sure, I could have copied/pasted this data out of the BES management utility, but what fun is that?

It turns out that it’s really easy to query the BESMGMT database for this list.

SELECT
uc.[DisplayName],
sdms.[PhoneNumber],
uc.[PIN],
sdms.[IMEI],
sdms.[ModelName]
FROM
[dbo].[SyncDeviceMgmtSummary] sdms
INNER JOIN
[dbo].[UserConfig] uc on sdms.[UserConfigId] = uc.[Id]

1 comment:

Leslie Lim said...


I have found your blogs to be friendly and welcoming. Thanks for making this one. I really enjoy reading and surfing it. Try to visit my site @ www.imarksweb.org

Zea