Can't create report on sys_email table

[Paolo2]

Why I cant create a report on the table sys_email? When I tried to create a new report, this table is not available. I am and admin user.

[AnubhavRitolia · Accepted solution]

Hi @Paolo2 

There are some tables for which you cannot create reports which include 'sys_email' table also.

Please find link below:

https://docs.servicenow.com/en-US/bundle/tokyo-now-intelligence/page/use/reporting/concept/c_ReportO...

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.

[Paolo2]

Thank you so much AnubhavRitolia. This solves my issue.

I read the link you provided and I understand that there might be some performance issue when querying on the system tables. I just like to have a COUNT report for how many emails we received in a day because we had an issue where we received a huge volume of emails and it causes a performance issue on our instance and would like to prevent this from happening again in the future. 

Do you think executing a COUNT report will affect our instance performance?

[AnubhavRitolia]

Hi @Paolo2 

Yes, As mentioned in the link I shared, if you create any report on 'sys_email' table it will create performance issue.

You can try in your PDI and see how your instance behave when you run the report and meanwhile access other list or form on different table.