How to export Group list from jira to csv file?

Hi'

I have JIRA server on my site.

the connection is not LDAP.

i want to export all the gruop list.

i have mysql ver- 6.0

Thank you.

1 answer

2 votes

There's no easy way to get the group list out of JIRA. (Well, for a short list of groups, copy and paste it out of the group maintenance screen)

For a longer list, reading the database out to a text file probably is quicker and easier. But NEVER write to a JIRA database. Only read.

For the group list - select * from cwd_group

The next logical question I can sense coming is "who is in groups" - select * from cwd_membership for that one.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.