Is there a way to extract a list of usernames from Jira based on a list of email addresses?
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
@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?
Juventino Gaytan
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')
It looks like you're new here. Sign in or register to get started.
