Reports on the Sys_Email table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-15-2014 12:28 PM
I'm trying to generate a simple report that just tells me how may emails the system sent out over the last week but I don't seem to be able to select the sys_email table in the Reports module. Is there some other way to query that table for reports?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-15-2014 12:49 PM
Ha! Found my own answer: Reporting on System Tables - ServiceNow Wiki
If you must report on a system table, you can add it to the glide.ui.permitted_tables property. Navigate to System Properties > UI Properties and locate the property labeled List of system tables (beginning with "sys_", comma separated), that are reportable. By default, system tables are not reportable. Proceed with caution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-15-2014 12:53 PM
Careful with that one. Not sure how big your organization is, but our sends enough email for a report on a week's worth of sys_emails to enter script timer mode. Are you the only one viewing that report?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-15-2014 12:57 PM
Yeah it will just be me. We're sending about 500 emails out daily so I'm thinking it might be best to run this thing in the dead of night on a weekend
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-15-2014 12:58 PM
500 emails per day isn't so bad. Run away!
