Exporting users from Jira projects

[Deepak]

Dear community,

I have project with more then 200 users. Now I would like to export users from the project into Excel. Is there any DB Query to filter out users from the project.

Regards,

Deepak

[Brant Schroeder · Accepted solution]

@Deepak 

Something like this should work.

SELECT
u.user_name,
u.last_name,
u.first_name,
u.email_address,
m.parent_name,
substring( ua_lastlogin.attribute_value, 0, len(ua_lastlogin.attribute_value) - 2 ),
u.active
FROM cwd_user u
LEFT JOIN cwd_user_attributes ua_lastlogin on u.id = ua_lastlogin.user_id and ua_lastlogin.attribute_name = 'lastAuthenticated'
LEFT JOIN cwd_membership m on u.id = m.child_id
ORDER BY u.user_name asc, u.last_name asc, u.first_name asc, m.parent_name asc

[Deepak]

Thank for the query @Brant Schroeder