07-22-2014 08:17 PM
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?
Solved! Go to Solution.
07-22-2014 08:53 PM
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
07-22-2014 08:53 PM
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