Hello,
I was wondering if there is any way to get the total time an issue has spent in an SLA, including cycles.
For example, we have an SLA called "Time to resolution" that stops on all statuses in the 'Done' category, pauses on 'Waiting for Customer', and starts on all other statuses. We also have the ability to reopen issues if the solution is rejected by the customer, causing multiple cycles. We want to know the total time it takes to fully resolve and close the issue (solution accepted by customer) without counting the time it sits waiting for customer or outside of the business week calendar. Summing the time spent in "Time to resolution" across all cycles is perfect for that.
Is there any way (in JIRA Service Desk, through a plug-in, through custom scripting, or through a DB query) to get that information?