/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Work Report for a Specific Queue

03/13/2018 918 views
I'm trying to generate a report that will display all hours worked by service desk owners during a time specified, but only for a specific queue.   The canned report "Work Report last 31 days by person" works fine except I don't know how to make it specific to only one queue.  Obviously I know next to nothing about SQL because this is probably very easy.   Here's the code from that canned report, can please someone modify it to relate only to Queue_ID 24?  Any help is greatly appreciated!

select W.STOP as DATE, CONCAT(CAST(T.ID AS CHAR), " - ", T.TITLE) as TICKET, U.FULL_NAME, substring(W.NOTE,1,1200) as NOTE,
format((time_to_sec(timediff(stop, start)))/3600.0 + ADJUSTMENT_HOURS,2) as HOURS_WORKED
from (HD_WORK W, HD_TICKET T, USER U)
where W.HD_TICKET_ID = T.ID
  and isnull(W.VOIDED_BY)
  and W.USER_ID = U.ID
  and W.STOP > DATE_SUB(NOW(), INTERVAL 31 DAY)
order by U.FULL_NAME, TICKET, W.STOP

1 Comment   [ + ] Show comment

Comments

  • You are nearly there add

    and T.HD_QUEUE_ID = 24
    • Thank you, perfect! I attempted that but I left out the T. so it didn't work. I appreciate it.

Be the first to answer this question

Don't be a Stranger!

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

Sign up! or login

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