Scripting

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

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

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?