Is there a way to extract a list of usernames from Jira based on a list of email addresses?
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?
Regards,
Juventino Gaytan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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')
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.