How to generate excel sheet of variable editor and attach it to requested item.

dj7887 · ‎10-09-2019

Hi All,

We have one catalog item and workflow behind it. At one stage of workflow we need to generate Excel sheet of few questions on variabl editor and and attach that excel sheet to current requested item.

Please provide your help on achieving this.

Thanks,

DJ

Ankur Bawiskar · ‎10-10-2019

Hi Dj,

Figured a way to do this

1) create a scheduled report for Report on Service Catalog Variables; keep it as active false; Run as On demand

Don't set any users in the users field. we don't want email to be triggered to any user; give some unique email Subject

https://docs.servicenow.com/bundle/madrid-performance-analytics-and-reporting/page/use/reporting/con...

2) in the RITM workflow use below script to trigger the scheduled report

var gr = new GlideRecord('sysauto_report');
gr.get('scheduledReportSysId');

// for global scope
SncTriggerSynchronizer.executeNow(gr);

// for custom scope
gs.executeNow(gr);

3) it creates an attachment in sys_attachment table for sys_email table

copy the attachment from that record to your ritm record

Note: one thing to be sure on this is you pick the correct record of sys_email

query sys_email table with that email subject given to scheduled report; orderByDesc() created date and setLimit(1)

sample script

var gr = new GlideRecord('sys_email');

gr.orderByDesc('sys_created_on');

gr.addQuery('subject','Sample Email Subject');

gr.setLimit(1);

gr.query();

if(gr.next()){

GlideSysAttachment.copy('sys_email', gr.sys_id, 'sc_req_item', current.sys_id);

}

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

AbhishekGardade · ‎10-09-2019

Check out this blog:

Create an attachment with submitted variables as its content

Please mark as Correct Answer and Helpful, if applicable.
Thanks!
Abhishek Gardade
Hexaware Technologies

Thank you,
Abhishek Gardade

dj7887 · ‎10-09-2019

Hi Abhishek,

How to do this only for selected variables. Also if you want to create PDF do you have any solution for that.

Thanks,

DJ.

AbhishekGardade · ‎10-09-2019

You can add filter while pulling the content in above mentioned link

Please mark as Correct Answer and Helpful, if applicable.
Thanks!
Abhishek Gardade
Hexaware Technologies

Thank you,
Abhishek Gardade

dj7887 · ‎10-10-2019

Hi Abhishek,

I tried the code given in that url however it is not working. Can you please let me know is there any modification required for that code.

Thanks,

DJ