question Fetch data in report on how many emails has been triggered on month basis in Community Central forum

Fetch data in report on how many emails has been triggered on month basis

Jeni2 — Mon, 25 Aug 2025 11:13:30 GMT

Hi All,

There is a Job,which will run on daily basis and it will send an email to manager whenever user active state changes to inactive- Here i want to pull out a report on how many emails has been triggered on daily basis and month basis .

Thanks inadvance.

Re: Fetch data in report on how many emails has been triggered on month basis

Mark Manders — Mon, 25 Aug 2025 11:53:26 GMT

What's the business case for this? The data is available in the cmn_notif_message table (related list on notification record). But that should be the same number as users being set to inactive, right?

Re: Fetch data in report on how many emails has been triggered on month basis

Jeni2 — Mon, 25 Aug 2025 13:27:39 GMT

Yes, it should be the same as the inactive user record. However, in this table, the notification sent to the VIP group is not being captured.

Business case

If inactive users are found in any active records in a ServiceNow table, then a notification should be sent to the manager stating that their reportee who was deactivated is still part of these active records.

Re: Fetch data in report on how many emails has been triggered on month basis

Mark Manders — Tue, 26 Aug 2025 07:39:02 GMT

Now I am confused. You first ask to get a report on the number of emails that have been send from a notification and now you are asking about checking if the inactive users are still on active records? Not sure what the relationship between these two is.

Re: Fetch data in report on how many emails has been triggered on month basis

Bhuvan — Tue, 26 Aug 2025 08:10:39 GMT

@Jeni2

You have out of box indicator for this, create a dashboard to show this and user can export on-need basis or you can schedule the report.

You can filter the email sent criteria using one of the breakdown options for your requirement and choose the aggregation as daily and monthly.

If you want to create report using system table 'sys_email_log', follow below steps

https://www.servicenow.com/docs/bundle/washingtondc-now-intelligence/page/use/reporting/concept/c_ReportOnSystemTables.html

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan