03-29-2011 11:42 AM
We've been up and running with our EV 8 SP3 system for about 6 months now. We have just about all of our users onboard now, with their mail being archived. The basis we selected for calculating expiry dates is archive date.
Because we've taken several months to roll this out to all of our users, the various initial windows (ie. e-mails being archived after 6 months) are all staggered across departments.
To make it easy to communicate our users and to be able to give them updates, I'd like to reset all the archive dates for everything that has been archived so far to the same date so that I can notify them en masse in 4 months that they need to have a look at the "Documents due to expire within 60 days" report.
Is there some (easy and safe) SQL I could execute that would achieve this?
Thanks,
Keith
Solved! Go to Solution.
03-29-2011 11:49 AM
Yeah, I wouldn't do that. Instead leave it as is and just plan to turn on Expiry in 6 months. You can still send your note to users to run their Expiry report and users will see everything that would be deleted if you were to run Expiry. Then, in 6 months enable expiry and you will be good to go.
03-29-2011 11:49 AM
Yeah, I wouldn't do that. Instead leave it as is and just plan to turn on Expiry in 6 months. You can still send your note to users to run their Expiry report and users will see everything that would be deleted if you were to run Expiry. Then, in 6 months enable expiry and you will be good to go.
03-29-2011 12:27 PM
03-29-2011 01:47 PM
Thanks guys - I suspected that would be the case - just wanted to check my options.