question Re: Creating Metric Instances through Scheduled jobs in Developer forum

Creating Metric Instances through Scheduled jobs

julienr — Wed, 07 Sep 2016 12:09:02 GMT

Hello everyone.

So, for reporting reasons, I need each first day of the month to create a new metric instance from a specific definition.

So of course I thought of creating a scheduled job, but for some reason it goes through everything but my instances are not created...

Would anyone have an idea as to where I'm taking a wrong turn?

Thank you so much.

here's my code:

createMetricInstances();

function createMetricInstances(){

var value = 'FollowUp Indicator not breached';

//Query on the task sla table to know exactly how many instances I need to create

var gr = new GlideRecord("task_sla");

gr.addQuery("sla", "37b3b0ea3774e600894b98a543990e29");

gr.addActiveQuery();

gr.query();

while (gr.next()) {

// Here I tried several ways to pass values to definition and current. Nothing worked

var newmi = new MetricInstance('c083fcaa3774e600894b98a543990e48', gr);

/*var mi = new MetricInstance(def, gr);

var newmi = mi.getNewRecord();

newmi.definition = 'c083fcaa3774e600894b98a543990e48';

newmi.id = gr.sys_id;*/

var now = new GlideDateTime();

newmi.start = now;

if (gr.has_breached == 'true'){

value = 'FollowUp Indicator breached';

}

newmi.value = value;

newmi.insert();

//I've set a serie of logs here and there which I erased here for easier reading - They all log correctly...

}

Re: Creating Metric Instances through Scheduled jobs

Kalaiarasan Pus — Wed, 07 Sep 2016 12:34:33 GMT

Anyway pasting this here as well.

Re: Need help to create metric using the Updated by field.

Re: Creating Metric Instances through Scheduled jobs

julienr — Wed, 07 Sep 2016 13:02:33 GMT

So, I managed to solve this using a related conversation I found: The script is aimed to be a scripted scheduled job and is functional

createMetricInstances();

function createMetricInstances(){

var value;

var def = 'c083fcaa3774e600894b98a543990e48';//Replace value with the MetricDef you want to instanciate

var gr = new GlideRecord("task_sla");

gr.addQuery("sla", "37b3b0ea3774e600894b98a543990e29");//Replace value with the sla definition sys_id

gr.addActiveQuery();

gr.query();

//gs.log('JU:Scheduled job found '+gr.getRowCount()+' rows');

while (gr.next()) {

value = 'FollowUp Indicator not breached';

var newmi = new GlideRecord('metric_instance');

newmi.initialize();

newmi.definition = def;

newmi.id = gr.sys_id;

newmi.start = gs.nowDateTime();

if (gr.has_breached == true)

value = 'FollowUp Indicator breached';

newmi.value = value;

newmi.insert();

}

Re: Creating Metric Instances through Scheduled jobs

jleyco — Tue, 15 Nov 2016 20:25:54 GMT

This was very helpful!

However, I was wondering how you would modify this to NOT create a metric instance if there is already one for that 'ID' and metric definition?

Re: Creating Metric Instances through Scheduled jobs

Kalaiarasan Pus — Tue, 15 Nov 2016 20:27:56 GMT

You can find that in the original link provided. I would have checked if the record already exists before inserting a new record.

Re: Creating Metric Instances through Scheduled jobs

jleyco — Tue, 15 Nov 2016 20:33:05 GMT

Thanks, Kalaiarasan! But I'm not sure how to apply that logic to my Scheduled Script Execution below. Could you advise?

Basically I created a new metric definition to calculate the Create to Close duration of catalog tasks. This metric definition works fine for newly closed catalog tasks, but it does not apply to 'previously' closed catalog tasks. The below script runs fine, but I am currently limiting it to 10, just to see how it works. I also want to ensure that it does not create any 'duplicate' metric instances.

createMetricInstances();



function createMetricInstances(){

   var value;

   var def = 'a1e2781f131d22000a2033076144b0c5';//MTRC0010006 Create to Close Duration of Catalog Tasks

   var gr = new GlideRecord('sc_task');

   gr.addQuery('closed_at', '<=', '2016-10-31 00:00:00');

   gr.setLimit(10);

   gr.query();

   gs.log('Created to Close Duration of Closed Catalog Tasks scheduled job found '+gr.getRowCount()+' rows');

   while (gr.next()) {

   var newmi = new GlideRecord('metric_instance');

   newmi.initialize();

   newmi.definition = def;

   newmi.id = gr.sys_id;

   newmi.start = gr.sys_created_on;

   newmi.end = gr.closed_at;

   newmi.duration = gs.dateDiff(gr.sys_created_on.getDisplayValue(), gr.closed_at.getDisplayValue());

   newmi.calculation_complete = true;

   newmi.field = 'State';

   newmi.insert();

   }

}

Re: Creating Metric Instances through Scheduled jobs

Kalaiarasan Pus — Tue, 15 Nov 2016 20:37:14 GMT

function createMetricInstances(){

var value;

var def = 'a1e2781f131d22000a2033076144b0c5';//MTRC0010006 Create to Close Duration of Catalog Tasks

var gr = new GlideRecord('sc_task');

gr.addQuery('closed_at', '<=', '2016-10-31 00:00:00');

gr.setLimit(10);

gr.query();

gs.log('Created to Close Duration of Closed Catalog Tasks scheduled job found '+gr.getRowCount()+' rows');

while (gr.next()) {

var newmi = new GlideRecord('metric_instance');

newmi.addQuery('definition',def);

newmi.addQuery('id',gr.sys_id);

newmi.query();

if(!newmi.next())

{

newmi.initialize();

newmi.definition = def;

newmi.id = gr.sys_id;

newmi.start = gr.sys_created_on;

newmi.end = gr.closed_at;

newmi.duration = gs.dateDiff(gr.sys_created_on.getDisplayValue(), gr.closed_at.getDisplayValue());

newmi.calculation_complete = true;

newmi.field = 'State';

newmi.insert();

}

Re: Creating Metric Instances through Scheduled jobs

jleyco — Tue, 15 Nov 2016 22:36:50 GMT

Thanks so much, Kalai!

Re: Creating Metric Instances through Scheduled jobs

Community Alums — Wed, 13 Dec 2017 20:37:48 GMT

Thank you guys! worked perfectly for me.