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: Class
PIN: N/A
Carrier: Swisscom
Posts: 1,609
Post Thanks: 6
Thanked 122 Times in 119 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 223 01-30-2016 04:54 PM
Knowledge Sharing - Why Delivery Failure Report is rarely a BES issue noname BES Admin Corner 1 01-02-2010 12:18 AM
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 09:00 AM

UU1: Vintage Apple Powerbook Low Power AC Adapter ADP-17AB
$19.99
UU1: Vintage Apple Powerbook Low Power AC Adapter ADP-17AB pictureVintage Jaffrey Mfg. Co. Apple Grinder Fruit Press Cast Iron
$120.0
Vintage Jaffrey Mfg.  Co. Apple Grinder Fruit Press Cast Iron  pictureApple Macintosh IIcx M5850 - Vintage
$32.8
Apple Macintosh IIcx M5850 - Vintage pictureApple Vintage Collection 399
$109000.0
Apple Vintage Collection 399 pictureVINTAGE LOT APPLE McIntosh Delicious Cortland Rome CUT LETTERPRESS PRINTING
$9.99
VINTAGE LOT APPLE McIntosh Delicious Cortland Rome CUT LETTERPRESS PRINTING    picture






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