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]
0 comments:
Post a Comment