K1000 Reporting - SQL "Count" Query
I am trying to generate a report in Kace that counts the total number of tickets created within a month based on custom fields values in all our queues. Below is the custom sql query i have generated so far however stuck on how/where to input the "count" to account for how many number of tickets where created with Custom fields 1 and Custom field 2 in the last 30 days. Any assistance will be much appreciated, thanks in advance.
SELECT HD_TICKET.CREATED, HD_STATUS.NAME AS STATUS, HD_TICKET.ID, HD_TICKET.CUSTOM_FIELD_VALUE2, HD_TICKET.CUSTOM_FIELD_VALUE1 FROM HD_TICKET JOIN HD_STATUS ON (HD_STATUS.ID = HD_TICKET.HD_STATUS_ID) WHERE (HD_TICKET.HD_QUEUE_ID in (5,2,8,9,12,14,18,16,1,15,10,11,3,13,17,25,20)) AND ((TIMESTAMP(HD_TICKET.CREATED) <= NOW() AND TIMESTAMP(HD_TICKET.CREATED) > DATE_SUB(NOW(),INTERVAL 30 DAY))) ORDER BY CREATED
There are no answers at this time