Howto: Export a list of all BES users via the Blackberry Manager tool

A supervisor requested a list of all Blackberry Enterprise Server users in our organization.  I knew if I had the BES resource kit installed I could provide management with a number of reports, but I didn’t have time to go through that process.  Here’s how I quickly exported the list of users through Blackberry Manager 4.1.6:

  1. Open Blackberry Manager 
  2. Highlight Blackberry Domain 
  3. Select the All Users tab
  4. Highlight the entire list of users by selecting the first user, then selecting the last user while holding down the shift key. 
  5. With all the users highlighted, right click a user to bring up the context menu 
  6. Select Export Asset Summary Data
Save the file to a convienent location.  The file will be saved in .txt format, but you can change the file extension to .csv, then open the document in Excel to remove columns or sort data.
If you have multiple BES servers in your environment and only want to list users on a particular server, perform the same steps as above, but instead of selecting Blackberry domain, highlight the server in question and select the Users tab instead of All Users.

4 Responses to “Howto: Export a list of all BES users via the Blackberry Manager tool”

  1. Dale Says:

    You can get those details from the SQL database directly. I’ve seen this code used to do that:

    dbo.UserConfig.DisplayName AS Name,
    dbo.ServerConfig.ServiceName AS [BES Server],
    dbo.UserConfig.ServerDN AS [Exchange Server],
    dbo.UserConfig.PIN AS PIN, dbo.ITPolicy2.PolicyName AS [IT Policy],
    dbo.HandheldConfig.Name AS [Software Configuration],
    dbo.SyncDeviceMgmtSummary.ModelName AS BBModel,
    dbo.SyncDeviceMgmtSummary.PlatformVer AS PlatformVer,
    dbo.SyncDeviceMgmtSummary.AppsVer AS AppsVer,
    dbo.SyncDeviceMgmtSummary.IMEI AS IMEI, dbo.UserConfig.CreationTime AS CreationTime,
    dbo.UserConfig.MailboxSMTPAddr AS emailaddress
    LEFT OUTER JOIN dbo.ServerConfig ON dbo.UserConfig.ServerConfigId = dbo.ServerConfig.Id
    LEFT OUTER JOIN dbo.ITPolicy2 ON dbo.UserConfig.ITPolicy2Id = dbo.ITPolicy2.Id
    LEFT OUTER JOIN dbo.UserStats ON dbo.UserConfig.Id = dbo.UserStats.Id
    LEFT OUTER JOIN dbo.HandheldConfig ON dbo.HandheldConfig.Id = dbo.UserConfig.HandheldConfigId
    LEFT OUTER JOIN dbo.SyncDeviceMgmtSummary ON dbo.SyncDeviceMgmtSummary.UserConfigId = dbo.UserConfig.Id

  2. Guy Lefebvre Says:

    Why would the pin # return a value of 2.0986E+29 when I export int Excel?

  3. ceasar Says:

    Because you need to expand the field to git the full value

  4. Anton Polac Says:


    There is additional way using Query Expres that allows BlackBerry users export to csv.

    Please see here

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: