Change Approval History (Duration by Approver Name)

[CheshireKat]

Hello there. I am trying to identify the length of time a change is with a specific approver from created to closed. The approval history field may include multiple approvers per change and the approval date only references the last person to approve the change, but not the previous individuals. Any recommendations on how to break this data out by individual approvers as it goes through the change workflow?

[Pratiksha Kalam · Accepted solution]

Hi  CheshireKat,

1. Navigate to Workflow > Administration > Properties.
2. Select the Yes check box for the Log User approval activity - such as requested, approved and rejected - in the Approval History journal when using workflows to manage the approvals for a task. property.
3. Click Save.

Also go through this document link,

https://www.servicenowguru.com/scripting/change-management-workflow-approval-scripts-servicenowcom/

If my answer is help you solve your problem please mark it as correct.

Regards,

Pratiksha

[CheshireKat]

Thank you! 🙂