MTTR report on Change Request table

Bhavani13
Tera Contributor

Hi,

 

Can we create MTTR report on Change Request table? If yes, could you please tell me how we can achieve it.

 

Thanks in Advance!

 

Thanks,

Bhavani.

1 ACCEPTED SOLUTION

AndersBGS
Tera Patron
Tera Patron

Hi @Bhavani13 ,

 

In general on a change request you have the created date/time and resolved date/time. due to this, you can create a "function field" to calculate the MTTR: 

 

Created date/time and closed date/time

AndersBGS_0-1702976484330.png

 

Create function field:

AndersBGS_1-1702976517860.png

 

 

Change request MTTR:

AndersBGS_2-1702976593765.png

 

Add the new column to the table:

AndersBGS_3-1702976660641.png

 

Press "run":

AndersBGS_4-1702976684035.png

 

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

 

Best regards

Anders 

 

 

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

3 REPLIES 3

Community Alums
Not applicable

HI @Bhavani13 ,

Unfortunately No!!

AndersBGS
Tera Patron
Tera Patron

Hi @Bhavani13 ,

 

In general on a change request you have the created date/time and resolved date/time. due to this, you can create a "function field" to calculate the MTTR: 

 

Created date/time and closed date/time

AndersBGS_0-1702976484330.png

 

Create function field:

AndersBGS_1-1702976517860.png

 

 

Change request MTTR:

AndersBGS_2-1702976593765.png

 

Add the new column to the table:

AndersBGS_3-1702976660641.png

 

Press "run":

AndersBGS_4-1702976684035.png

 

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

 

Best regards

Anders 

 

 

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Bhavani13 

 

MTTR is mainly used for Incident not for change. For the change, you can create or use report to see how much time a change take from New - Assess - Auth - Schedule etc.

 

For this please check the metrics table.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************