Scheduled Report not showing updated information

ljschwaberow · ‎05-20-2016

We have a scheduled report go out every morning at 6:30am that has the condition to show all incidents opened within the last 24 hours. Frequently, the report that is generated is blank but if you go into the report in ServiceNow and rerun it, the incidents will show up. Has anyone experienced their scheduled reports not reflecting updated information? Especially with a condition such as this?

Thanks,

Lindsey

ljschwaberow · ‎05-27-2016

I wanted to complete this post in case anyone uses it - I discovered that this issue had nothing to do with the format of the scheduled report but the conditions and how the incidents were being assigned. Turns out the incidents were being assigned to the parent group and not any of the children groups. The report was set for assignment_group.parent = Security and didn't include 'or - assignment_group = Security'. These incidents were later showing up because the incidents were being reassigned throughout the day to the children groups.

View solution in original post

Suresh1 · ‎05-20-2016

Hi Lindey,

Generally it should execute on daily basis and report should be sent with data. Try to use 'conditional' option and write script to include the weekdays(Mon-Fri).

var day = new Date().getDay();

if ((day == 1) || (day == 2) || (day == 3) || (day == 4) || (day == 5))

{

answer = true;

}

else

{

answer = false;

}

Then the script might runs.

paramveer · ‎05-20-2016

It's strange, Can you please provide the screenshot of report and schedule. There can be something missing..

Thanks,

Param

ljschwaberow · ‎05-20-2016

Hi Paramveer,

This report is supposed to run daily at 6:30am and gather all incidents opened by a certain group, with a certain assignment group opened within the last 24 hours. We do want this to run 7 days a week.

Here are the screen shots of the schedule report:

Here is the report:

rajeevlochan82 · ‎05-20-2016

Hi Lindsey,

The configuration looks fine. Can you please try changing Type from 'PDF-Landscape' to 'Excel' and give a try.

Thanks,

Rajeev Lochan