On 2015-03-16 09:55, Janos SUTO wrote:
On 2015-03-13 17:12, James Macdonell wrote:
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).
ok, I see your point. I'll try to come up with a per user legal hold
feature. Until then you need a workaround to meet your requirements.
I have the following in my head, please comment.
Let's introduce a new table (legal_hold) filled with people's email
addresses you want to put under a legal hold. You have to make sure
though, that you type all email addresses for the given person,
including
the email aliases, if required.
Now the purge utility will figure out which messages to remove by the
following query:
SELECT ... FROM metadata WHERE `deleted`=0 AND `retained` < 'now'
AND id NOT IN (SELECT id FROM rcpt WHERE `to` IN (SELECT email FROM
legal_hold))
Note that the above query saves only received emails for people under
legal
hold. If you want to preserve their sent emails as well, then you have
to
check for the `from` column from the metadata table, though it's not
indexed yet.
Janos
