Metric - Updates to cases per person

[sanjeevkalia]

Hi All,

I want a new Metric to be created within ServiceNow   that tracks updates to cases per person.

I want to apply this to the task table so that all task records can be reported against for this metric. It would be good if this metric can be applied to existing records retrospectively.

Is this possible via a custom script?

[sanjeevkalia]

I ended up creating a new filed called updated(u_updated) on 6 extended tables that extended the task table.

Created a business rule on each table to update this field every time   a change is made to the record.

The used Micheal's script on this field in a metric.

Thanks Michael.