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.
[dbo].[UserConfig] uc on sdms.[UserConfigId] = uc.[Id]