Various Expiry questions (EV904)
We've had EV904 in place for more than two years and we're about to run expiry for the first time. The service is enabled (for user expiry reports) but will run it for the first time. A couple of questions:
I've read in this forum that there's no way for a user to view their expiry report, other than within the Oulook EV add-in. The problem with this is that it will only show a maximum of 500 items, and - at least with my Vault - those are ALL calendar items. And, I have 5,249 items that qualify for deletion and I'd love to spot-check these prior to Wednesday night.
Are there SQL queries - either canned or engineer designed - that can produce a complete expiry report for a specific Vault?
Can I run expiry, targeting only specific Vaults? Or is it a global run and only a global run?
I appreciate your insight and comments.
1/ The trouble is that the query needs to be a combination of SQL and indexing, I think. It's possible to get a count of the items via SQL... but then the list, from SQL, would be a bunch of Saveset ID's. That's not particularly user friendly.
Counts etc:
https://www-secure.symantec.com/connect/forums/sql-query-search-expired-savesets
I think there is a tweak to show more than items due to expire in the next 60 days.. but not sure about increasing the overall number of results returned.
Is there a reason you want to see more?
2/ Storage Expiry is a site wide setting, so it's the whole site.. or nothing. You do have report-mode though, which you might want to run first of all?
