Report for K1000 Helpdesk Ticket - no Technician take ticket being created for more than 1 hour in past 30 days
Hi all,
We would like to create a Report for Helpdesk Ticket that has been created for more than an hour without anyone assigned or Ticket status as 'NEW' for more than 60 minutes in past 30 days
1 Comment
[ + ] Show comment
-
Thanks and it works exactly we want. - andylai2k 10 years ago
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
chucksteel
10 years ago
This should get you started. The first one lists tickets where the status has changed from New to something else:
SELECT HD_TICKET.ID, HD_TICKET.CREATED,HD_TICKET_CHANGE.TIMESTAMPFROM ORG1.HD_TICKETJOIN HD_TICKET_CHANGE on HD_TICKET.ID = HD_TICKET_CHANGE.HD_TICKET_ID and HD_TICKET_CHANGE.DESCRIPTION like '%Changed ticket status from "New"%'WHERE TIME_TO_SEC(TIMEDIFF(HD_TICKET_CHANGE.TIMESTAMP, HD_TICKET.CREATED)) > 3600and HD_TICKET.CREATED > NOW() - INTERVAL 30 DAY
This one looks for change in owner:
SELECT HD_TICKET.ID, HD_TICKET.CREATED,HD_TICKET_CHANGE.TIMESTAMPFROM ORG1.HD_TICKETJOIN HD_TICKET_CHANGE on HD_TICKET.ID = HD_TICKET_CHANGE.HD_TICKET_ID and HD_TICKET_CHANGE.DESCRIPTION like '%Changed ticket owner from Unassigned%'WHERE TIME_TO_SEC(TIMEDIFF(HD_TICKET_CHANGE.TIMESTAMP, HD_TICKET.CREATED)) > 3600and HD_TICKET.CREATED > NOW() - INTERVAL 30 DAY
