Sprint started by and Ended by details in database

[Madhu Kiran Yalamanchili]

In Jira database, where do i find Sprint Started By and Sprint Ended By details?

In my instance for all agile reports like sprint report, BurdDown Chart, Velocity chart, i dont see values from Started By and Ended By

[YY Brother · Accepted solution]

SELECT from_unixtime(ae.TIME / 1000, '%Y-%m-%d'), cu.display_name, ae.ID, ae.`DATA`
FROM ao_60db71_auditentry ae
INNER JOIN app_user u ON u.user_key = ae.`USER`
INNER JOIN cwd_user cu ON cu.user_name = u.lower_user_name
WHERE ae.CATEGORY = 'SprintOpenClose'
AND ae.entity_class = 'SPRINT' AND ae.entity_id = 311
ORDER BY ae.TIME ASC;

NOTE: 311 refers to the sprint id.

[Mohamed Riza _ServiceRocket_]

Hi @Madhu Kiran Yalamanchili 

This is present in the AO_60DB71_SPRINT table in the database. You have a column there for start date and completed date. The times are in epoch time, so you would need to convert this using a tool like https://www.epochconvert.com/. Of course you would not be able to tell which board the sprints are coming from, therefore you will need to join this with the AO_60DB71_RAPIDVIEW table. 

[Madhu Kiran Yalamanchili]

I am not looking for Start Date and End Date, i am looking for Started by and Ended By. 

Please check attached screenshot.