Creating Reports that lists recent attachment uploads to certain tables.

[humblecommitted]

Hello Community,

I am trying to create a report that is able to filter out the sys_user table to grab a list of users who have uploaded attachments to their profile?

If so, is there a way to have the report filter based on the specific name of the file uploaded?

For right now, out of the box, we can filter a report to show which sys_user profile was updated and by whom during a time frame, but that is not precise to what we would like the report to gather.

Does anyone know how to do this?   Any help would be greatly appreciated.

[top_tanti · Accepted solution]

You could report on the sys_attachment table, however, it is not permitted for reporting by default. If you wish to report on the Attachments table, you must add the sys_attachment table to the permitted tables property [glide.ui.permitted_tables]. Once this is done, you could create a report on Attachments with specific filters (table = sys_user && file name = XYZ) while displaying the file name and who the attachment was created by.

ServiceNow does not recommend enabling reporting on this system table as it may cause performance issues on your instance if running inefficient queries. Read more here.

An alternative to modifying the permitted tables property would be to navigate to the Attachment table (sys_attachment.list) and applying your desired filters.

[humblecommitted]

Just to let everyone in the community know,

Here is what I did in detail based on top of what Top Tanti.

1) I had to go into system properties.   Some may notice that this list not readily available so I had created link in the system properties tab (which may not be best practice).

2) or you can simply make your way here instead which i found to be a pain:

3) i was then able to make my way to "glide.ui.permitted_tables" and add "sys_attachment"

4) I was then able to go into the reports category and search based on attachments.

Thanks again to Top and the rest of the community for your prompt and helpful advise!  

Sincerely,

Orlando Galindo