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

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to find out who created a sprint?

We have a sprint that has a very generic name and the tickets associated with it span multiple projects and boards.  Multiple teams appear to be claiming ownership of it, but I have not been able to find out who created the sprint.  The ticket history will tell me who added the tickets to the sprint, but now who created it.  Any ideas?

4 answers

1 accepted

3 votes
Answer accepted
cgauterio Atlassian Team Mar 18, 2015

Hi CJ,

I'm afraid that information is not stored in JIRA. I took the liberty of creating an improvement regarding this request at: https://jira.atlassian.com/browse/GHS-11871

Please add yourself as a watcher to be notified of future updates.

Cheers,
Clarissa.

Thanks Clarissa!

Super Clarissa :)

The answer from similar question (Jira Agile non-active sprint creator and created date) can give you some information.

Thanks Florjan! My results are a little troubling. The name of the sprint has changed, so I used the entitytype & entityid instead. This returned 38 results, and the earliest dated result was for a user who has no permissions to create the sprint.

I am not sure but I assume that the first entry in the "userhistoryitem" for the sprint's "rapid_view" represents the creator?

/* Find Sprint creator */
DECLARE @SPRINT BIGINT
--
SELECT @SPRINT = 5416
--
SELECT TOP 1 UH.ID, SP.NAME sprintname, USERNAME creator
FROM [My_Jira].[dbo].[userhistoryitem] UH
INNER JOIN [My_Jira].[dbo].[AO_60DB71_SPRINT] SP WITH(NOLOCK) ON UH.ENTITYID = CAST(SP.RAPID_VIEW_ID AS NVARCHAR)
WHERE SP.ID = @SPRINT;

No. This shows who last viewed it or had started the sprint or accessed the board (neither the sprint).

Maybe you can find out where the sprint was created.

You just need to have the sprint ID and then use rest api:

/rest/agile/1.0/sprint/{sprintID}

This rest api will provide you the originBoardId of the sprint

After that, you can search for the board using rest api to get the name of the Board.

rest/agile/1.0/board/{boardID}

After that, you can search who is the owner(s) of that Agile board and for sure these people should be the ones that created the sprint :)

Hello, 

I cannot see the owner of the agile board nor the creator of the sprint.

The whole information i can get from /rest/agile/1.0/sprint/{sprintID} : 

  •  "id":111,    "self""https://axxxx.atlassian.net/rest/agile/1.0/sprint/111",    "state""active",    "name""Sprint test",    "startDate""2020-09-21T07:25:54.812Z",    "endDate""2020-09-28T07:25:00.000Z",    "originBoardId"222,    "goal"""

and the whole information i can get from rest/agile/1.0/board/{boardID} : 

  • "id"222,    "self""https://xxxx.atlassian.net/rest/agile/1.0/board/283",    "name""Tablerotest",    "type""scrum",    "location": {        "projectId"124255,        "displayName""EjemploAgile",  "projectName""Ejemplo SDLC Agile",        "projectKey""AwE",        "projectTypeKey""software",        "avatarURI""/secure/projectavatar?size=small&s=small&pid=124255&avatarId=1255",        "name""Ejemplo SDLC Agile (awe)"    }}

 

P.D (I am using jira cloud )

@Jose Luis Casarrubias   can you specify please how you was able to get the sprint creator or the owner of an agile board ? 

 

Thank you ,

Abdel

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

How to create Jira issus from Excel file?

When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...

4,431 views 22 32
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you