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

[ElMehdiELO]

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

[Dr Atul G- LNG · Accepted solution]

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...

[ElMehdiELO]

Thank you much for your feedback.