Your new metric definition will create metric instance for only new incidents from now.
If you want metric instance to be created for old incidents, then please run below fix script.
/*jslint eqeq: true, undef: true, sloppy: true, vars: true */
/*global gs, GlideRecord*/
var definition = new GlideRecord('metric_definition');
definition.get(event.parm1);
definition.query();
if (definition.next()) {
var targetRecord = new GlideRecord(definition.table);
targetRecord.orderBy('sys_created_on');
gs.log(definition.name + ': Query against the target table(' + definition.table + '): ' + targetRecord.getEncodedQuery(), 'historic.metric.instances');
targetRecord.addQuery('sys_created_on', '>', definition.u_create_metrics_after);
targetRecord.query();
while (targetRecord.next()) {
var audit = new GlideRecord('sys_audit');
audit.addQuery('documentkey', targetRecord.sys_id.toString());
audit.addQuery('fieldname', definition.field);
audit.orderBy('record_checkpoint');
audit.query();
while (audit.next()) {
try {
var arrOfFields = [];
var count = new GlideAggregate('sys_audit');
count.addQuery('documentkey', targetRecord.sys_id.toString());
count.addQuery('record_checkpoint', audit.record_checkpoint);
count.addAggregate('COUNT', 'fieldname');
count.query();
while (count.next()) {
arrOfFields.push(count.fieldname.toString());
}
arrOfFields = '[' + arrOfFields + ']';
var gdt = new GlideDateTime();
gdt.addSeconds(audit.record_checkpoint * 120);
gs.eventQueueScheduled('metric.update', targetRecord, arrOfFields, audit.record_checkpoint, gdt);
} catch (e) {
gs.log('generateScriptedMetrics against ' + current.number.toString() + ' for ' + definition.name.toString() + 'Error: ' + e, 'historic.metric.instances');
}
}
}
}
Regards,
Sachin
