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

[Jeni2]

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.

[Mark Manders]

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?

[Jeni2]

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.

[Mark Manders]

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.

[Bhuvan]

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

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

Thanks,

Bhuvan