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.

Change approval history

vivianlowra
Tera Contributor

Hi,

 

Can someone please help me on how to create a report to track the duration a change request is with approvers?

 

Thanks for your help in advance!!

2 REPLIES 2

Rohit  Singh
Mega Sage

Hi @vivianlowra 

 

There is a field on the task table called "approval_set". This should be populated with a date/time when a record has been approved and  corresponding to your change_request Record .

You can report on the span from the field opened.

 

You can also create a metric to calculate the duration for easier reporting.

RohitSingh_0-1744039292608.png

 

 

If my response helped, please hit the Thumb Icon and accept the solution so that it benefits future readers.

 

Regards,
Rohit

Hi @vivianlowra ,

 

Did you check my response?

 

If my response helped, please hit the Thumb Icon and accept the solution so that it benefits future readers.

 

Regards,
Rohit