- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2025 01:36 AM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2025 01:41 AM
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.
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]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2025 01:41 AM
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.
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]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2025 01:49 AM
Thank you much for your feedback.