How to change sender for Legal Hold reminders

SYMPTOMS

If the contact used as the sender of Legal Hold reminders needs to be changed, it must be done in the database as there is no way to accomplish this in the user interface.

CAUSE

Not applicable

RESOLUTION

Here are the steps to change the Contact referenced as the sender of Legal Hold reminders:

Run the following query using the relative email address to find Contact ID's (Id) for current and intended senders: 

SELECT Id, Name 
FROM [ZyLABLegalHold].[dbo].[Contact] 
WHERE email='[email address]' /** where [email address] is the actual email address **/

Use the IDs from step 1 in the following SQL statement to change the sender of reminders: 

UPDATE [ZyLABLegalHold].[dbo].[MessageToSend] 
SET SentFromId = ## /** where ## is Id for intended sender **/ 
WHERE SentFromId = ## /** where ## is Id for current sender **/ 

Restart LegalReviewStandalone service

APPLIES TO

3.8; 3.9