Could I please get the MSSQL query to run a report that shows:

- SLA Name

- SLA Response Time (respond within X hours)

- SLA Resolution Time (resolve within X hours)

- Level 1 to 4 escalation notification timing (e.g. 4 hours before, or 1 hour after, etc.)

- Escalate To

This would essentially be the data that appears in the Service Level Agreements page in the Admin module.

We have many different SLAs, and it is time consuming for management to go through each SLA individually to review the SLA escalation notification timings. They have asked if this could be presented on a report.

Thanks,

Daniel Comley