Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

How much data in EV that is X years old ?

Created: 07 May 2014 • Updated: 07 May 2014 | 2 comments

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,

Operating Systems:

Comments 2 CommentsJump to latest comment

TypoProne's picture

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's picture

Hi Typoprone,

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

Kind regards,

John Santana
IT Professional

--------------------------------------------------

Please be nice to me as I'm newbie in this forum.