On 03/13/2015 06:38 AM, Janos SUTO wrote:
So whenever you have to maintain a litigation hold, simply disable purging on the health page, and piler won't remove even aged messages. When the hold is over, then enable it again, that's all.
I really need to find a method more granular than turning purge on/off. We have thousands of employees and somebody is always on legal hold. I need to maintain the default retention for the 99% not on legal hold to meet data retention standards (and to keep future ediscovery cases manageable).
I'm considering Konstantin's method (thank you for that!). I'm also thinking of leaving the metadata table as-is, but maintaining another table that allows exceptions to the standard retention. Something like:
SELECT ... from metadata as m WHERE ... retained < NOW()
AND m.from NOT IN (SELECT value FROM legal_hold WHERE key = 'from')
AND m.to NOT IN (SELECT value FROM legal_hold WHERE key = 'to')
--
James Macdonell
Information Security & Emerging Technologies
California State University, San Bernardino
5500 University Parkway
San Bernardino, CA 92407-2393
Main Line: 909/537-7262
http://its.csusb.edu/
PGP: 0xBE849E4B
smime.p7s
Description: S/MIME Cryptographic Signature
