SLA reporting in Excel

Tom Lister_fo1j4e

Hi

We would like to export SLA fields to Excel. All the past posts I've searched imply that service desk doesn't do this but they are not recent.

Is it still the case that basic Jira Service Desk doesn't export the SLA figures?

There are recommendations to use excel plugins.

Does anyone know if its possible to use scripted fields to expose the data?

Tom

Tom Lister_fo1j4e

FYI so far

I can access the SLA field in a scriptrunner Script Field

import org.apache.log4j.Logger
import com.atlassian.jira.component.ComponentAccessor

def log = Logger.getLogger("com.onresolve.scriptrunner.runner.ScriptRunnerImpl")
def customFieldManager = ComponentAccessor.getCustomFieldManager()

def fieldCF = customFieldManager.getCustomFieldObjectByName("Time for First Response")
log.info("++"+fieldCF)
def value = fieldCF.getValue(issue)
log.info(value)

return value //value.completeSLAData

However the content of the field is a complex JSON that contains all the information needed to process the SLA

SLAValue{completeSLAData=
[CompleteSLAData{calendarName=London, succeeded=true, goalTime=28800000, 
goalTimeUnits=some(SLAGoalRemainingTimeUnits{weeks=0, remainingDaysWithinWeek=0, 
remainingMillisWithinDay=28800000, breached=false}), elapsedTime=29308, 
remainingTime=some(28770692), 
remainingTimeUnits=some(SLAGoalRemainingTimeUnits{weeks=0, remainingDaysWithinWeek=0, 
remainingMillisWithinDay=28770692, breached=false}), startTime=2019-05-09T11:21:25.769Z, stopTime=2019-05-09T11:21:55.077Z}], 
timeline=Timeline{events=[TimelineEvent{date=2019-05-09T11:21:25.769Z, types=[START]}, 
TimelineEvent{date=2019-05-09T11:21:55.077Z, types=[STOP]}]}, 
ongoingSLAData=null, metricId=197, definitionChangeDate=2019-04-30T11:31:27.134Z, 
definitionChangeMsEpoch=1556623887134, 
goalsChangeDate=null, goalsChangeMsEpoch=null, goalTimeUpdatedDate=null, 
goalTimeUpdatedMsEpoch=null, metricCreatedDate=1542285649095, 
updatedDate=some(1557487315150)}

 

This will require some programming to decode. 

Are there features in the Service Desk API that can do that?