How to check if the email is not sent to users?

Rain Vaine
Kilo Sage

Hello experts,


We have a current scenario where there is some emails that is not sent due to the user being inactive. I just found that it is the oob behavior that servicenow will not send outbound emails to an inactive user. 

My next goal is to check on the emails that was not sent. I found that one method is that you could utilize the message in the email logs for emails not sent due to inactive user (Notification (unknown) excluded recipients because user's "Active" setting is disabled:) to search in the system logs, but it takes a lot of time and it is only for emails that was not sent due to the user being inactive. But is there a more efficient way to check on the emails that was not sent?

This is one method that I can think of to search for unsuccessful email sent but as you can see it seems to be not very efficient:

 

RainVaine_0-1704766158626.png



Regards,
Vaine

6 REPLIES 6

Maik Skoddow
Tera Patron
Tera Patron

Hi @Rain Vaine 

you can also go to table sys_email and lookup there records with the email address of interest at column "Recipients" and "Type" = "sent-failed" or "sent-ignored"

Maik

Actually this is one of the problem. What is there is multiple emails in one notification and then it successfully sent to one user but failed to others. like this one:
It was tagged as sent because it was sent to one active user but it was not sent to other user based on logs:

RainVaine_0-1704779404608.png

 

RainVaine_1-1704779438643.png

That is why one method that I can think of is to check on the system logs for that message.

Hi @Rain Vaine 

Am I right that you have multiple recipients for one email to send? If so, I recommend setting the system property "glide.email.smtp.max_recipients" to "1" due to data privacy reasons. Because with that setting, each recipient gets his own email and cannot see other recipients in the TO field. And with individual emails for each recipient you will get a better status as then the "Type" will reflect the issue correctly.

Maik

Hello Maik,
Yes the multiple email address were used for sending scheduled report email to the emails specified in the email address field of scheduled report email record. Thanks for that suggestion I would check up on that. Incase they would stick to the current settings, is there any way to check on emails not successfully or is my only choice really is on the system log?

 

Regards,

Vaine