How to add SLA's related field into the incident table reports

[Shivani Sahu]

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.

[AndersBGS · Accepted solution]

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

[Shivani Sahu]

Thanks so much Ander. Its worked for me