Thursday 6 June 2013

How to extract the blackberry user details

Login to the SQL Server wherein the Blackberry Configuration database (BESMgmt) of Blackberry Enterprise Server resides.
 
Login to SQL Server Management Studio.
 
Right Click on ‘BESMgmt’ database and select ‘New Query’
  
Copy the below query in the SQL Management Studio.
 
================================
select Displayname, MailboxSMTPAddr, CreationTime, ActivationTime from userconfig
================================
 
Execute the query (Press F5 or click on execute) to find out the Blackberry User details for all the Blackberry Users.
 
Copy the results of SQL query and paste it in Excel document.

No comments:

Post a Comment