question Re: count all email notifications sent from ServiceNow (sys_email, type = send) in ITSM forum

count all email notifications sent from ServiceNow (sys_email, type = send)

ElMehdiELO — Fri, 01 Aug 2025 08:36:13 GMT

Hello,

I need to count all email notifications sent from ServiceNow (sys_email, type = send) grouped by quarter between 2024-07-01 and 2025-06-30. The table is not reportable, and background scripts return 0 even when emails exist. What’s the best method to extract totals from sys_email at scale (8M+ records)?

Thank you

Re: count all email notifications sent from ServiceNow (sys_email, type = send)

Dr Atul G- LNG — Fri, 01 Aug 2025 08:41:04 GMT

Hi @ElMehdiELO

There are a few tables that are not reportable by default. You need to add those tables in the system property appropriately, and then you’ll be able to create reports on them.

Also, in the Yokohama release, an Email Dashboard has been introduced by ServiceNow that you can use.

https://www.servicenow.com/docs/bundle/yokohama-platform-administration/page/administer/notification/concept/email-notifications-dashboard.html

Re: count all email notifications sent from ServiceNow (sys_email, type = send)

ElMehdiELO — Fri, 01 Aug 2025 08:49:05 GMT

Thank you much for your feedback.