Is there a way to extract or pull JIRA ticket history

[Krithica G]

Is there a way to extract or pull JIRA ticket history in excel?

[Carlos Garcia Navarro]

Hi @Krithica G ,

You could use this API call to get the changelog per issue: https://<your Jira URL>/rest/api/2/issue/<your issue key>?expand=changelog, and then you can convert the output to excel.

[Ioana]

Hi Krithica,

Unfortunately there is no built-in functionality for that. There is an open feature request here that you can vote for: https://jira.atlassian.com/browse/JRASERVER-38896

However, you could check the add-ons available that provide this functionality:

• https://marketplace.atlassian.com/apps/1217389/issue-history-printer-for-jira?hosting=server&tab=overview 
• https://marketplace.atlassian.com/apps/1212652/better-excel-exporter-for-jira?hosting=server&tab=overview 

Regards,

Ioana

[Iryna Ihnatiuk]

Hi @Krithica G,

Please take a look at Issue History Collector add-on. This app enables you to view Issues duration by assignees and statuses. Using Issue History and Assignee History Statistics Reports, you can see and export the date when each issue was moved to the necessary status and how much time was spent in each state.

Feel free to reach out support team if you need further information.

Kind Regards,
Iryna