Video Screencast Help

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