cancel
Showing results for 
Search instead for 
Did you mean: 

Various Expiry questions (EV904)

NaturesRevenge
Level 5

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 ACCEPTED SOLUTION

Accepted Solutions

Rob_Wilcox1
Level 6
Partner

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?

Working for cloudficient.com

View solution in original post

4 REPLIES 4

AndrewB
Moderator
Moderator
Partner    VIP    Accredited

have a look at this post https://www-secure.symantec.com/connect/forums/sql-query-search-expired-savesets

the last post has a great query and explanation

Rob_Wilcox1
Level 6
Partner

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?

Working for cloudficient.com

JesusWept3
Level 6
Partner Accredited Certified
Well you can target specific users by tweaking the expiry enabled for each particular user
https://www.linkedin.com/in/alex-allen-turl-07370146

Rob_Wilcox1
Level 6
Partner

Yeah true.. but a bit cumbersome, unless you update the required fields in SQL.

Working for cloudficient.com