/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Kace Ticketing System - How to set Device to Unassigned for all new tickets

08/08/2017 1247 views
Hi,

I need help to create a Kace Ticket Rule to set device to unassigned for all new tickets.

Understand it is something related to machine_id to 0, but I not good in SQL.

Thanks in advance !

Will this update query work?

update HD_TICKET
    set HD_TICKET.MACHINE_ID = 0
HD_TICKET.HD_QUEUE_ID = HD_QUEUE_ID and 
        (HD_TICKET.ID in ())
0 Comments   [ + ] Show comments

Comments


Be the first to answer this question

Don't be a Stranger!

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

Sign up! or login

Share

 
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