How to properly handle / remove a duplicate AccountKey

[Cliffy]

I have an error popping up in our AD connection and I finally tracked it down to a duplicate account key.  The user retired and was re-hired part time but the logic created a duplicate AD account.   I now have this user with two separate AccountKeys  and the same accounts.ENDPOINTKEY.  Is it safe / possible to delete one of the AccountKey's?

[NM]

Hi @Cliffy , mark the not in use account as suspended from import service.

[rushikeshvartak · Accepted solution]

Change status of account and update accountid

select accountkey as accounts__primarykey, concat(accountid,'-old') as accounts__accountid, 'SUSPENDED FROM IMPORT SERVICE' as accounts__status where accountkey= 1111 limit 1;

Use enhanced query