How to remove users who is inactive and not using group

Purushotham1992
Tera Contributor

‎09-27-2023 05:28 AM

How to remove users who is inactive and not using group

 

- user profile should have been created for more than 60 days
- has not logged in OR last login date is more than 30 days ago

 

 

Thanks in advance  

0 Helpfuls
  • 304 Views
1 REPLY 1

Mayur2109
Kilo Sage
Kilo Sage

‎09-27-2023 05:36 AM - edited ‎09-27-2023 05:37 AM

HI @Purushotham1992 ,

You can run a fix script on sys_user table, add query as active false, created>60 days, last login>30 and for checking if he is member of any group use sys_user_grmember table.

 

Please check and Mark Helpful and Correct if it really helps you.

Regards,
Mayur Shardul

0 Helpfuls