- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-29-2023 08:21 AM
I have requirement to create report on incident table and add the fields such as Number, opened date, Short Description, Caller, Priority, Assignment group, state, assigned to, closed, tags, Configuration item, SLA, resolved by, Resolved date, Resolution notes. Along with this fields needs to be add the columns of SLA name, Breach time, actual time left, Business time left, Business elapsed percentage etc.
Please let me know how to add SLA's field in the incident table report. I have created a report on incident table just because have to add the columns of variables field as well.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-29-2023 12:41 PM
Hi @Shivani Sahu ,
In the report designer, you should utilize the incident_sla table which comes from ServiceNow OOTB. This is a database view that combines the SLA table with the incident table.
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-29-2023 12:41 PM
Hi @Shivani Sahu ,
In the report designer, you should utilize the incident_sla table which comes from ServiceNow OOTB. This is a database view that combines the SLA table with the incident table.
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-28-2023 05:46 AM
Thanks so much Ander. Its worked for me