Can you please share how MTTR(between sys_created_on and resolved_at) is calculated in incident?

neehas
Tera Expert
 
3 REPLIES 3

Not applicable

To calculate MTTR (Mean Time to Resolve) in incidents, we look at the difference between the resolved_at and sys_created_on dates for each resolved incident, then take the average of those times. For example, you can use this small script to get it:

var gr = new GlideAggregate('incident');
gr.addNotNullQuery('resolved_at'); // only include resolved incidents
gr.addAggregate('AVG', 'date_diff(resolved_at, sys_created_on)');
gr.query();
if (gr.next()) {
  gs.print('MTTR in seconds: ' + gr.getAggregate('AVG', 'date_diff(resolved_at, sys_created_on)'));
}

Ankur Bawiskar
Tera Patron

@neehas 

Please refer below links:

If my response helped please mark it correct and close the thread so that it benefits future readers.