SLA breache Report

SALARA
Tera Contributor

if an incident or request ticket breached within 36 hours open and or closed , i want that report to send the email address?

2 REPLIES 2

Siddhesh Wani1
Tera Guru

Hello @SALARA ,
To achieve this
Step 1)  Create report in the 'sys_report' table. 
Step 2) Add the filter condition inside the report - 'task.sys_class_name=incident^ORtask.sys_class_name=sc_request^duration>=javascript:gs.getDurationDate('1 12:0:0')'
Step 3) Create Schedule Job where you can add the email address and users to whom you want to sent that report 
Step 4) Add the newly created report in the schedule job select type in which format you want to sent that report (Excel/PDF).
Step 5) Add Run - When you want to sent that report and save the schedule job. It will automatically send the report to the email address. 

Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

Ankur Bawiskar
Tera Patron
Tera Patron

@SALARA 

you can configure report and then use scheduled reports and send the email

what report did you configure so far?

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader