NOTE: CODE WRITTEN BY QUEST KACE SUPPORT FOR DEMONSTRATION PURPOSES ONLY AND NOT SUPPORTED BY KACE TECHNICAL SUPPORT. CLIENT CONFIRMS THE NEED FOR TESTING AND ACCEPTS ALL RESPONSIBILITY FOR USE AND MISUSE OF CODE. QUEST KACE SHALL NOT BE HELD LIABLE FOR DAMAGE OR DOWN TIME RESULTING FROM USE OF THIS OR ANY CODE PRESENTED FOR PURPOSES OF TROUBLESHOOTING OR DEMONSTRATION.
To create a new SQL report perform the following steps
Click Reporting | Choose Action | New (SQL)
From the next screen give your report a Title, Category, Description
Note: These are unimportant for functionality as long as they are something you can remember.
Input your custom SQL below and click Save.
select case when MONTH(T.CREATED) between 1 and 3 then '1st Quarter' when MONTH(T.CREATED) between 4 and 6 then '2nd Quarter' when MONTH(T.CREATED) between 7 and 9 then '3rd Quarter' when MONTH(T.CREATED) between 10 and 12 then '4th Quarter' end as QUARTER, C.NAME, COUNT(T.ID) as NUMBER_TICKETS from HD_TICKET T join HD_CATEGORY C on T.HD_CATEGORY_ID = C.ID where T.HD_QUEUE_ID = 1 and YEAR(T.CREATED) = YEAR(CURTIME()) group by QUARTER, T.HD_CATEGORY_ID order by QUARTER asc