Need help with Jira dB query

Question

* Hello All,

Is there any way to get Sprint report the from Jira dB by running the DB query. If Yes can any body help me with the query.

when we select the report like scrum, velocity , burndown etc,. From the project report section it will give us all the details of that report so I would like to export that report from Jira we don’t have an option it export it so if we can generate the sprint report exactly from db so that we can export it from db

can anybody help me with the db query

Thanks,
kumar

Kumar_ow8zf3 · Answer

@Earl McCutcheon  thanks you thanks for your response again.

Thanks,

kumar

Earl McCutcheon · Answer

Also, to add in on this the above KB queries are going to be focused on the Groups assigned to project roles, check out the following thread that gives an example of how to look at the permission schemes directly where a group was assigned directly to a permission rather than a project role and there is a good example of how to get group associations to the permission schemes directly:

* https://community.atlassian.com/t5/Jira-questions/SQL-How-to-query-JIRA-s-permission-schemes/qaq-p/284182

Regards,
Earl

Earl McCutcheon · Answer

Hi @Kumar ,

Happy I could help out and for your follow up question we have the following KB articles with some EXE queries you can use for this:

* "How to identify which Groups have access to a Project in JIRA" 
* "Retrieve a list of users assigned to project roles in Jira server" 
* "How to identify group usage in JIRA"

Regards,
Earl