Helpdesk Report

[NH]

I'm trying to create a helpdesk report with following information.

Ticket creation date (dd/mm/yyyy)
User reporting the incident
Ticket priority
SLA resolve time in days (according to ticket priority)
Ticket subject
Incident source (mail, phone,...)
Ticket Category
Ticket resolve date
Days between creation date and resolution date (empty if not yet resolved)
Days between creation date and current date (empty if resolved)
If the ticket is resolved within SLA, a green background colour.
If the ticket is exceeding SLA, a red background colour.

Any help would be great. I'm planning to use this report as a guidline in our weekly meetings.

[David_GF]

Hi @NH, We recommend opening a ticket with our Support team to create this custom report. Once solved, we will share the query here, too, so other forum users can benefit from the solution.