Need help with Jira dB query

[Kumar]

1. 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

[Earl McCutcheon]

Hello @Kumar ,

When it comes to the Board Reports the data is calculated for the reporting and indexed as needed.  The report itself does not exist as a separate element and is calculated on each page load based on the current data. 

With that said if you wanted to recreate the sprint report data using sql you would need to look at each element the report is generating independently.  I recomend checking out the following threads where other users had similar questions and the listed documentation that go into more detail on how to look at the sprint details and history items:

• https://community.atlassian.com/t5/Jira-questions/SQL-for-getting-all-issues-related-to-a-sprint/qaq-p/663162
• https://community.atlassian.com/t5/Jira-questions/Get-issues-by-sprint-from-database/qaq-p/422957
• https://community.atlassian.com/t5/Answers-Developer-Questions/SQL-When-was-issue-added-to-sprint/qaq-p/520487
• How to Retrieve Sprint History of an issue from JIRA Database

Regards,
Earl

[Kumar]

Hello @Earl McCutcheon 

Thanks for your clarification I understood now and also I have a small question ? So I have a Group say it as “Group 1”  It’s been created long back so I have like more than 500+ projects in our jira  

so is there any possibility to check on which projects this group has been using from DB ? if yes, can your please help me with the query

Thanks,

kumar

[Earl McCutcheon]

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

[Earl McCutcheon]

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

[Kumar]

@Earl McCutcheon  thanks you thanks for your response again.

Thanks,

kumar