Miscellaneous Question

Kace report for 2 service desk queues.

03/10/2015 1897 views
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


All Answers

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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ