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.

How to recaluate the Start date in historical records after fixed the OOTB MetricInstance script?

bbf35621
Kilo Sage

Happy Friday guys

 

We just reverted the OOTB MetricInstance script include to the base version because a previous developer edited it, causing the Start column timestamp in the OOTB Incident State Duration to be the same as the ticket's creation date. Now it is calculating correctly from now forward. However, I want to create a fix script to rerun the historical incident records by recalculating the Start column into the correct one in Incident State Duration. Has anyone successfully done that and can share the script?

0 REPLIES 0