Email Notification Count

patbishop · ‎08-15-2017

I am looking for a way to pull a COUNT per email notification type. Essentially, I want to see which notifications are being sent the most and which notifications are rarely being triggered, if at all.

In the reporting interface, I cannot seem to find a way to drill down to group by notification name. The closest I can do is filter by "Target Table" and then manually scrub based on email 'subject'. I'm assuming that it could be done using a query, but I'm not sure where to start.

I would like to pull records for the past 7 days (since the logs would be huge any other way) and retrieve a count of the number of emails sent per notification type.

Any ideas?

Chuck Tomasi · ‎08-15-2017

Have you checked the table sys_email_log? There's a field called "notification" that points to the notification used to trigger. Seems like a fairly easy report to get an aggregate/count on that field.

View solution in original post

servicenowsnow · ‎08-07-2018

Hi All,

Could you please let me know if can we pull the report

list of email notifications that are sent from an incident as well when they are triggered
include:
- Addtional comments and Contact emails that in response to Addtional comments
- Ones that are generated from ITSM updates into ServiceNow