Cloud Migration: Duplicate User -

[Joerg]

Hello,

We have some email addresses that occur multiple times for users.

The cases concern users that are created in Azure AD as well as in Jira Internal Directoy. The users in the internal directoy are set to inactive.

For example:

Azure AD:

Full Name: Jackson, Jack

Username: jjackson

Email: jjackson@ourdomain.com

Jira Internal Directory:

Full Name: Jackson, Jack

Username: jjackson@ourdomain.com (Inactive)

E-mail: jjackson@ourdomain.com

Do I have to change the email addresses for the cloud migration or is this constellation valid and in the cloud these users are combined under one user (through the email address)?

Another point is that we have some AD users without an email address. The users had email addresses at the beginning, but these were later removed in AD and synced to Jira. My thought is to manually set the email address in the Postgres DB, in the following form: jirauser-XYZ@ourdomain.com

If we use Atlassian Access in the cloud, do we have to pay for those "fake" email addresses if we own the domain ourdomain.com?

KR

[Benjamin · Accepted solution]

Hi @Joerg ,

For migration to cloud, this user is treated as different users using the same e-mail. It will need to be corrected and will be flagged by JCMA.

All users need to have e-mail address if they are to be migrated and map since cloud uses the e-mail as the user id.

Fake or dummy e-mail addresses that are inactive are not licensed. Therefore, no need to pay.

There is a KB article to help with setting fake e-mails to help with the migration:

https://confluence.atlassian.com/cloudkb/resolve-duplicate-email-addresses-when-migrating-to-the-cloud-1101932318.html

Hope this helps.

Thanks,

Ben

[Joerg]

Hi @Benjamin ,

thx for the reply.

I read that KB article, thats why i had the question. Beacause the used SQL Query 

select lower_email_address,directory_id,count(*) from cwd_user group by 1,2 having count(lower_email_address) > 1;

doesn't show the mentioned users as duplicates because they reside in different user directories.

KR

[Benjamin]

HI @Joerg ,

There's a few ways you can do this. Here's a post that is going over similar ask.

https://community.atlassian.com/t5/Jira-Software-questions/How-to-get-Duplicate-users-from-2-different-directories-from/qaq-p/1824880

You can also dump the two sets(one for each directory) into a CSV table and use excel rules to identify the duplicates between two columns.

-Ben

[Joerg]

Yes, I had misunderstood the KB article: I thought it was not a duplicate as long as the users come from different directories.

But it is a duplicate because the directories don't matter.

[Benjamin]

Glad it all worked out. Good Luck with your migration!