I need to find a why to get this into a report and there is nothing in reporting on it. I can run a sql query and find it but need to place in a report. Any suggestions would be most greatful.

Work logged against this ticket (1.00 hours total)
Delete Name Date Start Time End Time Adj. Hours Hours Note
  03/12/2013 16:50:00 17:20:00 +0.50 1.00

 

 

 

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0

thanks everybody here is what I came up with in mysql workbench.

 

SELECT
    O.FULL_NAME AS OWNER_NAME,
    HD_TICKET.TITLE,
    HD_STATUS.NAME AS STATUS,
    HD_TICKET.TIME_OPENED,
    HD_TICKET.TIME_CLOSED
FROM
    HD_TICKET
        LEFT JOIN
    USER O ON (O.ID = HD_TICKET.OWNER_ID)
        JOIN
    HD_STATUS ON (HD_STATUS.ID = HD_TICKET.HD_STATUS_ID)
WHERE
    (HD_TICKET.HD_QUEUE_ID = 12)
        AND ((TIMESTAMP(HD_TICKET.TIME_CLOSED) <= NOW()
        AND TIMESTAMP(HD_TICKET.TIME_CLOSED) > DATE_SUB(NOW(), INTERVAL 5 DAY)))
ORDER BY OWNER_NAME , TIME_CLOSED , TIME_OPENED

Answered 04/22/2013 by: mikesharp1
Second Degree Black Belt

Please log in to comment
0

Will the default reports under Helpdesk for worked hours work? There are 6 reports in tehre already that can be used to show worked hours. if not, this would be a custom report and would need to know exactly what you need. the above is just whats in the box but no association to any ticket directly.

Work Report last 7 days by person

Work Report last 31 days


 

Answered 03/19/2013 by: nshah
Red Belt

Please log in to comment
0

If you have a SQL query that you know works you can create a SQL report using that code. Have you tried that and it didn't work?

Answered 03/20/2013 by: chucksteel
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity