Jira Server Exporting the History Log for Issues

[Darla Sheehan]

Have a customer that is not a fan of the Time in Status plugin. Is there a way that the history logs for tickets can be exported into a file that can be manipulated? Wants to report the time in status by issue types.

Any suggestions appreciated.

Thanks!

[david]

Hello @Darla Sheehan with Exporter (App for Jira Server) you can export an Excel file that you can manipulate and also adding the Transition Log that among other information includes the time in every Status.

Cheers,

David

[Darla Sheehan]

Thanks David! That also looks like a good option if they are not confident going the DB route.

[Alexey Matveev]

Hello, 

You can export changegroup and changeitem tables in the Jira database and manipulate with this information. These are tables where the history is stored. 

[Darla Sheehan]

Thanks Alexey! I thought that might be the case. 

I have also added a vote to this wonderfully old request - https://jira.atlassian.com/browse/JRASERVER-38896