/build/static/layout/Breadcrumb_cap_w.png

Kace Reporting Question

I have seen many reports on IT Ninja, but I am looking for one that I hope someone can help me with. 

 

I am looking to finish this report and report on tickets that are 2 days or older, and need help finishing this.  Thanks everyone

 

SELECT HD_TICKET.ID, Q.NAME AS QUEUE_NAME, HD_CATEGORY.NAME AS CATEGORY, GROUP_CONCAT(DISTINCT HD_TICKET_CHANGE.COMMENT SEPARATOR '\n') AS HD_TICKET_CHANGE_COMMENT_GROUPED, S.FULL_NAME AS SUBMITTER_NAME, O.USER_NAME AS OWNER_USER_NAME, HD_PRIORITY.NAME AS PRIORITY, HD_STATUS.NAME AS STATUS_NAME, HD_TICKET.CREATED, HD_TICKET.TIME_OPENED  FROM HD_TICKET  JOIN HD_QUEUE Q ON Q.ID = HD_TICKET.HD_QUEUE_ID JOIN HD_CATEGORY ON (HD_CATEGORY.ID = HD_TICKET.HD_CATEGORY_ID) LEFT JOIN HD_TICKET_CHANGE ON (HD_TICKET_CHANGE.HD_TICKET_ID = HD_TICKET.ID) LEFT JOIN USER S ON (S.ID = HD_TICKET.SUBMITTER_ID) LEFT JOIN USER O ON (O.ID = HD_TICKET.OWNER_ID) JOIN HD_PRIORITY ON (HD_PRIORITY.ID = HD_TICKET.HD_PRIORITY_ID) JOIN HD_STATUS ON (HD_STATUS.ID = HD_TICKET.HD_STATUS_ID) WHERE (HD_TICKET.HD_QUEUE_ID = 41) AND ((HD_STATUS.NAME = 'New') AND (HD_STATUS.NAME = 'Open') AND ((Q.NAME = '1 - North America') OR (Q.NAME = 'IT Network/Telecom') OR (Q.NAME = 'IT Infrastructure Systems') OR (Q.NAME = 'IT End User Computing')))  GROUP BY HD_TICKET.ID ORDER BY ID.

 

 


1 Comment   [ + ] Show comment
  • Does this report work as is but you just want to include tickets that are 2 days or older? - chucksteel 10 years ago

Answers (0)

Be the first to answer this question

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