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

[RV]

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.

[rushikeshvartak]

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

[RV]

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]. 

[dgandhi]

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

[RV]

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

[dgandhi]

Have provided sample in above response.

Thanks

[RV]

Got it.. Thanks.  Will test it out

[rushikeshvartak]

set owner to userkey=1 else it will break system

[RV]

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

[rushikeshvartak]

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