Email Notification Count

[patbishop]

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 · Accepted solution]

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.

[patbishop]

This is very close to what I was looking for!   I was using sys_email.list instead!  

Thank You!

[Chuck Tomasi]

FWIW, It was in the sys_email list that I noticed the embedded list that had the actual notification, so I went to that table.

[caruofor]

Hey Chuck, 

Would I be wrong in thinking that the sys_email_log table is not available for reporting against?

Kind regards, 

Chris