BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 05-31-2011, 03:11 PM   #1 (permalink)
New Member
 
Join Date: Aug 2009
Model: 8600
PIN: N/A
Carrier: AT&T
Posts: 1
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default How to report on user accounts across multiple BES servers in multiple Domains?

Please Login to Remove!

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.

Last edited by y2kc0wb0y : 05-31-2011 at 03:15 PM.
Offline  
Old 06-02-2011, 02:53 AM   #2 (permalink)
BlackBerry Extraordinaire
 
Join Date: Aug 2008
Location: Basel
Model: 9780
PIN: N/A
Carrier: Swisscom
Posts: 1,579
Post Thanks: 5
Thanked 119 Times in 116 Posts
Default 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
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads for: How to report on user accounts across multiple BES servers in multiple Domains?
Thread Thread Starter Forum Replies Last Post
BES Licensing Thread BBAdmin BES Admin Corner 220 06-17-2013 09:09 AM
Knowledge Sharing - Why Delivery Failure Report is rarely a BES issue noname BES Admin Corner 1 01-01-2010 11:18 PM
Another Activating Initializing on BB Professional patrickd26 BES Admin Corner 4 05-06-2008 05:12 AM
Multiple BES Accounts, One BB akg BES Admin Corner 3 07-21-2007 10:42 AM
BES 3.6 Console sluggish with multiple WAN BES servers Calum BES Admin Corner 1 03-17-2005 08:00 AM





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.