Scheduled Report by Inactive users

Nageshwari P
Tera Contributor

Hi I have a requirement on reports and dashboards.

Whenever one user is created a report and scheduled the report and after few days if the user is removed or Inactive do the schedule will be executed still or not? If the schedule is executed how to check the process. Please do help.

4 REPLIES 4

Mike_R
Kilo Patron
Kilo Patron

It shouldn't run if the "Run as" person is inactive. If you want it to run as a system user, clear out the Run as field.

Dominik Simunek
Tera Guru

Hi, be aware that if "Run as" user is inactive, the Scheduled Report is still triggering an email. If the inactive user still has the roles required to view a report on the target table, then it will even still contain the data. Read out my blog post "Do Scheduled Reports run under inactive users?" in which I documented results of my testing.

 

Best regards,

Dominik Simunek

SyedMahemoH
Tera Expert
Hi @Nageshwari P ,
I Hope you are doing good!
Scheduled reports in ServiceNow typically do not run if the user specified in the "Run as" field is inactive. 
To check the process, you can review the [sys_trigger] table for scheduled reports and verify the status of the user associated with the report. 
If the user is inactive, consider changing the "Run as" user to an active system user. ServiceNow checks the user’s status before running the report.
If my response helped you, please accept the solution and mark it as helpful.
Thank You!

This is not what you can observe on the platform. If the user is inactive, the Scheduled Report still runs and the email is sent out. If the inactive user still meets report-view ACLs, the data is included. See here the table explaining what I have tested in Yokohama PDI:

do-scheduled-reports-run-under-inactive-users-table.png

Full details on how I tested it can be found here.