create a report using scripting

[Sai104]

Hello,

We would like to write fix script to generate a report. Is it possible to create a report using scripting?

Many Thanks in Advance!

Regards,

Sai.

[Ankur Bawiskar · Accepted solution]

Hi Sai,

Why to create reports from script?

If you already have report and have configured the Scheduled Report which would send the report to users as attachment then here is the script to run that

var scheduleReport = new GlideRecord('sysauto_report');

scheduleReport.get('scheduled_email_report_sys_id');

SncTriggerSynchronizer.executeNow(scheduleReport);

Regards
Ankur

[Rona Sarda_as]

Hi @Ankur Bawiskar ,

Is it possible to attach the Report as a pdf file?
I already have a Report, I just have to run it and attach it to the case that will be created using scheduled job.

[Ankur Bawiskar]

Hi,

I doubt this is feasible

Regards
Ankur

[Adam Stout]

Depending on your use case, you may want to look at the Performance Analytics Academy session we did last year on building a Burst Reporter with Flow Designer.  https://community.servicenow.com/community?id=community_blog&sys_id=43455acedb30ac1011762183ca961983