Reporting

[Andrew_Tankersl]

Within EV, is there an easy way to find out how many messages have been captured in the system  for a given time frame (i.e. three months)?

[TonySterling · Accepted solution]

I have used this sql query for a daily rate count.

-- This one gives a daily rate:
--Runs against the VaultStore Database
select "Archived Date" = left (convert (varchar, archiveddate,20),10), "Daily Rate" = count (*), "Av Size" = sum (itemsize)/count (*)
from saveset
where archiveddate between '2006-05-01' and '2008-05-31'
group by left (convert (varchar, archiveddate,20),10)
order by "Archived Date" desc

I also created this one for Monthly rate:

-- This one gives a Monthly rate:
--Runs against the VaultStore Database
select "Archived Date" = left (convert (varchar, archiveddate,20),7), "Monthly Rate" = count (*), "Av Size" = sum (itemsize)/count (*)
from saveset
where archiveddate between '2007-05-01' and '2008-05-31'
group by left (convert (varchar, archiveddate,20),7)
order by "Archived Date" desc

Just change the dates.

Hope that helps,

Tony

Message Edited by Tony Sterling on 04-02-2008 09:58 AM

[Andrew_Tankersl]

Ah! That did it.
You've come through for me again - Thanks Tony