SQL Query to export/list all users in your Blackberry Server Farm

If you want a fast and easy way to list all the Blackberry users in your farm, with relevant information, run the below SQL query against the BESMgmt database on your Blackberry SQL database.

It will return the following information:
Users Display name
BES Server they are on
Exchange server their mailbox is on
PIN of their BES
IT Policy they are using
Software Configuration they are using
Model of their Blackberry
Versions of their BES software
IEME of their Blackberry

select userconfig.DisplayName as [Name], ServerConfig.ServiceName as [BES Server] , userconfig.ServerDN [Exchange Server], userconfig.pin as [PIN], ITPolicy2.PolicyName as [IT Policy], HandHeldConfig.Name as [Software Configuration], SyncDeviceMgmtSummary.ModelName as [BBModel], SyncDeviceMgmtSummary.PlatformVer as [PlatformVer], SyncDeviceMgmtSummary.AppsVer as [AppsVer], SyncDeviceMgmtSummary.IMEI as [IMEI], UserConfig.CreationTime as [CreationTime] FROM UserConfig left JOIN ServerConfig ON UserConfig.ServerConfigID = ServerConfig.ID left JOIN ITPolicy2 ON UserConfig.ITPolicy2Id = ITPolicy2.ID left JOIN UserStats ON UserConfig.ID = UserStats.ID left JOIN HandHeldConfig ON HandHeldConfig.ID = UserConfig.HandHeldConfigID left JOIN SyncDeviceMgmtSummary ON SyncDeviceMgmtSummary.UserConfigID = UserConfig.ID

No related posts.

6 Responses to “SQL Query to export/list all users in your Blackberry Server Farm”

1. Avinash Shitole says:

   September 3, 2009 at 3:23 pm

   This is great exact query/script I was looking for .
   Thanks and Regards
   Avinash R Shitole
2. acnemobo says:

   November 10, 2009 at 9:24 pm

   i really love this Blackberry because of its functionality and design.. this is a very cool electronic gadget for staying in touch with your friends and family member.
3. Christian Pohle says:

   November 19, 2009 at 9:19 pm

   Great Example, thank you. This save hours of searching in which table the IMEI is stored.
   Christian
4. blackberry farm says:

   March 30, 2010 at 9:26 am

   [...] Farm. Luxury in the Middle of Nowhere: Blackberry Farm February 08, 2007 12:55:47 PM EST …SQL Query to export/list all users in your Blackberry Server FarmSQL Query to export/list all users in your Blackberry Server Farm … i really love this Blackberry [...]
5. Powershell: Inventaire Mobile Blackberry et Activesync sous Exchange says:

   November 18, 2011 at 9:10 am

   [...] vous voulez plus d’exemples de requêtes SQL sur BES vous pouvez lire ce post ou bien ce forum qui nécessite l’utilisation des Cmdlets SQL 2008. Le script ci dessus [...]
6. Powershell: Blackberry and Activesync mobile devices inventory says:

   November 22, 2011 at 3:11 am

   [...] you need more details on how to query the BESMGMT database you can read this post or this forum topic, which discusses how to query the database with SQL 2008 CmdLets (you will need [...]