I need to generate two reports that will show ticket count in all statuses by owner and the other by submitter last 31 days and YTD.  Looking to show heavy hitters in ticket submitting and those having to handle them. Thank you in advance for your assistance with this.
0 Comments   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity


Here's a starter... just change the fields around to get what you want.

select ifnull((select FULL_NAME from USER where T.OWNER_ID = USER.ID),' Unassigned') as 'Owner Name', count(*) as 'Total Open Tickets'
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

Please log in to comment