How can I get a list of active user names?

[Lu Ann Hargis]

How can I get a list of active user names?

[Michael Partyka]

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]]

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