It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

SLA Time for resolve

I need to create report for my  client  with time spent for resolve issue. With standard SLA in Jira Service Desk i can only show him time left to Goal, using to this colum Time to resolve. Does anybody have idea how to report time spent on issue? Mayby I can get this information from database? Does anybody made something like this?

2 answers

0 votes


What do you mean by time spent? Do you mean you want to sum up all logged work? If so, you can use Jira Rest Api for it:

GET /rest/api/2/issue/{issueIdOrKey}

Hi Tomasz,

You can use Jira Service Desk built-in reports or customize it as you want:2018-09-17 10_44_31-Service Desk.png

@Gregor Kasmann @Alexey Matveev [cPrime] 

I am currently creating a report for the client by exporting a filter to CSV / HTML. To show that we have not exceeded the SLA, I display the Time to Resolve column in the report. The client wants me to add a column that will show how much time it took me to solve the issue. In a word, I need the Actual value in the report.


Hi did you resolved this problem? Actually we have the same

Hi @Jorge Jerez ,y

I created report with powershell using Jira REST API. Display your SLA ticket via REST API (yourjira.domain/rest/api/latest/issue/ISSUEKEY) and find SLA field, there are all needed information about sla time, like remaining time, spent time and SLA goal. Ofcourse you can use another language for create raport, I used PS becouse i know this language and it's realy easy to lern

Thanks, we're working to develop something similar but getting the data directly from database

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira

Demo Den Ep. 7: New Jira Cloud Reports

Learn how to use two new reports for next-gen projects in Jira Cloud:  Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...

261 views 1 2
Join discussion

Community Events

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

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you