BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 05-22-2005, 11:58 AM   #1 (permalink)
CrackBerry Addict
 
amukhey's Avatar
 
Join Date: Sep 2004
Location: Los Angeles
Model: 9700
Carrier: T-Mobile
Posts: 750
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default BES Usage Statistics

Please Login to Remove!

Besides the export of information from bes 4.0 Server Manager (Domino Environment), Any third party company that is available to provide bes usage statistics for every user (how much mail has been sent, received, queued, etc) without having to go through each State DB for a user?
Offline  
Old 05-22-2005, 03:51 PM   #2 (permalink)
CrackBerry Addict
 
rsun's Avatar
 
Join Date: Oct 2004
Location: Delaware, USA
Model: 8320
Carrier: at&t/T-Mobile/Verizon
Posts: 747
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Since we are BES4 running on top of SQL, we just ODBC into the BESMgmt database and use crystal reports to do our statistics watching.
__________________
Richard Sun
[email address]
Offline  
Old 05-22-2005, 09:11 PM   #3 (permalink)
CrackBerry Addict
 
amukhey's Avatar
 
Join Date: Sep 2004
Location: Los Angeles
Model: 9700
Carrier: T-Mobile
Posts: 750
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Rsun, sounds like a good idea, can you provide me more information on how do you do this please. Producing crystal reports, does it do graphs? I am curious on what statistics it can produce?

Please advise. My email address is [email address] and my contact number is 212 474 3399-at your convinience.

Thank you.
Offline  
Old 05-23-2005, 08:18 AM   #4 (permalink)
BBF Veteran User
 
Join Date: Aug 2004
Location: Hotwiring another Cessna
Model: OU812
Carrier: Nintendo
Posts: 3,492
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

You could also try playing with the resource kit. It's not to hard to run those commands and generate html/CD files based on the output.
Offline  
Old 05-23-2005, 11:42 AM   #5 (permalink)
CrackBerry Addict
 
rsun's Avatar
 
Join Date: Oct 2004
Location: Delaware, USA
Model: 8320
Carrier: at&t/T-Mobile/Verizon
Posts: 747
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

All we did was create an ODBC connection, and point Crystal Reports to it, all home grown stuff, nothing special.
__________________
Richard Sun
[email address]
Offline  
Old 05-25-2005, 09:56 AM   #6 (permalink)
CrackBerry Addict
 
amukhey's Avatar
 
Join Date: Sep 2004
Location: Los Angeles
Model: 9700
Carrier: T-Mobile
Posts: 750
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Rsun, I tried this method but there are so many views. Can you point me in the right direction as to what would be the best to pull for mail statistics with user's?
Offline  
Old 05-25-2005, 11:21 AM   #7 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

looks like im going to try the crystal reports thing

thanks rsun.
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.
Offline  
Old 05-26-2005, 07:29 PM   #8 (permalink)
CrackBerry Addict
 
amukhey's Avatar
 
Join Date: Sep 2004
Location: Los Angeles
Model: 9700
Carrier: T-Mobile
Posts: 750
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

RSUN, I tried what you had recommended and it works great. Crystal Reports with Graphs, etc. Read the help File and DO NOT use the wizard, makes it all the more easier to do this

Also, if dont know which table to pull, open the properties of Server Stats, User Config, and User Stats and see the information it has in it. This came handy when pulling all the information to Crystal.... Just trying to make sure we are all on the same goal
Offline  
Old 05-26-2005, 08:34 PM   #9 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

Now how to automate the stats to a webpage. I really dislike Crystal Reports.
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.
Offline  
Old 08-24-2005, 09:52 AM   #10 (permalink)
Knows Where the Search Button Is
 
Join Date: Jul 2005
Model: 8830
Carrier: Verizon
Posts: 35
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Help please.....

I can't seem to figure out how to create the odbc connection to the bes database. I'm trying to use crystal reports 9 and I'm completely unfamiliar with it. Any help with this would be greatly appreciated. We are using msde and not sql server. Could this be the problem?
Offline  
Old 08-24-2005, 11:43 AM   #11 (permalink)
Knows Where the Search Button Is
 
Join Date: Jul 2005
Model: 8830
Carrier: Verizon
Posts: 35
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Nevermind.....

Persistence often times does pay off. Added SQL as a datasource from windows administrative tools and I can now add the bes database in crystal.
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





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