Servicenow Reporting

[raman_kumar]

1. I have created a report in integration logs table and captured changes in update set, have scheduled email of report format type is kept excel, in test instance receiving file in excel format correctly but in production instance report format type is showing excel, receiving email file coming in pdf format don't know why?

2. and also Content is not accessible, when opening file its showing Access to this content denied based on report_view ACLs in production env?

can anyone guide me what steps to follow/change to execute/view successfully

[Tanushree Maiti · Accepted solution]

Hi @raman_kumar 

Check this KB: KB2697684 Scheduled email of Reports are sent in wrong file format 

Resolution

1. Change the run as user in the scheduled report to a higher privileged user (or an admin user) and check if the report exports correctly as Excel. 

2. Verify the report template and scheduled report configuration on the production instance to ensure the format is set to Excel.

3. Check the emails sent from the scheduled report to confirm the attachment format matches the configured format.

[raman_kumar]

okay thank you @Tanushree Maiti  for the solution.