Report on Incidents without Response SLA

[kumar22]

Hi team, 

As per the current behavior in the system, while creating Incidents if we select the Assignment Group and Assigned to the Response SLAs are attached to this type of Incidents.

Now I would like to create a report that gives the list of Incidents which has no Response SLAs.

Please advise on this!

Thanks,

[Dr Atul G- LNG]

SO create a normal report on Inc table

where Assigned to is empty and Assignment group is empty

[AndersBGS]

Hi @kumar22 ,

Just run the report created through the report designer as below:

Remember:

1. Report is based on the incident table
2. Related list condition - greater than or equal should be set to "0"
3. Apply any other conditions that you would like.

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders 

[kumar22]

Hi All, 

I achieved this by using the fix scripts and it is working fine and gives the proper details while running through the fix scripts. But I moved the code to Script include which gives a single record only. 

Fix script:

var inc = new GlideRecord('incident');

inc.addActiveQuery();

inc.query();

while(inc.next()){

var tsla = new GlideRecord('task_sla');

tsla.addQuery('task', 'inc.sys_id');

tsla.addEncodedQuery('sla.target=response');

tsla.addEncodedQuery('sla.target!=resolution');

tsla.addEncodedQuery('sla.target!=NULL');

tsla.query();

if(!tsla.hasNext()){

var incArray = [];

incArray.push(inc.number);

gs.print(inc.number);

}

}

--------------------- 

Script Include:

function INC_without_response_sla() {

    var inc = new GlideRecord('incident');

    inc.addActiveQuery();

    inc.query();

    while (inc.next()) {

        var tsla = new GlideRecord('task_sla');

        tsla.addQuery('task', 'inc.sys_id');

        tsla.addEncodedQuery('sla.target=response');

        tsla.addEncodedQuery('sla.target!=resolution^ORsla.target=NULL');

        tsla.query();

        if (!tsla.hasNext()) {

            var incArray = [];

            incArray.push(inc.number);

            return incArray;

        }

    }

---------------------

Can someone help with this?

Thanks in advance!!

@Dr Atul G- LNG 

[Dr Atul G- LNG]

Hi @kumar22 

I am not sure buddy, why you are using script, when you can achieve this OOTB way, as suggested by many other community members.