We're using a Jira installation with Greenhopper in a test environment. During the test phase, all users have been given admin access despite my concerns. Now someone closed an active sprint I was working on; is there any way to find out when and by whom the sprint was closed?
Currently Greenhopper do not have the data to check who are the user close the sprint. I notice we have file a request to our developers to look on it, please see https://jira.atlassian.com/browse/GHS-6332. I recommend you to vote on it and add yourself as a watch list.
You can definately see when the sprint was ended (time and date) in the Burndown Chart in the Report area of your board.
Finding out who closed the sprint is a bit trickier. I tested closing a sprint in my GreenHopper Board hoping to see the event logged in either the project activity stream or my activity stream and no such luck. I also do not see the user associated with the event in any of the reports.
If only there were a way to configure greenhopper reports...
Hope this helps!
Below query can be used for finding the details of Closed date in Human readable format in MySql database
select ID,Name, FROM_UNIXTIME(Start_DATE/1000),FROM_UNIXTIME(COMPLETE_DATE/1000) as completed_dates from AO_60DB71_SPRINT where FROM_UNIXTIME(COMPLETE_DATE/1000) >= '2015-06-01' and closed = 1;
Actually in Sprint table date's are stored in Big Int format(20 digits may be) so need to change it using FROM_UNIXTIME
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