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,614
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

Mega Kitchen System BL770 mix fruit for smoothies 64-z processor bowl with blade
$154.95
Mega Kitchen System BL770 mix fruit for smoothies 64-z processor bowl with blade pictureDevelopment Board EA-OEM-101 for ARM7 embedded processor NXP LPC2468
$69.0
Development Board EA-OEM-101 for ARM7 embedded processor NXP LPC2468 pictureAllen Bradley Training Unit 1747-DEMO-7 no CPU
$575.0
Allen Bradley Training Unit 1747-DEMO-7 no CPU pictureMSC CXB-CD945-CPU1500-164000 L7400-164000 COM Express CPU Intel Core Duo L7400
$139.0
MSC CXB-CD945-CPU1500-164000 L7400-164000 COM Express CPU Intel Core Duo L7400 pictureALPHASMART 3000 Personal Portable Battery Powered Word Processor w/Batteries WOW
$23.99
ALPHASMART 3000 Personal Portable Battery Powered Word Processor w/Batteries WOW picture






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