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

Comments

Please log in to comment

Answers

0
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
Answer this question or Comment on this question for clarity

Share