BlackBerry Forums Support Community

BlackBerry Forums Support Community (http://www.blackberryforums.com/)
-   BES Admin Corner (http://www.blackberryforums.com/bes-admin-corner/)
-   -   How to report on user accounts across multiple BES servers in multiple Domains? (http://www.blackberryforums.com/bes-admin-corner/249539-how-report-user-accounts-across-multiple-bes-servers-multiple-domains.html)

y2kc0wb0y 05-31-2011 03:11 PM

How to report on user accounts across multiple BES servers in multiple Domains?
 
BES 5.0.2
Exchange 2007/2003

I need a way to quickly build a report regarding the number of BES accounts on each BES server without having to log into the BAS on each server and manually extract that information. This very time consuming when we're talking 50+ BES on 6 Domains.

I'm assuming the way to go is to get some SQL queries going against the backend databases but I've been unsuccessful looking up that information. Any help would be greatly appreciated for managing from an Enterprise View.

freakinvibe 06-02-2011 02:53 AM

Re: How to report on user accounts across multiple BES servers in multiple Domains?
 
You have to go to each BES database and use the following query:

Code:

SELECT    COUNT(UserConfigId) AS NumberOfUsers
FROM      BASUsers



All times are GMT -5. The time now is 12:13 AM.

Powered by vBulletin® Version 3.6.12
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.