How to create a report showing the time a change approval task is sitting with a user?

RonanB
Kilo Contributor

Hi all,

 

I am noticing that certain users / approval groups are taking a long time to approve changes assigned to them so I was hoping to setup a report to show long a change approval task is sitting there unactioned for the last 30 days.

 

We have three different active Business Services with different approval workflows so ideally I would like a separate report for each.

 

Any suggestions or help would be greatly appreciated?

 

Thanks,
Ronan

 

5 REPLIES 5

RonanB
Kilo Contributor

Hi,

 

Any help here would be great?

 

Regard,

Ronan

Rob66
Tera Expert

metric_instance table definition= Change Approval

deepti mediratt
Tera Contributor

Hello,

 

I have a similar requirement . Just checking if you have any solution ?

 

Thanks,

Deepti

my suggestion above gives the data..  its just not very user or report friendly eg... its easier to get time from a record than it is this table... but maybe it'll be useful for your situation

 

metric_instance table

definition= Change Approval