How can I export email addresses from a query result?

[Vince Houmes]

Currently, if I export a query result to Excel and include the Assignee column, the names show up as "Bob Henderson", "Carol Zheng", etc. Is there a way to get "bobh@company.com", "carolz@company.com" to be exported instead?

Thanks!

[cgauterio]

Hi Vince,

Do you have access to the database? If you do, you can generate the query directly there and export the email addresses in a CSV. For instance:

copy (SELECT u.user_name, u.display_name, u.email_address
  FROM cwd_user u
 ORDER BY user_name) to '/tmp/users.csv' csv header;

This query will export the usernames, full names and email for every user in your instance.

Hope this helps.

Cheers,

Clarissa.