EV archive question

[GTK]

Hi

what is the quickest way to tell how much data was archived per EV server over night? is it via SQL? if so can someone provide the SQL query?

Thanks

Greg

[LCT]

You can install EV Reporting and it will tell you what you need. please refer to the Install and Admin Guide for install and configuring EV reporting.

[RahulG]

You can get a report for the same in Ev .http://www.symantec.com/business/support/index?page=content&id=HOWTO28055

[AKL · Accepted solution]

select "Archived Date" = left (convert (varchar, archiveddate,20),14),

"Hourly Rate" = count (*),

"MB (original)" = sum (originalsize)/1024/1024,

"MB (compressed)" = sum (itemsize)/1024

from saveset,savesetproperty

where saveset.savesetidentity = savesetproperty.savesetidentity

and archiveddate > dateadd("hh", -24, getdate ())

group by

left (convert (varchar, archiveddate,20),14)

order by

"Archived Date"

desc

[GTK]

thanks guys for all your help, i have got it sorted now