cancel
Showing results for 
Search instead for 
Did you mean: 

Report Building for Enterprise Vault on the lines of Storage Trends

The_Dark_Knight
Level 4

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.

 

1 REPLY 1

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

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