/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Kace custom service desk reports

07/16/2018 501 views
How can I create a report showing all tickets created in the "LAST 7 DAYS" by category sorted by date, oldest first?

1 Comment   [ + ] Show comment

Comments


All Answers

0
SELECT T.ID,
C.NAME as CATEGORY,
ifnull(O.FULL_NAME ,'Unassigned') as OWNER_NAME,
S.FULL_NAME as SUBMITTER,
T.CREATED
FROM HD_TICKET T
LEFT JOIN USER O on O.ID = T.OWNER_ID
LEFT JOIN USER S on S.ID = T.SUBMITTER_ID
LEFT JOIN HD_CATEGORY C on C.ID = T.HD_CATEGORY_ID
WHERE DATE(T.CREATED) > NOW() - INTERVAL 7 DAY
ORDER BY CATEGORY, T.CREATED DESC
Answered 07/17/2018 by: chucksteel
Red Belt

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