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!
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.