Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Hide/Remove -Deleted accounts from User->Accounts page

RV
Regular Contributor
Regular Contributor

Is there a way to remove/unmap all "-Deleted on xx-xx-xxxx mm:dd"  -  'Suspended from import service' accounts from User->Accounts Page?  I am looking for an automated way rather than manually clicking on "Remove User" button.   

We have close to 10K+ users with at least 2-3 -Deleted accounts and looking to have a clean view of User->Accounts page.

9 REPLIES 9

rushikeshvartak
All-Star
All-Star

You can use customquery job to move all accounts to admin if accounts get suspended user.


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

RV
Regular Contributor
Regular Contributor

Is it the only preferred solution?    

Can you share the custom query to make sure if we are doing it on the correct table(s)  [user_accounts]. 

OOO is not possible to delete/remove the account with SUSPENDED FROM IMPORT SERVICE state.

You can associate this accounts with any dummy identity or make these accounts as orphan so that it doesn't come under user.

You can try below sample query for your reference. Please try this in lower environment for 1-2 users and validate it.

dgandhi_0-1684526679280.png

Thanks

Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.

RV
Regular Contributor
Regular Contributor

Thanks.  How can we make the account orphan through custom query? 

Have provided sample in above response.

Thanks

Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.

RV
Regular Contributor
Regular Contributor

Got it.. Thanks.  Will test it out

set owner to userkey=1 else it will break system


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

RV
Regular Contributor
Regular Contributor

@rushikeshvartak @dgandhi  please provide me an updated query to test without breaking the system.

update user_accounts ua set ua.userkey=1 where ua.accountkey in ( select accountkey from accounts where status ='Suspended From Import Service')


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.