Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How to configure auto flush for attachment table?

Vimal Mishra1
Tera Contributor

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

1 ACCEPTED SOLUTION

suvro
Mega Sage

Cascade delete checkbox is there

It also deletes all records referencing that record

View solution in original post

3 REPLIES 3

suvro
Mega Sage

Cascade delete checkbox is there

It also deletes all records referencing that record

Mano R
Tera Contributor

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

Srinivas Karved
Tera Contributor

@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.