Need Itil users able to access sys_email table like admin and can create reports also on email table

[Servicenow User]

I want to understand OOB itil users access to sys_email table. and want to give access like admin to sys_email table.

[Viraj Hudlikar]

Hello  Servicenow User,

System/log tables can cause performance issues when you try and report on them due to their size, so proceed with caution.   You have to add the 'sys_email' table to a system property to be able to see it in the reporting interface.   The list options still may not be available depending on the field type but there's nothing you can do to change that behavior as it's the same across all tables.

Reporting on system tables

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact. 

Thanks & Regards, 
Viraj Hudlikar.

[Vinayak10 · Accepted solution]

Hi,

   itil users not able to access email(sys_email) table. if you want to give access then you can change in acl. but don't give access to itil users this is not a best practice.

   servicenow retrict to report on some system tables. if you want to report on that table add table into property value 

Property--> glide.ui.permitted_tables