Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Metric definition

SB87
Tera Expert

How would you create a metric definition for a change that takes place outside its planned schedule?

 

3 REPLIES 3

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @SB87 

 

1 - When a change is planned, a planned schedule start and end date/time is set. If the change is performed outside of the agreed schedule, we need to report on the CHG number and the start/end date/time the release was actually performed.

Bonus points if you can calculate the duration between the proposed end time and the actual start time. 

Atul: You can get this list of report , by creating report on change, where Actual Start date is less than the Plan end date and for calculation , PA is right way or do in excel.

 

2 - When a change is planned, a planned schedule start and end date/time is set. If the change starts within schedule, but breaches the planned end date/time (overhangs), we need to report on the CHG number and the start/end date/time the release was actually performed.

Bonus points if you can calculate the duration between the proposed end time and the actual end time. 

Atul: You can get this list of report , by creating report on change, where Actual end date is greater than the Plan end date and for calculation , PA is right way or do in excel.

*************************************************************************************************************
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]

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

SB87
Tera Expert

Is it also possible to do the above with a scripted metric definition? If so, any idea how this can be achieved?

Many thanks.

Not sure, but give a try. It need a good code so avoid that.

*************************************************************************************************************
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]

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