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

[Kathryn Moye]

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

[jing_hwa_cheok]

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=<EMAIL>;

Hope this help!

Regards,
Jing Hwa

[Kathryn Moye]

Happy New Year to you!

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

Thanks!

[Kathryn Moye]

Hello,

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

Thanks