Hello Community,
I am currently working with ServiceNow Zurich and I am looking for best practices to relate the Incident table with Task SLA (task_sla) in order to display SLA status directly in Incident list views.
Use Case
- I work mainly with the Incident – All list.
- I need to add a column in the incident list that clearly indicates whether:
- The SLA has been breached, or
- The SLA has been met / completed.
The main goal is to export the Incident list to Excel and generate a report that includes SLA compliance information for all incidents, without opening each record individually.
What I am considering
- Using derived or calculated fields related to task_sla
- Fields such as:
- sla_breached
- sla_due
- sla_stage
- Since one Incident can have multiple SLAs, I would like guidance on:
- How to display the relevant SLA (for example, the active one or the next to breach)
- Whether it is recommended to use:
- Display Business Rules
- Script Includes
- Database Views
- Dot-walking from task_sla
Specific question
👉 What is the best practice in ServiceNow Zurich to:
- Relate Incident ↔ Task SLA
- Display SLA status (Breached / Met) in Incident list views
- Ensure the solution works properly for Excel reporting
Any recommendations based on real experience or ServiceNow-supported architecture would be greatly appreciated.
Thank you in advance.
