In Service Manager the data in the Data Warehouse is scattered in different tables in the DWDataMart database.


The query is able to tie all of the relevant tables in order to obtain all incidents and SLA history breaches.

 

Below are some of the fields which are obtained from the SQL Query 

 

·        Incident Names

·        Created By

·        Assigned To

·        Resolved By

·        Created Date

·        Assigned to Date

·        Resolved By Date

·        Billable Time Users

·        Billable Time

·        SLA Breach

·        SLA Start Date

·        SLA End Date