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   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity


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_ID

All custom fields will be shown, cause they are stored in the columns CUSTOM_FIELD_VALUE0 - CUSTOM_FIELD_VALUE14.
Answered 03/11/2015 by: aragorn.2003
Red Belt

Please log in to comment