Have you looked into using Metrics? You could only report on modifications after you have set this up but it will work.
- Create a new Metric Definition and name it Track Updates. Here is a screenshot. Make sure you have on the Incident Table, Field is Updated.
- Create a Business Rule on the Incident Table.
On the Advanced tab enter the following script:
(function executeRule(current, previous /*null when async*/) {
var definition = new GlideRecord('metric_definition');
definition.addQuery('name','=','Track Updates');
definition.query();
if (definition.next()) {
var mi = new MetricInstance(definition, current);
var gr = mi.getNewRecord();
gr.field_value = current.sys_updated_by;
gr.field = null;
gr.calculation_complete = true;
gr.insert();
}
})(current, previous);
Now on every update a new metric instance is created with the name of the person who made the change. You can not use the normal reporting you do for metrics to report on who changed, how many times, etc.
