As an Admin how can I query Jira's backend database for things like users and groups?

[Gail]

I am finding spotty information on database scheme, but I can't find the basics of how to setup database querying, what tools to user, etc.    Any help would be greatly appreciated.   

I want to be able to query Jira users, groups to do things like export lists of users in groups, etc.

Thanks in advance

[Nic Brough -Adaptavist- · Accepted solution]

If you are using a server or DC version install, then the simple answer is "don't look at the database".  It's a data store, not a real datbase, just a complete mess when you come to reporting off it.

Use the REST API.  It's faster and easier to understand.

[Gail]

Thanks!!

[Dirk Ronsmans · Accepted solution]

Hey @Gail ,

You tagged this question as jira-software-cloud. On Cloud you don't have access to the database directly.

The best alternative would be to use the REST api to "query" for some of the information you want.

You can find details about the endpoints here: https://developer.atlassian.com/cloud/jira/platform/rest/

[Gail]

Thanks so much -- I wondered about that.   :)