SERVICE DESK REPORT
I thought this would be simple however, no luck. I am looking on teh best way to run a report showing all tickets submitted by a label group to the service desk during a span of time. I would like to see how many tickets one certain department has submitted to the IT help desk in the last year. I cannot seem to find anything. Any help would be awesome.
Answers (1)
SO just to get you started, if you say you have the users from the department in a label, then find the ID of that label. You can do that by going to Home>Labels>Label management, hover over the label and see the ID pop up in the code at the bottom left of your screen.
Now use this report code to get you started
SELECT HD_TICKET.ID, HD_TICKET.TITLE
FROM ((USER_LABEL_JT USER_LABEL_JT
INNER JOIN LABEL LABEL ON (USER_LABEL_JT.LABEL_ID = LABEL.ID))
INNER JOIN USER USER ON (USER.ID = USER_LABEL_JT.USER_ID))
INNER JOIN HD_TICKET HD_TICKET
ON (HD_TICKET.HD_STATUS_ID = USER.ID)
WHERE LABEL.ID = 'xx'
You will then need to add in the fields that you want and maybe the date criteria that you need into the WHERE statement