question Re: Script Help !! in Developer forum

Script Help !!

vidishaagarwal5 — Wed, 15 Oct 2025 07:32:18 GMT

Hi Team,

I have the below scenario to be implemented help here please.

When a record from the Knowledge Base (kb_knowledge) table is deleted, you want to delete all its attachments to save space.

Re: Script Help !!

Ravi Gaurav — Wed, 15 Oct 2025 07:44:23 GMT

Hi @vidishaagarwal5

The Below Simple code will help you !!

// Table: kb_knowledge
// When: before delete
(function executeRule(current, previous) {
var attachmentGR = new GlideRecord('sys_attachment');
attachmentGR.addQuery('table_name', 'kb_knowledge');
attachmentGR.addQuery('table_sys_id', current.sys_id);
attachmentGR.query();

while (attachmentGR.next()) {
attachmentGR.deleteRecord();
}
})(current, previous);

Re: Script Help !!

vidishaagarwal5 — Wed, 15 Oct 2025 07:46:14 GMT

Let me try this one .. I will get back to you

Re: Script Help !!

Raghav Sharma24 — Wed, 15 Oct 2025 07:50:43 GMT

kb_knowledge is the table for knowledge articles not knowledge base.

Try this script in After Delete Business rule on kb_knowledge table:

var att = new GlideRecord('sys_attachment'); att.addEncodedQuery('table_sys_id=' + current.sys_id); att.query(); att.deleteMultiple();

Please mark the answer correct/helpful accordingly.

Re: Script Help !!

Tejas Adhalrao — Wed, 15 Oct 2025 07:55:44 GMT

Hi @vidishaagarwal5 ,

1) on you table you can create the after business rule (delete)

and paste this script in your business rule

(function executeRule(current, previous /*null when async*/) { //thiss Find all attachments linked to this Knowledge record var attachmentGR = new GlideRecord('sys_attachment'); attachmentGR.addQuery('table_sys_id', current.sys_id); attachmentGR.addQuery('table_name', 'kb_knowledge'); attachmentGR.query(); //now Delete each attachment while (attachmentGR.next()) { attachmentGR.deleteRecord(); } })(current, previous);

If my response/article helped you, please mark it as the correct answer and close the thread — this helps other readers in the community.

Regards,

Tejas
🚀 ServiceNow Developer | 🏆 HackaNow Finalist | 💡 Community Contributor
📧 Email: tejas.adhalrao11@gmail.com
🔗 LinkedIn: linkedin.com/in/tejas1018

Re: Script Help !!

miftikhar20 — Wed, 15 Oct 2025 08:09:29 GMT

@vidishaagarwal5,Once you delete an article record, no attachment will appear in the sys_attachment table, so they are removed automatically from there but might still remain part of the system. Follow this thread to remove them permanently.

https://www.servicenow.com/community/developer-forum/finding-and-deleting-orphaned-attachments/m-p/2618342