[MLoy0815]

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

[freakinvibe]

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

"Clear statistics for selected users"

[MLoy0815]

that's it

thanks a lot

[MLoy0815]

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

[freakinvibe]

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.

[MLoy0815]

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")

[freakinvibe]

Are you talking about the SQL Server Management GUI?

[MLoy0815]

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

[freakinvibe]

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.

[MLoy0815]

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

[MLoy0815]

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?