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 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;
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
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot