Extracting all user email ids from ALM/QC

There is no easy option available to extract all user email ids from ALM at one go.

Usually to have few users email ids we can login to SiteAdmin from ALM and select user to extract the mail id but this is painful and rigorous activity.

We can overcome this issue if we have SiteAdmin database access. Please follow below steps for the same

Connect to any frontend database
Access to SiteAdmin Schema
Connect to USERS schema and fire following query to extract all user email ids

SELECT EMAIL, USER_NAME
FROM td.USERS U
WHERE EXISTS
(SELECT * FROM td.USERS_PROJECTS P
WHERE U.USER_ID = P.USER_ID)
AND EMAIL IS NOT NULL AND EMAIL <> ''
ORDER BY USER_NAME;

*in the above query "td" refers site admin schema