Hide/Remove -Deleted accounts from User->Accounts ... - Saviynt Forums - 35445

Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

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

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

Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

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.

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.

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.

Got it.. Thanks. Will test it out

set owner to userkey=1 else it will break system

Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

@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 you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.