Video Screencast Help

Expiry query for last 365 days for a single vault store

Created: 02 Nov 2012 • Updated: 02 Nov 2012 | 2 comments
This issue has been solved. See solution.

We have a vault store where we expect a large number of items to expire over the next 2 months as they have a 1 year retention and were archived last year around this time. i have been using the query from TECH62271 and adjusted it to 60 days from the default 3 and changed the minus to a plus in the technote as follows, looking for what gets expired in the next 60 days, but the numbers don't seem right as it looks like too much will get expired:

USE EVVSESDVaultStore_31
SELECT ArchiveName, ArchivePointID, sum(ItemSize) as TotalBytes, count (*) as 'Num Items Eligible' FROM Saveset
INNER JOIN ArchivePoint
On saveset.ArchivePointIdentity = ArchivePoint.ArchivePointIdentity
INNER JOIN [WAXDBOLYSQL01\SQL_EV01].EnterpriseVaultDirectory.dbo.Root r on r.VaultEntryID = ArchivePointID
INNER JOIN [WAXDBOLYSQL01\SQL_EV01].EnterpriseVaultDirectory.dbo.Archive a on a.RootIdentity = r.RootIdentity
WHERE ArchivedDate <= (getdate() + 60)
GROUP BY ArchiveName, ArchivePointID

Any input on how to refine the query is appreciated.

Comments 2 CommentsJump to latest comment

RahulG's picture

you will find the solution in the following forum post

running storage expiry in report mode may also provide you with some info


idaman22's picture

Thanks RahulG, much appreciated! I had seen this before but could not search it up again.