Closed Work Orders by month
I have to run a report each month on how many work orders our Help Desk closed for the previous month. How can I create this report where I can specify the Date Range?
0 Comments
[ + ] Show comments
Answers (3)
Please log in to answer
Posted by:
jmcelvoy
13 years ago
Also, how to I add the Department to this report? My users all have their departments listed under Custom 3 in their details. The report has this line (select FULL_NAME from USER where HD_TICKET.SUBMITTER_ID = USER.ID) as SUBMITTER_NAME Can I somehow change the HD_TICKET.SUBMITTER_ID=USER.ID to HD_TICKET.SUBMITTER_ID=Department or HD_TICKET.SUBMITTER_ID=Custom 3 ???
Posted by:
dchristian
13 years ago
I think this should point you in the right direction.
SELECT U.CUSTOM_3 AS DEPARTMENT,
COUNT(*) AS CLOSED_TICKETS
FROM HD_TICKET H,
HD_STATUS S,
USER U
WHERE H.HD_STATUS_ID = S.ID
AND H.SUBMITTER_ID = U.ID
AND S.STATE = 'CLOSED'
AND ( H.TIME_CLOSED >= '20110101'
AND H.TIME_CLOSED <= '20110131' )
GROUP BY U.CUSTOM_3
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.