How to send attachment as a file not as a link

[Samiksha2]

Hi All,

I have a requirement to add attachment in the emails.

I have created a mail script.

 addAtachments();

    function addAtachments() {
        var gr = new GlideRecord('sys_attachment');
        gr.addQuery('table_sys_id', current.sys_id);
        gr.orderByDesc('sys_created_on');
        gr.query();
        if (gr.next()) {
            template.print('Attachment: <a href="https://' +
                gs.getProperty('instance_name') +
                '.service-now.com/sys_attachment.do?sys_id=' +

                gr.sys_id + '">' + gr.file_name + '</a>\n');

        }

    }

But client wants to add attachment instead of link.

Please help in this.

Thanks,

Samiksha

[Ankur Bawiskar]

@Samiksha2 

please share what's the current setup along with screenshots.

[Samiksha2]

Hi @Ankur Bawiskar ,

Please check the below SS:

and Mail script is add_attachment

 addAtachments();

    function addAtachments() {
        var gr = new GlideRecord('sys_attachment');
        gr.addQuery('table_sys_id', current.sys_id);
        gr.orderByDesc('sys_created_on');
        gr.query();
        if (gr.next()) {
            template.print('Attachment: <a href="https://' +
                gs.getProperty('instance_name') +
                '.service-now.com/sys_attachment.do?sys_id=' +

                gr.sys_id + '">' + gr.file_name + '</a>\n');

        }

    }

Whenever an attachment is added, in the additional comment we are updating attachment has been added.

Thanks,

Sam

[Ankur Bawiskar · Accepted solution]

@Samiksha2 

then to send latest file use this logic

1) create BR on sys_email table and use this script and it will send only latest file

I had used something similar in the past and it worked fine

After Insert on sys_email

(function executeRule(current, previous /*null when async*/) {

	// Add your code here
	try{
		var att = new GlideRecord('sys_attachment');
		att.orderByDesc("sys_created_on");
		att.addQuery('file_name', fileName);
		att.addQuery('table_name', 'sc_req_item');
		att.addQuery('table_sys_id', current.instance);
		att.setLimit(1);
		att.query();
		if(att.next()){
			var rec = new GlideRecord('sys_email_attachment');
			rec.initialize();
			rec.attachment = att.sys_id;
			rec.file_name = att.file_name;
			rec.source = 'notification';
			rec.content_disposition = 'attachment';
			rec.email = current.sys_id;
			rec.insert();
		}
	}
	catch(ex){
		gs.info('Email exception' + ex);
	}

})(current, previous);

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Samiksha2]

Hi @Ankur Bawiskar ,

I created the BR. But in email attachment is not attached. I have remove the mail script. Now how I can send mail to requested for and watch list users?

Please guide me here.

Thanks,

Sam

[Ankur Bawiskar]

@Samiksha2 

your requirement was related to attachments so I assume/believe this is already achieved -> Now how I can send mail to requested for and watch list users?

So here is what I assume based on your question

1) additional comment changes and email triggers

2) email script will pick latest file present on RITM record and send email with only this file (this is handled via the BR I shared)

If my response helped please mark it correct and close the thread so that it benefits future readers.