I was wondering the other day how we can look at the number of archived items in a vault store, by year. Knowing this sort of information will help with various things relating to migration.
For example it will help show how much ‘old’ data there is in the Vault Store that might have been added to Enterprise Vault by some archiac version.
I came up with this little bit of SQL which does the job nicely:
SELECT Year(iddatetime) as "Year", Count(itemsize) "No. Archived Items", Sum(itemsize) / 1024 "Total Size (MB)" FROM saveset group by Year(IdDateTime) order by YEAR(iddatetime) desc
And the output looks like this: