BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 05-10-2011, 08:34 AM   #1 (permalink)
Knows Where the Search Button Is
 
Join Date: Dec 2010
Model: 9700
PIN: N/A
Carrier: Vodafone
Posts: 18
Post Thanks: 1
Thanked 0 Times in 0 Posts
Default Reset BES statistics

Please Login to Remove!

Hi,

is it possible to reset the BES statistics by BAS or by a script?
I'm talking about to reset the complete messaging data for all servers in the whole BlackBerry domain.
Is there a way to do this?


thx
Marcus
Offline  
Old 05-13-2011, 04:22 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: Reset BES statistics

If you select "Manage multiple users", then select all users and click

"Clear statistics for selected users"
Offline  
Old 05-16-2011, 02:35 AM   #3 (permalink)
Knows Where the Search Button Is
 
Join Date: Dec 2010
Model: 9700
PIN: N/A
Carrier: Vodafone
Posts: 18
Post Thanks: 1
Thanked 0 Times in 0 Posts
Default Re: Reset BES statistics

that's it

thanks a lot
Offline  
Old 05-16-2011, 02:57 AM   #4 (permalink)
Knows Where the Search Button Is
 
Join Date: Dec 2010
Model: 9700
PIN: N/A
Carrier: Vodafone
Posts: 18
Post Thanks: 1
Thanked 0 Times in 0 Posts
Default Re: Reset BES statistics

Does somebody have another idea?
I've to clean statistics for about 3000 users over 6 BES. So i've to do a few clicks to clean.
So cleaning with a single click would be fine

Last edited by MLoy0815 : 05-16-2011 at 03:19 AM.
Offline  
Old 05-16-2011, 03:34 AM   #5 (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: Reset BES statistics

Do you have SP3 installed, there you can set the Fetch size to 1000 which would reduce the number of clicks a bit. Apart from that, you would probably have to write some SQL statement to manipulate the DB directly.
Offline  
The Following User Says Thank You to freakinvibe For This Useful Post:
MLoy0815 (05-16-2011)
Old 05-16-2011, 03:42 AM   #6 (permalink)
Knows Where the Search Button Is
 
Join Date: Dec 2010
Model: 9700
PIN: N/A
Carrier: Vodafone
Posts: 18
Post Thanks: 1
Thanked 0 Times in 0 Posts
Default Re: Reset BES statistics

No SP3 now, because our carrier hasn't released it for us, now.
I know, it's rediculous, i can't change it.

BTW is there a similar way clear the BES stats with the GUI? (Table "Serverstats")

Last edited by MLoy0815 : 05-16-2011 at 04:13 AM.
Offline  
Old 05-17-2011, 03:31 AM   #7 (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: Reset BES statistics

Are you talking about the SQL Server Management GUI?
Offline  
Old 05-17-2011, 03:34 AM   #8 (permalink)
Knows Where the Search Button Is
 
Join Date: Dec 2010
Model: 9700
PIN: N/A
Carrier: Vodafone
Posts: 18
Post Thanks: 1
Thanked 0 Times in 0 Posts
Default Re: Reset BES statistics

No, sorry for this, I'm talking about the BAS GUI.
With SQL I would do an UPDATE on this table, but I would prefer the "official" way
Offline  
Old 05-17-2011, 03:44 AM   #9 (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: Reset BES statistics

Just found something. If you go to "Manage multiple users", below the list there is an option called

"Select all results on all pages"

If you use that, you can reset the stats all in one go.
Offline  
Old 05-17-2011, 03:47 AM   #10 (permalink)
Knows Where the Search Button Is
 
Join Date: Dec 2010
Model: 9700
PIN: N/A
Carrier: Vodafone
Posts: 18
Post Thanks: 1
Thanked 0 Times in 0 Posts
Default Re: Reset BES statistics

yes, i found that in the morning too....and it works
thanks for this

now i just need to find a way to clear the BES stats (contained in Table ServerStats) by BAS GUI

Last edited by MLoy0815 : 05-17-2011 at 05:23 AM.
Offline  
Old 06-07-2011, 05:43 AM   #11 (permalink)
Knows Where the Search Button Is
 
Join Date: Dec 2010
Model: 9700
PIN: N/A
Carrier: Vodafone
Posts: 18
Post Thanks: 1
Thanked 0 Times in 0 Posts
Default Re: Reset BES statistics

is it a problem to clear the ServerStats table with

DELETE from dbo.ServerStats

or should i UPDATE every entry with something like

UPDATE dbo.ServerStats set MsgsForwarded=0,MsgsSent=0,MsgsPending=0,MsgsExpir ed=0,MsgsFiltered=0,MsgsFailed=0

Or is there generally a problem with modifiing the content of this table

What's your opinion?

Last edited by MLoy0815 : 06-07-2011 at 05:58 AM.
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: Reset BES statistics
Thread Thread Starter Forum Replies Last Post
BES 4.1 Upgrade to 5.0.2 with SQL Mirroring (parallel with Ex2003 to Ex2010 upgrade) Jay247 BES Admin Corner 4 11-21-2010 09:05 AM
Upgrading BES 4.1 to 5 merlin BES Admin Corner 2 11-20-2009 01:53 PM
BENCHMARK your BlackBerry speed! Add your results here! Mark Rejhon General BlackBerry Discussion 271 03-12-2007 09:51 PM
Reset 7100g from BES to BWC/Redirector xALBYx RIM Software 3 07-05-2005 04:02 PM





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