Item by Age in EV SQL query

[Donnal_Spence]

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?

[TonySterling · Accepted solution]

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