Is there a way to create a report from the Email Log (sys_email_log) table?

[Laurie Marlowe1]

Hello,

I want to create a report based on the sys_email_log table.   I want to group by notification name, so I can get a count of how many times a particular notification is sent/used.   I am not able to pick the table from the list of tables in the report application.   I created an ACL against the table for "report_on" and role = "admin".   I am still not able to select the table.   I can view the table content in list view.

Any ideas?

Thanks,

Laurie

[mike_donathan · Accepted solution]

Laurie,

By default, system tables are excluded from being reported on. You'll need to update the system property glide.ui.permitted_tables and add sys_email_log to that property. Here's a link to the wiki about reporting on system tables:

Reporting on System Tables - ServiceNow Wiki

[geoffcox]

It would appear the system will not let you report on the "sys_email" table.

We are in the habit of attaching "notifications" as children of objects. So for example, we have a "Maintenance Event", and there are scheduled jobs that create "Maintenance Notifications", which are added to a related list on the Maintenance Event. The maintenance notification object has a fields with:

* the list of emails used for the notification

* the subject of the notification

* the body of the notification.

Then that table is easy to report on. Furthermore, if we want to use internal emails instead of having the email go across the internet from ServiceNow, we can pull down the notifications and send them from a server inside our network.

[Shannon Burns]

I know this is quite an old post, but if you are still active, I wanted to know how you wrote this to the related list.  This is exactly what my users have asked for - a way to see and report on all notifications that came from a particular record.

Thanks,
Shannnon