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
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.
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




You can use this query
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
It allows to export much more info on Blackberry users
I was looking for other user details to export from BlackBerry server.
select
a.DisplayName,
c.ModelName,
c.PhoneNumber,
c.PIN,
c.HomeNetwork,
convert(varchar(10),a.CreationTime, 101)CreationDate,
convert(varchar(10),a.ActivationTime, 101)ActivationDate,
b.MsgsForwarded,
b.MsgsSent,
convert(varchar(10),b.LastFwdTime, 101)LastFwdDate,
convert(varchar(10),b.LastSentTime, 101)LastSentDate
from userconfig a, userstats b, vHandheldSummaryInfo c
where a.id = b.userconfigid and a.displayname = c.displayname
order by a.displayname