Scheduled Personal report still runs for an Inactive user
I discovered an Agile user who has been Inactive for over 4 years. She left the company. She still has the Report Manager role. And she still has a Personal custom report scheduled to run every day. It still runs. If I remove all her roles, except for ‘My User Profile’, that should stop it from running. Is there any query to find who else is Inactive and still has enabled scheduled reports? I guess one way is to create a report of every Inactive user and show their roles.
Look in SCHEDULED_EVENT, where OWNER is the ID of the inactive user. I suspect that is where scheduled reports would be. Simply delete the record or set ACTIVE to be zero, and the report will no longer run.
— Thanks Kevin. This is what I will run to disable the scheduled report when the owner is inactive/disabled.
update scheduled_event set active = 0
where active = 1 and type = 7111 and owner in (
select id from agileuser where enabled = 0
and id in ( select distinct owner from scheduled_event where owner > 0 and active = 1 and type = 7111 ) )
Thanks Kevin. Noticed that we also had few records in our instance with same issue. Cleaned it up using data from this table
mrmathison
Actually, it appears she does not have any Roles in the Prod system, except for ‘My User Profile’, yet the report still runs. I will need to convert her from an LDAP user to a DB user (in agileuser table). Then make her Active and reset her password. Then But that only works if I re-start Agile. Then I can log in as her and disable the Personal Report. If anyone knows of an easier way to do it, please let me know. Thanks.