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

Question

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

Kathryn Moye_vso5k6 · Answer

Hello,

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

Thanks

Kathryn Moye_vso5k6 · Answer

Happy New Year to you!

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

Thanks!

jing_hwa_cheok · Answer

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 in the query with your user email. select DISPLAY_NAME from CWD_USER where EMAIL_ADDRESS=; Hope this help! Regards, Jing Hwa