nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to find out who created a sprint?

CJ Millican

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?

Accepted answers

cgauterio

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.

All comments

cgauterio

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.

CJ Millican

Thanks Clarissa!

Vidic Florjan

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

CJ Millican

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.

Bernd Prager

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;

unknown

Super Clarissa

Jose Luis Casarrubias

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

Junio Fernandes

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

Abdel_iepqnq

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-software

jira-administration