Scheduled Email of Report sends empty excel sheet

cgduynguyen · ‎09-14-2016

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,

Suresh1 · ‎09-14-2016

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.

View solution in original post

cgduynguyen · ‎09-20-2016

Hi Suresh,

I raised a HI ticket with Service Now and they responded just like your answer. It's working perfectly now.

Thanks,

Duy

Suresh1 · ‎09-21-2016

Awesum!! Cheers

snehalkhare · ‎01-22-2018

If the user in RUN AS is having itil and report_group role still having the empty excel attached in the email.

Any other fields to check/update?

Thanks,

Snehal Khare

rashmi2109 · ‎07-31-2019

Hi Suresh,

This helped me to fix the blank report issue. Thanks much.

Rashmi