/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


Work Logged

03/19/2013 2345 views

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


All 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
2nd Degree Black Belt

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

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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ