KACE SMA Reporting: Tickets opened by quarter for current year (4268713)

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.

• We highly recommend you test all code no matter the source before using in a production environment.
• If you are cut and pasting the code paste in to a text editor then copy back out to remove any hidden characters or markup.

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