Jira service management support history

[手塚 忍]

Jiraクエリ言語を使用せずに、Jiraサービス管理のサポート履歴をすべて簡単にエクスポートする方法はありますか？

[Natalia_Kovalchuk_SaaSJet_]

Hi 手塚 忍!

The easiest way to export history from JSM without using JQL is to use a third-party app from the Atlassian Marketplace. For example, you can try to use Issue History for Jira (Work Item History) app by SaaSJet team, which lets you:

• export data across your projects without writing complex JQL
• filter tasks (choose the needed projects, dates, users, etc.)
• get full task history (status changes, assignees, comments, etc.)
• export everything directly to Excel or CSV in a structured format

This is especially useful when you need a clear timeline of what happened with JSM tickets without having to manually dig into each one.

Hope this helps!

[Rahul_RVS]

Hi  @手塚　忍 

You can use Jira Rest Api's to pull this information and build your own custom solution.

However if you need detailed reporting to track changes for multiple issues, you may want to have a look at a mktplace app for the same.

We have built an app to extract changelog data in a simple and easy to use interface. The data can be exported to a CSV file as well.

It provides complete details of who changed the data, what was changed and when. 

Issue History Reports

Do give it a try.

Disclaimer : I am part of the app dev team

Exported file 

[Denise Lydia Ellis]

For a one-click full history export without JQL if you have more than 1000 JSM work items in your Jsm cloud site. Unfortunately, no there is no native solution for that.

Your alternative options are:

1. No JQL, and overcomes the 1000 JSM work items export at a time. Explore the Atlassian Marketplace for options. Use the free trial period if the is a one off exercise.
2. An API-based export. Unless you're an expert I won't classify that as easy, as you require API knowledge.
3. Take a full cloud backup. This captures everything (some limitations apply), but the output isn't user-friendly (XML files). What you'd need to do next really depends on how you plan to use the data.

[手塚 忍]

Hi Denise,

Thank you so much for your clear and helpful response!

I decided to go with your first suggestion and explore the Atlassian Marketplace. I have just requested our Jira admin to install the free trial of "Better Excel Exporter for Jira". This definitely seems like the most practical solution to export the full history neatly without requiring API knowledge.

I really appreciate your quick and accurate advice. Thanks again!

Best regards,
Shinobu Tezuka