/build/static/layout/Breadcrumb_cap_w.png

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.


0 Comments   [ + ] Show comments

Answers (1)

Posted by: Hobbsy 1 year ago
Red Belt
0

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

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