How to export CSV list of BlackBerry Users from BES server

Posted on August 19th, 2009 in BES Server, Black Berry by Gil Kreslavsky

In order to export Black Berry users you will need 3d party software.
I use Query Expres

So download Query Expres

Run it.
Select BES server Name and Authentication method

image 

On the left pane under database select BESMgmt
On the right past the following query
——
select
DisplayName,
PIN,
PhoneNumber,
IMEI,
ModelName
FROM vUserConfigStats
—-

And press Run button.

image

That will query BES server SQL for list of users . IMEI, BB Model and Phone Number

Press on file>save query results to save exported user list to CSV.

Now you can easily view the list in excel