get information with sql query Jira DC

[Nairi salma]

Hi

could you please help as to get those informations with sql query

thanks a lot

project

users

User's role

User's group

Project Category

[Ankit Srivastava]

Hi @Nairi salma ,

Greetings of the day!

Could you please refer the below document for same:

1. https://confluence.atlassian.com/jirakb/how-to-find-or-view-an-issue-from-the-database-with-sql-queries-in-jira-744524576.html

2. https://confluence.atlassian.com/jirakb/how-to-identify-group-usage-in-jira-441221524.html

3. https://support.atlassian.com/analytics/docs/schema-for-jira-software/

and also I just get to know that Jira Data Center (DC) itself doesn't store project categories directly in a single, dedicated table within its database.

Hope this will help.

Thanks,
Ankit Srivastava

[Nairi salma]

thanks

informations are stored on these tables nodeassociation , projectcategory