overdue task

gtk
Mega Sage

‎03-03-2017 07:47 AM

can some one guide me to fetch report on incident table,

OVERDUE INCIDENTS.

0 Helpfuls
  • 2,255 Views
5 REPLIES 5

Ulrich Jugl
ServiceNow Employee
ServiceNow Employee

‎03-03-2017 07:48 AM

Hi gtk,



what does "overdue" mean to you? If this is around an incident which breached it's SLA, you can check the incident_sla database view - it combines the incident and task_sla tables and you immediately have access to the SLA information for each incident.



Best


Ulrich


0 Helpfuls

gtk
Mega Sage
In response to Ulrich Jugl

‎03-03-2017 07:57 AM

overdue mean DUE DATE field, incidents are running after due date.


0 Helpfuls

Ulrich Jugl
ServiceNow Employee
ServiceNow Employee
In response to gtk

‎03-05-2017 11:52 PM

There is an operator for this called "relative". Check this out:


find_real_file.png


Preview file
17 KB

gtk
Mega Sage
In response to Ulrich Jugl

‎03-21-2017 05:29 AM

Ulrich,



in this case it shows the incidents which has due date after the current time, but in our case we need to see list of tasks that are running after the time mentioned in due date field.



Example : suppose if task having due date is at march 20 and currently it is still active


0 Helpfuls