How to update script to get filename of attached file

[ceraulo]

Hello!

I have a script action that adds a work note to the ticket when an attachment on an incoming email is discarded by ServiceNow. The next requirement is to get the file names of the discarded files and it to the work note. I tried updating my working script but it's not working as I intended.

var target_table = current.target_table;
var target = current.instance;

var gr = new GlideRecord(current.target_table);
gr.addQuery('sys_id', target);
gr.query();
if (gr.next()) {

    var gr2 = new GlideRecord('sys_email_attachment');
    gr2.addQuery('email.sys_id', target);
    gr2.addQuery('action', 'discarded');
    gr2.query();

    if (gr2.next()) {

        if (target_table == "incident" || target_table == 'sc_task') {
            gr.work_notes = "One or more attachments from an email sent by " + current.user_id.name + " with subject " + current.subject + " were discarded. " + gr2.file_name;
            gr.update();
        }

    }

Please help!

Thank you.

[ceraulo]

Thanks @Ankur Bawiskar 

I'll create another thread with this other issue.

Cheers!

[Ankur Bawiskar]

discussion can continue in this thread as well