Count Incident

[Mushir]

write a background script for count incident which SLA has been breached

[Bhavya11 · Accepted solution]

Hi @Mushir ,

you can try below code to get the count 

var slaBreached =0;
var slaGr = new GlideAggregate("task_sla");
slaGr.addQuery("task.sys_class_name=incident^has_breached=true");
slaGr.addAggregate("COUNT");
slaGr.query();
while(slaGr.next()){
	slaBreached=slaGr.getAggregate("COUNT");
}
gs.print("Count incident which SLA has been breached "+slaBreached);

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

Thanks,

BK

[Runjay Patel · Accepted solution]

Hi @Mushir ,

You can use below script.

var slaBreached = 0;
var slaGr = new GlideAggregate("task_sla");

// Query for breached SLAs related to incidents
slaGr.addQuery("task.sys_class_name", "incident");
slaGr.addQuery("has_breached", true);
slaGr.addAggregate("COUNT");
slaGr.query();

// Fetch the count directly without looping
if (slaGr.next()) {
    slaBreached = slaGr.getAggregate("COUNT");
}

// Print the result
gs.print("Count of incidents with breached SLAs: " + slaBreached);

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

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

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

[Mushir · Accepted solution]

Hi Bhavya 

can you explain me sys_class_name  field where i can find it in my PDI

[Mushir · Accepted solution]

Hi Runjay

can you explain me  about sys_class_name  field where i can find it in my PDI

[Bhavya11 · Accepted solution]

Hi @Mushir ,

you can try below code to get the count 

var slaBreached =0;
var slaGr = new GlideAggregate("task_sla");
slaGr.addQuery("task.sys_class_name=incident^has_breached=true");
slaGr.addAggregate("COUNT");
slaGr.query();
while(slaGr.next()){
	slaBreached=slaGr.getAggregate("COUNT");
}
gs.print("Count incident which SLA has been breached "+slaBreached);

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

Thanks,

BK

[Mushir · Accepted solution]

Hi Bhavya 

can you explain me sys_class_name  field where i can find it in my PDI

[Runjay Patel · Accepted solution]

Hi @Mushir ,

You can use below script.

var slaBreached = 0;
var slaGr = new GlideAggregate("task_sla");

// Query for breached SLAs related to incidents
slaGr.addQuery("task.sys_class_name", "incident");
slaGr.addQuery("has_breached", true);
slaGr.addAggregate("COUNT");
slaGr.query();

// Fetch the count directly without looping
if (slaGr.next()) {
    slaBreached = slaGr.getAggregate("COUNT");
}

// Print the result
gs.print("Count of incidents with breached SLAs: " + slaBreached);

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

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

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

[Mushir · Accepted solution]

Hi Runjay

can you explain me  about sys_class_name  field where i can find it in my PDI