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.

Item by Age in EV SQL query

Created: 22 Jul 2014 • Updated: 24 Jul 2014 | 1 comment
This issue has been solved. See solution.

I need a query that will tell me how old items are per year in EV archive. Example:

1 Year old = 10000000

2 Year old = 500000

3 Year old = 250000

and so on.... 

Any ideas?

Operating Systems:

Comments 1 CommentJump to latest comment

TonySterling's picture

This should do it, runs against the vault stores

--Yearly Rate
select “Item Date" = left (convert (varchar, IdDateTime,20),4),"Yearly Rate" = count (*),"Size" = sum (Convert(bigint,itemsize))/1024
from saveset
where IdDateTime > dateadd("YY", -10, getdate ())
group by left(convert (varchar, IdDateTime,20),4)
order by “Item Date" Desc