How to find different username using same email address.

[Jongho Jung]

Hello,

I want to find users has more than two accounts.

At first, I am trying to make user list using same email address.

Is there any SQL to find user with same email address.

Thanks.

[Fabio Racobaldo _Herzum_]

Hi @Jongho Jung ,

the following article could help you finding users with the same email address https://confluence.atlassian.com/jirakb/how-to-find-jira-users-with-duplicate-email-address-1376031383.html

Hope this helps,

Fabio