email table - getting the name of the notification or event

[e_wilber]

On the email table there is an embedded list named

Originating Event and Notification

This list shows the notification name and event that was triggered (if any). I need access to these values and I'm not sure how to pull them back in a business rule. How would I access the event and notification that was sent out?

[She Sull]

What's the exact name of the table you are looking at? I'm not seeing the embedded list. Also, what release of ServiceNow are you on? In any case, you should be able to dot.walk to those values in a business rule or run a glide record query to get those values.

[Mike Allen]

Have you looked at the sys_email_log table?   It maps event to notification and email.

[Mike Allen]

Also, if you ever question where data in lists comes from, all you need to do is look at the dictionary of the list:

[She Sull]

With Mike's help, what you 'll need to do is query the sys_email_log table within the BR for the record with the matching email.