Kace report for 2 service desk queues.
We have a service desk queue (queue id =1) that is for tickets and another service desk queue (queue id =5) and each queue has some similar fields and each queue has it's own unique fields. I am try to write a Kace report that combines all the fields from each queue and since I don't know MY SQl, I am looking for a starting point.
Do I say something like if queue id =1, get field...get field...etc. and the go on to say OR if queue id=5, get field.....get field.....etc.
I hope this makes sense.
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
aragorn.2003
9 years ago
Hi nadecats,
you can run the following SQL code to show all tickets from to queues. (it simplified cause it shows all columns)
select * from HD_TICKET where HD_QUEUE_ID in (1,7) order by HD_QUEUE_IDAll custom fields will be shown, cause they are stored in the columns CUSTOM_FIELD_VALUE0 - CUSTOM_FIELD_VALUE14.
