Scheduled Personal report still runs for an Inactive user

Answered

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.

Agile Talent Asked on June 22, 2020 in Product Collaboration.

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.

on June 22, 2020.
Add Comment
2 Answer(s)
Best answer

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.

Agile Angel Answered on June 23, 2020.

— 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 ) )

on June 23, 2020.

And that would be exactly correct. Simply disabling the report is better than deleting the record.

on June 25, 2020.
Add Comment

Thanks Kevin. Noticed that we also had few records in our instance with same issue. Cleaned it up using data from this table

Agile Angel Answered on June 24, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.