Get list of usernames from email list.

[Juventino Gaytan Jr]

Is there a way to extract a list of usernames from Jira based on a list of email addresses?

[Adrian Stephen]

Hi @Juventino Gaytan Jr 

Welcome to the community!

The username and email data are stored on the cwd_user table from the database. 

You can query the usernames there based on their email.

Regards,

Adrian Stephen

[Juventino Gaytan Jr]

@Adrian Stephen  Thanks for replying to my questions.  I appreciate the insight.  Would I be able to pipe in a list of emails to extract the associated usernames?

Regards,

Juventino Gaytan

[Adrian Stephen]

Hi @Juventino Gaytan Jr 

It should be possible like this :

select user_name, email_address from cwd_user where email_address in ('username1@email.com','username2@email.com','username3@email.com')