How to merge incident and incident sla tables and generate the report?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-17-2016 06:49 AM
How to merge incident and incident sla tables and generate the report?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-17-2016 06:59 AM
The Incident SLA database view is already a merge between Incident and Task SLA. What are you not getting in Incident SLA that you need?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-09-2018 01:42 AM
In TASK(SLA) in am not able to find Number Field column.
Can you help me out?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-09-2018 03:07 PM
are you talking about the task_sla table? The column you're looking for is Task.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-17-2016 07:03 AM
Hi Venkata,
To merge incident and incident sla table you have to create relationship between these two tables.
But already there is OOB Incident SLA(incident_sla) table present so you can select same table while creating report.
To create relationship between two tables refer below thread:
Creating Defined Related Lists - ServiceNow Wiki
Regards,
Swapnil
PS: Hit like, Helpful or Correct depending on the impact of the response
