Scheduled Report Issues

[servicenow14710]

Hello developers,

we have a monthly  Scheduled Report that emails an Excel file which contains all the ritms raised previous month,  it worked till last month it has generated record for jan month which is sent on feb  but it couldnt genreate the records of feb month , it sent out a PDF file instead of the Excel file, and if you try to open them, you get the message "The sender does not have access to this report".  can you please suggest /provide information as why the excel sheet is nt been generated . 

I searched run as with that user for whom email has sent , he is an active user & has snc_internal role. Please suggest how to debug this issue ? what roles are needed for run as user to generate report? what if run as is made empty ? will the report get generated?

Also, in the scheduled email of report this comment is shown-Data that the user selected in the Run as field does not have access to will be excluded from the generated report. If that user does not have access to any data in the report, an empty report is generated. what does this mean.!

can you please suggest /provide information as why the excel sheet is nt been generated . Any help is appreciated Thanks!

[Swapna Abburi]

Hi @servicenow14710 

Run as user on scheduled job should have necessary permissions to execute and generate the report with data. You can leave run as with blank value, it means the report will be executed by system user.

Alternatively you can keep system admin account also in run as field.

[servicenow14710]

Hi @Swapna Abburi : can you be specific as what are these necessary permissions required for run as field? Thanks for the response!

Also, in the scheduled email of report this comment is shown-Data that the user selected in the Run as field does not have access to will be excluded from the generated report. If that user does not have access to any data in the report, an empty report is generated.

what does this mean. Thanks!

[Swapna Abburi]

@servicenow14710 

In your scenario, you are executing report on ritms so the run as user should have read access to ritm table and records. Ootb, the user should have either itil or atleast sn_request_read role.

Coming to your second question: The message states that if user has access to read partial data on this table, only those records will be present in the report. Similarly if user doesn't have access to read any record in the table then the report is blank.

[Ankur Bawiskar · Accepted solution]

@servicenow14710 

ensure Run as = System Administrator

What changed from last month?

Troubleshooting scheduled report issues 

If my response helped please mark it correct and close the thread so that it benefits future readers.