Volume Reporting

[Andrew_Tankersl]

Is there any way possible to get a report on the volume\count of messages that get moved into the vault on a daily basis.
I know you can get the count on how much is in a vault, but I'd like to get something more granular

[TonySterling · Accepted solution]

This query will give you the number of items per hour for the past 24 hours. You can just increase the number of hours or even switch up the where clause to use between.

select "Archived Date" = left (convert (varchar, archiveddate,20),14),
"Hourly Rate" = count (*),
"Av Size" = sum (itemsize)/count (*)
from saveset
where archiveddate > dateadd("hh", -24, getdate ())
group by
left (convert (varchar, archiveddate,20),14)
order by
"Archived Date"
desc

This one gives a daily rate:

select "Archived Date" = left (convert (varchar, archiveddate,20),10),
"Daily Rate" = count (*),
"Av Size" = sum (itemsize)/count (*)
from saveset
where archiveddate > dateadd("hh", -72, getdate ())
group by
left (convert (varchar, archiveddate,20),10)
order by
"Archived Date"
desc

[Andrew_Tankersl]

Great - Thanks Tony
I don't know why I haven't noticed you on the board before, good to see you here.
You've helped us out a lot in the past - thanks again

[Jason_Szeto]

Tony used to be A WS. Since he no longer works for Symantec, he's no longer incognito. He is available for consulting gigs through his new company though. =P