How do you delete duplicate user ids after integrating with AD?

Ash9

Hi there,

Does anyone know how to delete duplicate user ID's from Jira? I had about 60 users created in the internal jira directory. After connecting to AD and syncing the data, we found that those 60 users were duplicated (as they had the same logon id).

I'can't delete the acounts as they have issues assigned/reported to/by them.

I've tried the rename user script, by this does not work, looks like the duplicate id's cause the script to fail.

The other option I've looked at is deleting all the AD user ids from database (the trying rename), but in testing this did not work (I deleted them from the cwd tables - are there any others that need to be deleted), the users still appeared in the directory.

Would really appreciate some advise.

Thanks

Alan elfert

I had a similar issue two years ago when we converted to an AD. Here are a number of statements I ended up using. I think you have to go through this for each user, replacing some of the constants with the applicable values. I don't think Atlassian supports this but they don't have a better answer either (at least didn't at the time).

select * from jiraowner.cwd_directory;

select * from JIRAOWNER.CWD_MEMBERSHIP where upper(child_name) = upper('a11950');

delete JIRAOWNER.CWD_MEMBERSHIP where id = 10292;

select * from JIRAOWNER.CWD_USER where upper(user_name) = upper('a11950');

delete JIRAOWNER.CWD_USER where id = 10236;

update jiraowner.cwd_membership set directory_id='10100' where child_name='a11950' and parent_name <> 'jira-users';

update jiraowner.cwd_user set directory_id='10100' where user_name='a11950';

delete JIRAOWNER.CWD_MEMBERSHIP where upper(child_name) = upper('a11950');

delete JIRAOWNER.CWD_USER where upper(user_name) = upper('a11950') and directory_id = '10100';