Way to Uncorrelate the Specific Accounts for users in bulk

[AravindK]

Hi Team,
We have some thousands of inactive accounts from one application are correlated to the users. Is there any way to uncorrelate the accounts from the user profile in Bulk ?

Thanks,
Aravind

[sk]

@AravindK : As far as I know there is no option to uncorrelate the accounts in bulk though we have option to override the correlation. Since you are in 5.5.x you have an option to run custom query to update user_accounts table of respective accounts and make userkey column null for those inactive accounts

Example:

update user_accounts set userkey=null where accountkey in (select acccountkey from accounts where status=2 and endpointkey=xx)

 But what is the reason to uncorrelate the inactive account from users? They still belong to same user right then why do you want to uncorrelate?

[rushikeshvartak]

You can do from Users - Accounts - select one by one --> Change Owner/ Remove Owner.

Bulk Ownership removal is not supported.