Scheduled Report not showing updated information

[ljschwaberow]

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

[rajeevlochan82]

Type

Report output format. Graphical reports are sent as PNG or PDF files, and list reports are sent as PDF files. When scheduling a graphical report to be emailed, select output format PDF or PDF-landscape to include the chart grid data. When scheduling a data report, select output format Excel or CSV. The look of scheduled and on-demand charts varies depending on the ServiceNow release: Eureka: All reports are generated with the Highcharts charting engine, giving them a consistent look. Dublin: Scheduled reports and exported reports are generated with the standard charting engine. On-demand charts are generated with Highcharts, giving them a different look than scheduled and exported reports. Calgary and earlier: All charts are generated with the standard charting engine, giving them a consistent look.

[ljschwaberow]

Thank you for the information! I set up a test copy report to run all weekend along side the PDF and they behaved exactly the same. Nothign was reported all weekend but there are incidents in the system that should have been included. Today's reports worked fine.

[rajeevlochan82]

Hi Lindsey,

Can you try changing Type to 'Excel' and click on 'Execute Now' button on Top of the scheduled reports and see if it makes any difference.

Thanks,

Rajeev

[ljschwaberow · Accepted solution]

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.