/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


I need to add location to this report can anyone help me out.

02/24/2015 816 views

SELECT

 U.FULL_NAME AS SUBMITTER,

COUNT(*) AS CLOSED_TICKETS

FROM HD_TICKET H,
HD_STATUS S,
USER U
WHERE H.HD_STATUS_ID = S.ID
AND U.ID = H.SUBMITTER_ID
AND S.STATE = 'CLOSED'
GROUP BY U.FULL_NAME
ORDER BY U.FULL_NAME

0 Comments   [ + ] Show comments

Comments


All Answers

0
select ifnull((select FULL_NAME from USER where T.OWNER_ID = USER.ID),' Unassigned') as 'Owner Name', count(*) as 'Total Open Tickets', U.LOCATION
from HD_TICKET T
left join USER U on U.ID = T.OWNER_ID
left join HD_STATUS S on S.ID = T.HD_STATUS_ID
where S.NAME not rlike 'Closed|Resolved'
group by T.OWNER_ID
order by count(*)
Answered 02/24/2015 by: h2opolo25
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