01-11-2016 09:55 PM
Hi,
Working with Enterprise Vault 10.0.4 in a clustered environment.
Looking at building a report where in I can get a trend on the Storage used by the archives in the Vault Stores.
Found something similar at least by the naming convention in the Data Analysis Report section but since we are not using File System Archiving, cannot use that report.
01-12-2016 10:34 AM
you might be able get the data from your storage device instead of EV but if you wanted to go with what EV has, try these scripts. you can play with the archiveddate parameters to find narrow or broaden the trend timeline.
--Monthly Size in MB
select "Archived Date" = left (convert (varchar, archiveddate,20),7),"Monthly Rate" = count (*),"Size" = sum (itemsize)/1024
from saveset
where archiveddate > dateadd("mm", -12, getdate ())
group by left(convert (varchar, archiveddate,20),7)
order by "Archived Date" Desc
--Yearly Size in MB
select "Archived Date" = left (convert (varchar, archiveddate,20),4),"Yearly Rate" = count (*),"Size" = sum (itemsize)/1024
from saveset
where archiveddate > dateadd("YY", -3, getdate ())
group by left(convert (varchar, archiveddate,20),4)
order by "Archived Date" Desc