Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners Click HERE | EMEA/APJ Click HERE |
05/19/2023 11:42 AM
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.
05/19/2023 11:46 AM
You can use customquery job to move all accounts to admin if accounts get suspended user.
05/19/2023 12:06 PM
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].
05/19/2023 01:06 PM
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
05/19/2023 02:30 PM
Thanks. How can we make the account orphan through custom query?
05/19/2023 02:40 PM
Have provided sample in above response.
Thanks
05/19/2023 02:43 PM
Got it.. Thanks. Will test it out
05/19/2023 03:11 PM
set owner to userkey=1 else it will break system
05/20/2023 02:39 PM
@rushikeshvartak @dgandhi please provide me an updated query to test without breaking the system.
05/21/2023 10:02 AM
update user_accounts ua set ua.userkey=1 where ua.accountkey in ( select accountkey from accounts where status ='Suspended From Import Service')