Work Report for a Specific Queue
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
Answers (0)
Please log in to answer
Be the first to answer this question
and T.HD_QUEUE_ID = 24 - Druis 6 years ago