Service Desk work log reporting
Hi,
How to include work log in service desk into reporting. I need to count timed taken by staff for each ticket. Please help me! Thank you in advance.
1 Comment
[ + ] Show comment
Answers (0)
Please log in to answer
Be the first to answer this question
There is a table in Kace called HD_WORK. That has this information. Try something like this:-
Select HD_WORK.HD_TICKET_ID, HD_WORK.START, HD_WORK.STOP, HD_WORK.NOTE FROM HD_WORK
JOIN HD_TICKET
ON HD_WORK.HD_TICKET_ID = HD_TICKET.ID
WHERE (HD_TICKET.HD_QUEUE_ID = 6)
Just change the Queue number as needed - Druis 9 years ago