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

Western Construction News Magazine Dec. 1939 Vintage Caterpillar Letourneau Ads
$14.99
Western Construction News Magazine Dec. 1939 Vintage Caterpillar Letourneau Ads  pictureVintage Sheet Metal Worker’s Monthly magazine Dec.1940
$8.5
Vintage Sheet Metal Worker’s  Monthly magazine Dec.1940  pictureVintage PELOUZE Petite POSTAL SCALE Model P-1 Rates Effective Dec 31, 1976 NEAT
$11.11
Vintage PELOUZE Petite POSTAL SCALE Model P-1 Rates Effective Dec 31, 1976 NEAT pictureVintage Graton & Knight Co. Lineman's Belt Dec 1953 Belt Climbing Harness Strap
$33.99
Vintage Graton & Knight Co. Lineman's Belt Dec 1953 Belt Climbing Harness Strap pictureVintage Rare DEC 1073D / 1996 JD3487 H 9833
$49.99
Vintage Rare DEC 1073D  / 1996 JD3487 H 9833    picture






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