How can I get a list of active user names?

Question

Michael Partyka · Answer

Hi Lu Ann,

using sql query it is easy:

JIRA 6.2 and below

SELECT DISTINCT u.lower_user_name, 
 u.first_name, 
 u.last_name, 
 u.email_address, 
 d.directory_name 
FROM cwd_user u 
 JOIN cwd_membership m 
 ON u.id = m.child_id 
 AND u.directory_id = m.directory_id 
 JOIN schemepermissions sp 
 ON Lower(m.parent_name) = Lower(sp.perm_parameter) 
 JOIN cwd_directory d 
 ON m.directory_id = d.id 
WHERE sp.permission IN ( '0', '1', '44' ) 
 AND d.active = '1' 
 AND u.active = '1' 
ORDER BY directory_name, 
 lower_user_name;

JIRA 6.2.1 and above

SELECT DISTINCT u.lower_user_name, 
 u.first_name, 
 u.last_name, 
 u.email_address, 
 d.directory_name 
FROM cwd_user u 
 JOIN cwd_membership m 
 ON u.id = m.child_id 
 AND u.directory_id = m.directory_id 
 JOIN globalpermissionentry gp 
 ON Lower(m.parent_name) = Lower(gp.group_id) 
 JOIN cwd_directory d 
 ON m.directory_id = d.id 
WHERE gp.permission IN ('USE','ADMINISTER','SYSTEM_ADMIN') 
 AND d.active = '1' 
 AND u.active = '1' 
ORDER BY directory_name, 
 lower_user_name;

Boris Georgiev [Appfire] · Answer

Currently there is no built-in functionality providing this, but you can check this feature request - it provides workarounds. https://jira.atlassian.com/browse/JRA-29149