I'm looking for SQL statemen to get all the users from jira and mysql database
db type - my sql
I have db consol add on that can be used to execute the query.
Reason - I'm mirroring prod with dev and need to create missing users manually.
Also need sql for groups as well.
Select * from cwd_user ;
Bit blunt and it assumes you're on a relatively recent version of Jira (4.3+ I think) and Confluence (3.5+)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.