Built something you're proud of? Tell the story. A quick G2 review of App Engine or Build Agent helps other developers see what's possible on ServiceNow. Share your experience.

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,940 Views
5 REPLIES 5

Ulrich Jugl
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
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