Find open sprints that don't appear in any project

[Lauryn Huffman]

I'm trying to hunt down some sprints that are appearing in the dropdown list as active, but I can't find them in any project. 2/3 sprints in question have no issues assigned. One sprint has issues assigned, and they're all resolved, but I still can't find the actual sprint in any project to close it. Both the board and the backlog for that project show no active sprints. I have administrator access so that shouldn't be the issue. 

[Dmitry Elsakov · Accepted solution]

Sprints belong to Board from where they were created. However, they also could be available on any other Boards through issues (Issue associated with Sprint -> Board Filter for retrieve that Issue -> Sprint displayed on Board).

The easiest way to get those Sprints - create dummy issue and associate it with that Sprint (select in dropdown), then create Board where this dummy issue would be displayed (even by creation filter with key, i.e. "key = <your dummy Issue>"), so that Sprints through your Issue would be displayed on that board. If you have administration rights, you could Close that Sprint from that Board... or you could delete it.

Other way to find parent Board is to look in Database (Rapid_View_Id field in <JIRA Schema>.<some instance number>_SPRINT table). Then you could open that Board by replacing Board ID in URL.

[Lauryn Huffman]

Creating the dummy board was the piece I was missing - worked perfectly, thank you so much!!