How do I get the full name of a user from an email address in Confluence?

Kathryn Moye December 30, 2013

I have a table-data of user full names and their email addresses. I use the column of email addresses to generate a list-data in a scaffold form. Is there a way to use the email address I have and retrieve the user's full name from Confluence?

Thanks

1 answer

1 vote
jing_hwa_cheok
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
December 31, 2013

Hi Kathryn Moye,


Happy New Year!


The answer is yes. All user is stored in Confluence CWD_USER table. Here the query to list their display name and email. Replace the <EMAIL> in the query with your user email.

select DISPLAY_NAME from CWD_USER where EMAIL_ADDRESS=&lt;EMAIL&gt;;

Hope this help!

Regards,
Jing Hwa

Kathryn Moye January 7, 2014

Happy New Year to you!

Our admins won't give us access to the SQL macro. Is there any other way?

Thanks!

Kathryn Moye January 19, 2014

Hello,

Is there a way to do this without the SQL macro?

Thanks

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events