How can we check how many sprints has been created under a project in JIRA

[Abhishek Gupta]

How can we check how many sprints has been created under a project in JIRA?

I am checking the Backlog page, but on that page all the sprints are not listed. Some are missing.

I also checked in Sprint Report Dropdown, that aslo does not have all the sprint name which we have created.

[somethingblue]

Hi Abishek,

The Sprint Report should show you all the Sprints associated with the board's filter for that Project.  Another option would be to query the AO_60DB71_SPRINT table for sprints. 

Again they are associated with the Board and there is a column titled NAME that you can use in your query to find the sprints associated with the board for your project, e.g.:

select * from "AO_60DB71_SPRINT" where 'NAME' like '%PORPROJ%'

Cheers,

Branden