Need help with Monthly Closed Report on a Specific K1000 Label
2 questions about pulling a report in KACE.
I am trying pull a SQL report on a partner company of ours for Monthly billing but having trouble with the code. I did some searching and found the line to include in the report but when placed in the report below it has no success.
JOIN LABEL L ON L.ID=ML.LABEL_ID and L.NAME='Subsidiary Company Company Name'
SELECT HD_TICKET.TITLE,HD_CATEGORY.NAME AS CATEGORY,
HD_STATUS.NAME AS STATUS,
HD_TICKET.ID,O.FULL_NAME AS OWNER_NAME,
S.FULL_NAME AS SUBMITTER_NAME,
HD_TICKET.TIME_CLOSED FROM HD_TICKET JOIN HD_CATEGORY ON (HD_CATEGORY.ID = HD_TICKET.HD_CATEGORY_ID) JOIN HD_STATUS ON (HD_STATUS.ID = HD_TICKET.HD_STATUS_ID) LEFT JOIN USER O ON (O.ID = HD_TICKET.OWNER_ID) LEFT JOIN USER S ON (S.ID = HD_TICKET.SUBMITTER_ID) WHERE (HD_TICKET.HD_QUEUE_ID = 1) AND (((TIMESTAMP(HD_TICKET.TIME_CLOSED) <= NOW() AND TIMESTAMP(HD_TICKET.TIME_CLOSED) > DATE_SUB(NOW(),
INTERVAL 1 MONTH))) AND (HD_CATEGORY.NAME like '%OSI Acct Unlock%')) ORDER BY ID desc,SUBMITTER_NAME
Please let me know if you have a better SQL code to pull reports on specific Labels for Users.
How do we include other queues in the report mentioned above. For example: I would like to include the Help Desk, System Admins, Operations, and Business Analyst queues on one report. I know that you have to specify the queue id (HD_TICKET.HD_QUEUE_ID = 2) but how do you have muliple queues in a single report?