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.