How much data in EV that is X years old ?

[John_Santana]

Hi people,

Can anyone assist me with the SQL query in regards to how much in GB of Files and Emails that has is in archive older than  X amount of years ?

I've tried this SQL Script for the past 3 years old but the result is too mixed up between Emails and Files since it is in the same EVVaultStore.

SELECT A.archivename, 
       Count(S.itemsize)      "No. Archived Items", 
       Sum(S.itemsize) / 1024 "Total Size (MB)" 
FROM   evvaultstore1.dbo.saveset S, 
       evvaultstore1.dbo.archivepoint AP, 
       enterprisevaultdirectory.dbo.root R, 
       enterprisevaultdirectory.dbo.archive A 
WHERE  S.archivepointidentity = AP.archivepointidentity 
       AND AP.archivepointid = R.vaultentryid 
       AND R.rootidentity = A.rootidentity 
       AND S.iddatetime < Dateadd(year, -3, Getdate()) 
GROUP  BY A.archivename 
ORDER  BY A.archivename 

Thanks,

[Prone2Typos]

Hi there.

If you are talking about a single archive you can add an and clause for the archive id since they are in the same VS. you should be able to use the Root table join you have there to do it .

I think you should also look into the EV reporting... as it may make your life a little easier in the long run.

Hope this helps.

[John_Santana]

Hi Typoprone,

I cannot see the disk size that is used by the archived items in my EV Vault operations Manager web page ?