How to add sys_attachment table available for reporting? How to create a report with sys_attachment

[Vidya Aeil]

I need to report on 'sys_attachment' table. But this attachment table is not appearing on the Reports table field. How can I include 'sys_attachment' table? any settings? And why is not appearing?

[Aman Kumar S]

Hi @Vidya Aeil ,

In order to be able to build report on sys_ tables, you need to add the table name sys_attachment to system property "glide.ui.permitted_tables" 

[Vidya Aeil]

Thank you @Aman Kumar S 

[Aman Kumar S]

Hi @Vidya Aeil ,

Please mark the apt response and close the thread so it ends up in resolved queue and people looking for the same issue can spot the solution.

[Mohith Devatte]

Hello @Vidya Aeil ,

By default system tables are prohibited from reporting which is controlled by a system property named as "glide.ui.permitted_tables" .

You need to open this property in sys_properties table and then add "sys_attachment" table name in the value field of property form and save it.

Note: Please confirm with your admin or team members or project managers first to do this change as its by defult restricted by servicenow

Hope this helps 

Mark my answer correct if this helps you 

THanks