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.

Comments [4]

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

    SELECT
    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
    FROM
    dbo.UserConfig
    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. Why would the pin # return a value of 2.0986E+29 when I export int Excel?

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

  4. Hi,

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

    Please see here

    kreslavsky.com/2009/08/how-to-export-csv-list-of-blackberry-users-from-bes-server.html

Leave a Reply

Your email address will not be published. Required fields are marked *