Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Is there a way to list all active sprint names on all projects in the jira instance

I want a list of all active sprints in jira from all projects.  As admin there are times when a scrum master does not start the sprint on time and I need a way to identify those team's that are delayed.  

If I were writing the query in a SQL language, pseudocode would be something like this:

      Select sprint name from all Jira projects where active sprint is true

I know this doesn't exist in Jira, but there has to be a way to produce a list of all active sprint names in Jira.

Any help would be appreciated.


2 answers

1 accepted

1 vote
Answer accepted
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Oct 31, 2022

What exactly do you mean by "active" sprints? If you choose "Active Sprints" from the navigation pane of a Scrum board, what you get is the board view that shows sprints that have been Started. Are those the sprints you want? Not the ones that have already ended, or the ones that have not yet been started?

How do you know the scrum master hasn't/didn't start a given sprint on time?

Do you need other information about the sprints?

All the search capabilities in Jira are oriented around finding issues. You could use a JQL such as

sprint in openSprints()

to get a list of all issues in Active (started) sprints. You could feed that information into the Two Dimensional Statistics gadget to get a list of issues per sprint, which would give you the list of sprints.

However, that works on the assumption that every started sprint has at least one issue in it that is visible to you. If Issue Security is enabled then some issues may be hidden from you. Or if you don't have Browse Projects permission for some projects then sprints associated with the issues in those projects would be hidden from you.

openSprints() gives you issues in started sprints. Addition functions are closedSprints() and futureSprints().

This is complicated by stories that are not completed and move on to a subsequent sprint. The gadget will show all sprints listed in the issue including closed sprints. This pollutes the gadget with closed sprints.

Any ideas?

Suggest an answer

Log in or Sign up to answer
Site Admin
AUG Leaders

Atlassian Community Events