Reveal Help Center

How do I get a list of email addresses for my users?

Connect to your User Management database using SQL Management Studio, Navicat, or other SQLclient and run on of the following queries:

All users including those that are disabled and/or not assigned to a project

select distinct email_address from users

All users that are enabled including those not assigned to a project

select distinct email_address from users where user_enable = 1

All users that are on any project including those that are disabled

select distinct email_address from users where user_id in (select user_id from user_cases)

All users that are on any project that are also enabled

select distinct email_address from users where user_enable = 1 and user_id in (select user_id from user_cases)