Querying Jira DB for all active users that have created tickets

[Aidan Satterwhite]

Hello,

I'm looking to query the Jira DB for a list of all active users that have ever created tickets. Is there a way to do that? I've been unable to identify a similar query in my research, and I'm not sure which tables contain the information that I'm looking for.

Thank you!

[Nic Brough -Adaptavist- · Accepted solution]

Welcome to the Atlassian Community!

First, my usual advice - reporting off a Jira database is the worst possible way you can report on Jira. 

It's slow, ugly ("show me issue X" takes 12 joins before you triple that with adding "in human language" to the question) and you will probably not understand the answers it gives you.  It's also possible to cripple the performance of the database to the point where it takes down your Jira if you're not running queries against a replica of production.  To be avoided at all times.

But yours is not a complex query likely to cause you problems.

Start with "select creator from jiraissue;" and then you will probably want to join that to cwd_user on "creator = id to get the human data (email, username, display name, etc)

[Aidan Satterwhite]

Thank you, this is exactly what I was looking for