Reports on email received from
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-26-2022 04:47 PM
Hi All,
Need to generate report on emails, where received from should be more than one recipients, please advice how to achieve this, can I do it through database views or can I try using email script, I also tried condition filter "greater than or is" 2 but it still shows the emails which has 1 recipients.
Reason we need this report to identify how many users sent a mail to different email ids like servicedesk, ithelpdesk and how many tickets got logged, like it logged only 1 ticket for servicedesk or multiple tickets(2 tickets for both servicedesk and ithelpdesk)
Please advice.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-26-2022 08:23 PM
Hi @Heisenberg ,
By default, system tables are excluded from being reported on. You'll need to update the system property glide.ui.permitted_tables and add sys_email_log to that property.
It would appear the system will not let you report on the "sys_email" table.
We are in the habit of attaching "notifications" as children of objects. So for example, we have a "Maintenance Event", and there are scheduled jobs that create "Maintenance Notifications", which are added to a related list on the Maintenance Event. The maintenance notification object has a fields with:
* the list of emails used for the notification
* the subject of the notification
* the body of the notification.
Then that table is easy to report on. Furthermore, if we want to use internal emails instead of having the email go across the internet from ServiceNow, we can pull down the notifications and send them from a server inside our network.