Get MTTR from Incident Table

[Rakshanda Kunte]

Hi All,

I am working on a dashboard for Incident data.

Requirement is to see MTTR for P3 and P4 Incidents which can be gathered from 'incident_metric' table.  

However, is there anything on Incident form from which we can calculate MTTR?

Thanks..!!

[Musab Rasheed]

There is nothing OOB hence OOB incident metric table was introduced, however you can customize something on Incident form but it's just a waste of time since OOB servicenow has already provided alternate solution.

[Dr Atul G- LNG]

Hi @Rakshanda Kunte 

https://www.servicenow.com/community/platform-analytics-forum/incident-sla-and-mttr/m-p/1206721

https://www.servicenow.com/community/platform-analytics-forum/how-to-create-mttr-report-for-incident...

[AndersBGS]

Hi @Rakshanda Kunte ,

Why not utilize the OOTB field "resolve time":

This will give you the time to resolve - or is it something else that you're looking for?

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders 

[Rakshanda Kunte]

@AndersBGS 

Thanks for your input. I am looking for something like this only. 

Is this time is seconds? (seems to be in seconds).