Identify Knowledge Articles with large attachments

[diegofarias]

I need to pull a report that lists all the Knowledge Articles that contain large attachments. Since sys_attachment  is a forbidden table, how can connect it to Knowledge? any ideas? 

[Bhuvan]

@diegofarias 

Go to system properties and open the property 'glide.ui.permitted_tables' and add sys_attachment in the allowed tables for reporting and dashboards. Once added in the property, you can report on sys_attachment table

Add a report or dashboard sorted by size bytes and it should fulfill your requirement

If this helped to answer your query, please mark it helpful & accept the solution. 

Thanks,

Bhuvan

[Bhuvan]

@diegofarias 

Did you get a chance to review this as I believe the provided information should answer your question.

If my response helped to guide you or answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[kaushal_snow]

Hi @diegofarias ,

you can utilize the sys_attachment and sys_attachment_doc tables, which store metadata and content chunks of attachments, respectively. While the sys_attachment table is not directly available for reporting by default, you can enable it by modifying the glide.ui.permitted_tables system property to include sys_attachment. Once enabled, you can create a report that filters records based on the Table Name field set to kb_knowledge and the Size Bytes field to identify large attachments. ....Alternatively, you can create a custom script or scheduled job that queries the sys_attachment table for records associated with the kb_knowledge table, checks the Size Bytes field, and identifies attachments.......

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.