/build/static/layout/Breadcrumb_cap_w.png

K1000 Service Desk Report to show tickets with no updates by owner

I am trying to create a report that will show tickets that have no updates on them by the tech that owns the ticket.


0 Comments   [ + ] Show comments

Answers (2)

Answer Summary:
Posted by: Mashby1 3 months ago
Yellow Belt
0

Top Answer

Schema for reference here: http://blog.foreignkid.net/wp-content/uploads/2011/04/schema_bootkamp.jpg, but this should start you out:

SELECT T.ID AS TICKET_ID, T.TITLE, T.RESOLUTION, TC.COMMENT



FROM HD_TICKET T



LEFT JOIN HD_TICKET_CHANGE TC ON (TC.HD_TICKET_ID = T.ID)


WHERE ((T.RESOLUTION = '') OR (TC.COMMENT = ''))


GROUP BY T.ID


ORDER BY T.ID


Comments:
  • Thanks! I've been looking for that schema. I think you have provided enough for me to get where I need to go. I appreciate it. - CoryAdams 3 months ago
    • Awesome! Glad I could help :) - Mashby1 3 months ago
      • but keep in mind, the blog is 10 years old and never updated. And the schema has been changed in the last 10 years. - Nico_K 3 months ago
Posted by: Hobbsy 3 months ago
Red Belt
-1

Best place to start would be probably the ticket change table, as you can then link it to HD_TICKET to pull the owner ID.

Don't be a Stranger!

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

Sign up! or login

View more:

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