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
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share