How to generate number of breach incident report?

[Siti]

Hello there,

I am new in ServiceNow but I have requirement from Management where they are looking for number of breach incident MTD and YTD.

I tried to use Task_SLA table and Incident_SLA table but looks like it will provide the number of task_sla instead of number of incidents.

I also found made SLA column in incident table but I think this column is useless.

Is there any way for the to get this done without concern about how many number of task_SLA?

example : total incidents MTD is 100.

                has breach :5,not breach 95.

Any idea are welcome.

Thanks in advance.

[Michael Fry1]

incident_sla is a database table combining incidents and task_sla. You should be able to use that table to get your Incident count where has breached is true. Use Count Distinct in case multiple SLAs are running on same incident.

[Siti]

Thank you for the answer Michael Fry.

I am creating bar chart to compare number of active incident and how many ticket has breach.

Currently, active incidents is 340. But when I grouped it by has breach, I am getting 343 active incident with 3 inc has breach. Actually this 3 ticket are duplicate since some SLA tasks in these 3 incident having value has breach is false as well.

Is there any other way for me to get the value like has breach : false = 337 and true : 3?

[Slawek_Radziewi]

You have different conditions and it might be reason.

Once you use state and once incident state. 

Also assignment group or assignment group name is one of which probably is the same though. 

[Siti]

It is referring to the same column. I managed to get the same value in Incident_SLA table (340) the problem comes when I add "stacked by" : "Has breach". it will be duplicate there.