SQL to get all users (internal,Exteranl,Active Directory) from jira and confluence my-sql database

Paresh Gandhi

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.

Nic Brough -Adaptavist-

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+)