Scheduled Email of Report sends empty excel sheet

[cgduynguyen]

Hi,

I created a scheduled job for sending reports to customers and it worked most of the time. However, this morning it sent out an empty excel sheet.

I executed it manually and received an excel sheet with records correctly.

Please help. My current ServiceNow version is glide-eureka-04-08-2014__patch13-hotfix5-03-22-2016_04-21-2016_1618.zip

Thanks,

[Deepak Kumar5]

You can mark the checkbox ignore if no record to prevent sending empty excel, if no data for the day.

If the report is created by someone else, Check if that user got inactivated in SN.

Thanks,

DK

[cgduynguyen]

Hi,

I marked the checkbox. Anw, there was data for the day so it sent out email but the excel sheet was empty.

The report is created by me so I don't think it's about user issues.

Any other ideas, please

Thanks,

Duy

[palanikumar]

Hi,

This could be a bug. Please raise a HI ticket with Service Now. They'll fix it.

Thanks!

[Suresh1 · Accepted solution]

Hi Duy,

You need to check the "RUN AS" field in your scheduled report. I mean check the roles of the user "RUN AS" in the scheduled report. If the RUN AS doesn't have a proper roles i.e ITIL/other role then the report will be sent with blank colunmns . I too faced the same issue and have reset the RUN AS then the report was sent properly.

Regards,

Suresh D

PS: Mark Correct/Like based on the effect of response.