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

Comments

  • Hi,

    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
Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity