→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper

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.

Lansweeper Tech Support
Lansweeper Tech Support

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.

~~~~~~~ (〃 ̄︶ ̄)人( ̄︶ ̄〃) ~~~~~~~
Sweep that LAN, sweep it!