How to remove Non existent users from reports

[PaulSylo]

Hello,

I got an observation as nearly 2364 entries as " Reports assigned to nonexistent group/User" , i checking i see the most of the user are moved out of organisation, what is the easy way to remove these users and ensure the correctness,

Regards,

S

[Prabu Velayutha]

Hello @PaulSylo 

Do you have any identifiers for terminated users like account set to inactive or termination date gets updated? 

Implement a Scheduled Script job to query the inactive users in the user table and delete the entries of assigned reports from sys_report_users_groups table. 

It is better if you sequence this job to run later user provisioning tools integration job like Workday, LDAP etc which manages user account  then you can even make this as post script job to check the active report assignments and delete for the terminated or deactivated user report assignment to keep it up to date. 

Thanks!