How to pull a report of breached tickets for the current month

[saahilkumar]

Hi All

I wish to pull a report of breached tickets(Incident and Request) that were assigned to me for the current month. Please how can I pull the report, which table can be used for this?

Thanks in advance

[Chuck Tomasi · Accepted solution]

Take a look at the task_sla table. Filtering on the data requires dot-walking to get the Task.Assigned To field, but that's pretty easy.

Example:

Table: Task SLA

Filter: Task.Assigned To | is (dynamic) | Me and

Stage | is | Breached and

Breach time | on | This Month

Reference:

Dot-Walking - Servicenow Wiki

[shilpiharitwal]

Hello Saahil,

Please find below mention screen shot for your requirement.

You can just create a new Report and Select the condition accordingly your current requirement.

For Bleached ticket "Current Month" will be Bleached Time "This Month".

Hope it help you

Regards,

Shilpi Sharma.

[saahilkumar]

Hi Shilpi

Thanks for the assistance

However, I am unable to locate the field "Breach Time".

Thanks in advance

[Chuck Tomasi]

By using Assigned to | is (dynamic) | Me, it allows the same report to be used for others.