Create a Metric on task_sla table

[Natsufab3]

I want to create a metric on task_sla table. This table contains has_breached field. When ever that field is true, I want to capture the assignment group at that particular time when the SLA is breached.

I have created a metric on Task_sla table and struck up at the scripting part.

Any help is appreciated.

Thank you.

[davidpanson]

Read this:

http://wiki.servicenow.com/index.php?title=Metric_Definition_Support#gsc.tab=0

It contains sample scripts. All you need to do is customize an example. Make it run for tasks sla table and change the filter conditions. starting with one of the examples:

set the glide record query to task sla

var gr = new GlideRecord('task_sla')

and query for has breached

gr.addQuery('has_breached', true);

then of course change what you want it to do. Getting assignment group should be easy.

var result = gr.assignment_group // or skip the var

[Natsufab3]

Hi David,

var gr = new GlideRecord('task_sla');

  gr.addQuery('has_breached', true);

  gr.query();

    while (gr.next()) {

    var gs = new GlideRecord('metric_definition');

var result = gr.assignment_group;

Something like the above. Please correct me if I am wrong

[davidpanson]

Yes your query should run. Although Unless you're using it somewhere else you don't need the gs variable. And you still need to do whatever you wanted to do with the assignment group. gs.addInfoMessage() will display it immediately or gs.log() can send it to a log file. but in what you pasted result is not used. Just to be clear. but it should contain the correct value.

var gr = new GlideRecord('task_sla');

  gr.addQuery('has_breached', true);

  gr.query();

    while (gr.next())

{

        var result = gr.assignment_group;

}

[davidpanson]

Also If Assignment_group is stored as an ID then adding gr.assignment_group.getDisplayValue() will show you the string you'd expect instead of the long ID value. something like one of these guys "23dc968f0a0a3c1900534f399927740e"