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- · Accepted solution]

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