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?
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.
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;
Hey admins! I’m Dave, Principal Product Manager here at Atlassian working on our cloud platform and security products. Cloud security is a moving target. As you adopt more products, employees consta...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs