How to configure auto flush for attachment table?

[Vimal Mishra1]

Hi,

We would like to setup auto flush configuration for sys_attachment table without leaving orphaned record in sys_attachmnet_doc table. I am not sure configuring auto flush on sys_attachment would cleanup the sys_attachment_doc data as well. Any suggestions on how we can clean up both tables using OOTB functionality provided by ServiceNow?

Thanks,

Vimal

[suvro · Accepted solution]

Cascade delete checkbox is there

It also deletes all records referencing that record

[Mano R]

My concern here is we are not able to configure auto_flush on sys_attachement table

[Srinivas Karved]

@Mano R - as it is system table, the permission is restricted. Refer to this KB https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0719416 and you should be having resolution as per your requirement.