JIRA: How to Select the user and groups mapping 获得用户与用户组关联列表

Categories: Development Notes; Tagged with: ; @ May 28th, 2013 10:09


Export the users and group mapping list.


Seems there’s no feature / plugins for this requirement. If you can access the database, then everything is easy:

SELECT  member.[ID]
      ,member.[directory_id], jira_user.display_name
  FROM [jiradb].[jiraschema].[cwd_membership] member
left join [jiradb].[jiraschema].[cwd_user] jira_user
ON member.child_name = jira_user.user_name
order by parent_name


// Proudly powered by Apache, PHP, MySQL, WordPress, Bootstrap, etc,.