Metric for approval (sysapproval_approver) table to record state duration

[Arlen]

We need to capture how long each approval remained in any particular state. Sounds like a metric right? Well, creating the metric is easy enough, however, no metric instances are created even after logging demo incidents or change requests each with multiple approvals.
Here's the process:
1) Create a metric and from the table drop down choose Approval (sysapproval_approver)
2) Choose State from the field drop down and save the metric
3) Create a change or an incident record and add few approvers
4) Go back to the metric you created and observe that no instances have been added (there should be some)
5) Go to the approvers tab on the change or incident and approve or reject the approvals
6) Again, check the metric that you created and observe that there are no instances

Just wondering if we're missing something?

Any help is greatly appreciated 🙂

[creatiga]

This worked amazing!

[Dan Shores]

Hello -

Is anyone aware if we can get these results on the 'sysapproval_approver_metric' table similar to 'chage_request_metric'?

We are able to get field value durations on the 'change_request_metric' table which allows us to bring in fields from the change request as well as the metric instance, but it does not work for me on the 'sysapproval_approver_metric' table. Our approval duration metric works but only logs on the 'metric_instance' table where we can not even reference who the approval was assigned to.

Thank you,

Dan