How to determine which email notifications are most sent

neildronet
Tera Contributor

In an effort to reduce the amount of emails notifications that ServiceNow sends, we are trying to determine which email notifications are most sent. I couldn't find a way in the Outbound Sent folder to group by the specific notification. Any suggestions on how to obtain this information would be app

1 ACCEPTED SOLUTION

Tony Chatfield1
Kilo Patron

Hi, you can see message details in the email log 'syslog_email'

/syslog_email_list.do?sysparm_query=messageSTARTSWITHNotification&sysparm_view=sent

but there would be some work in parsing to get valid data (perhaps export and tweak in excel or an sql platform).


You could look at creating a metric definition to generate records you can report on, then run a background script against the email log to populate retrospective data from the email_log (As a 1 off script I don't see any issues with this but ideally run outside of core business hours).

View solution in original post

1 REPLY 1

Tony Chatfield1
Kilo Patron

Hi, you can see message details in the email log 'syslog_email'

/syslog_email_list.do?sysparm_query=messageSTARTSWITHNotification&sysparm_view=sent

but there would be some work in parsing to get valid data (perhaps export and tweak in excel or an sql platform).


You could look at creating a metric definition to generate records you can report on, then run a background script against the email log to populate retrospective data from the email_log (As a 1 off script I don't see any issues with this but ideally run outside of core business hours).