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

Bookmark It

Hide Sites

Related posts:

1. Setting a default list item in a drop down list
2. SSH on Blackberry (Mobile SSH)
3. Essential BlackBerry Apps

Grab our Newsletter to Ensure your PC is Running Smooth!