I believe the follow SQL query may return what you're after:
SELECT username,lastviewed,data FROM userhistoryitem WHERE data = 'Name of Sprint';
Based on some limited testing, the 'lastviewed' entry gives the date/time the sprint was created in milliseconds and username reflects who created the sprint.
Edit: I usually use http://www.epochconverter.com/ to convert milliseconds to something human-readable. :wink:
Thank you! Florjan The last version of the sql query (oracle): select id, username, data sprint_name, to_timestamp_tz('1970-01-01 Europe/Vienna', 'yyyy-mm-dd tzr')+ numtodsinterval(lastviewed/1000,'second') created from userhistoryitem where dbms_lob.compare(data, to_clob('2015 01-02')) = 0;
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
userhistorydata is tricky. It only stores one record per user and sprint. As long as the creator is the only person editing the sprint name, the changed_timestamp will remain the creation date.
more info and for a more complex sql see also: https://community.atlassian.com/t5/Jira-questions/SQL-How-can-I-find-who-opened-a-Sprint/qaq-p/588838#M364070
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...
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