Issue
We have configured notifications in Exchange Pro to be sent to users when their mailboxes are to be migrated. We have enabled the notifications and been able to send a test email. But when we did the first round of test mailbox migrations no email was received by the User or the Admin account used to monitor the migrations that was added to the notifications.
Solution
When setting up notifications the main issue is always around selecting a notification template that matches the proper CultureID in a client environment. If they have multiple CultureID then you need to create templates for each respectively. Please proceed to open SQL and click on New Query and point it to Exchange Pro database then execute the following:
Select Distinct (CultureID) from CMTEUP_UserMailbox
This query will display all the CultureID present in client's environment in a LCID Dec format. I have attached CultureID code list and you can look up the LICID Dec table and find the language it translates into. Then make sure you create the very same template in notifications. For example, we have English and then we have English United States so make sure you select the appropriate one.
Another way you can investigate this is by querying user mailbox CultureID and confirm if you have a template matching that CultureID.
1. Open SQL Management Studio
2. Right click on the database and select New Query
3. Now execute the following query:
Select p.FirstName,p.LastName,um.CultureID,j.SentSuccessful,j.SentDate,j.MessageBody from CMTEUP_Person P
Inner Join CMTEUP_UserMailbox um on um.PersonID = p.PersonID
inner join CMTEUP_JobNotifications j on um.UserMailboxID = j.UserMailboxID
Where p.FirstName = 'UserFirstName' and p.LastName = 'UserLastName'
Lastly, if you have a massive list of CultureID in your environment and would like to only enforce a single CultureID across like English, then you can utilize the following SQL trigger to achieve this task:
1. Open SQL Management Studio
2. Right click on the database and select New Query
3. Before executing the below SQL trigger, you have to change NULL to CultureID you want to enforce.
CREATE TRIGGER [dbo].[ChangeCultureID]
ON [dbo].[CMTEUP_UserMailbox]
AFTER INSERT, UPDATE
AS
BEGIN
SET NOCOUNT ON;
UPDATE UM SET UM.CultureID = NULL FROM CMTEUP_UserMailbox AS UM
JOIN inserted AS I ON I.UserMailboxID = UM.UserMailboxID
END
GO
CultureID2.xlsx
