User's email address on user record does not reflect on their primary email record

[Sofija]

Hi All,

We have an issue where users are not receiving emails from ServiceNow because their email (on sys_user table) has been updated but this update has not been reflected under their primary email address (which is used for sending email notifications). Therefore, emails are being sent to the old email address The issue occurs when user email gets updated on user record but it does not get reflected on their primary email. We are not not sure how many users are not receiving their emails because their primary email and the one on their user record do not match.

1) Did anyone encounted this type of problem previously and have any suggestions on how to resolve it? We also logged HI ticket for this.

2) Does anyone know where the primary email lives (on which table)? We want to run reports that would show all users whose primary email is different from the one on their user record (we tried to create one but we cannot locate the table on which the primary email information lives).

Any thoughts and suggestions are appreciated!

Kind Regards,

Kamile

[Sofija]

It runs when the email is updated manually but we laod users through a transform map, which is when it fails.

[sumeet_n · Accepted solution]

On your transform map, is below check box ticked?

[Sofija]

It didn't have originally but I tried already to check it, save it and re-run the transform map - unfortunatelly the primary emails still did not update...

[antonymirza]

I hope, fetching data from table "cmn_notif_device" will help you generating this report.

Let me know if it answers your purpose?

Brgds, AM

[Sofija]

Antony, I already found this myself and noted right after my initial post Now Q1 is outstanding..