Is there a way to remove the subcategories from K1000 HD Ticket reports?
I have this script for top categories but we also want to include ticket open date, ticket close date, technician, and submitter. Can someone help me with this?
SELECT SUBSTRING_INDEX(HD_CATEGORY.NAME, "::", 1) AS TopCategory, COUNT(HD_TICKET.ID) FROM ORG1.HD_TICKET
JOIN HD_CATEGORY ON HD_CATEGORY.ID = HD_TICKET.HD_CATEGORY_ID
WHERE HD_TICKET.HD_QUEUE_ID = 5
GROUP BY TopCategory