Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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.