cancel
Showing results for 
Search instead for 
Did you mean: 

Expiry query for last 365 days for a single vault store

idaman22
Level 4

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.

1 ACCEPTED SOLUTION

Accepted Solutions

RahulG
Level 6
Employee

you will find the solution in the following forum post

http://www.symantec.com//connect/forums/sql-query-search-expired-savesets

 

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

,http://www.symantec.com/docs/TECH154632

View solution in original post

2 REPLIES 2

RahulG
Level 6
Employee

you will find the solution in the following forum post

http://www.symantec.com//connect/forums/sql-query-search-expired-savesets

 

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

,http://www.symantec.com/docs/TECH154632

idaman22
Level 4

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