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

ElMehdiELO
Tera Contributor

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

1 ACCEPTED SOLUTION

Dr Atul G- LNG
Tera Patron
Tera Patron

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.

 

DrAtulGLNG_0-1754037598247.png

 

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

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

View solution in original post

2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

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.

 

DrAtulGLNG_0-1754037598247.png

 

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

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

ElMehdiELO
Tera Contributor

Thank you much for your feedback.