Here is a business rule we use for Change Requests to log this into the Work Notes
Hope this helps!
Table: sys_attachment
When: After
Insert, Update, Delete are all checked
Condition: current.table_name == "change_request"
var gr = new GlideRecord("change_request");
gr.addQuery("sys_id", current.table_sys_id);
gr.query();
if (gr.next()) {
if (current.operation() == "delete") {
gs.eventQueue("change.attachment.delete", gr, current.file_name, gs.getUserDisplayName());
gr.work_notes = "Attachment: " + current.file_name + " has been deleted by " + gs.getUserDisplayName();
}
else {
gs.eventQueue("change.attachment.insert", gr, current.file_name, gs.getUserDisplayName());
gr.work_notes = "Attachment: " + current.file_name + " has been inserted or updated by " + gs.getUserDisplayName();
}
gr.update();
}
