KACE Product Support Question

Ticket rule to add 15 minutes time to Work Adjustment. - SQL

07/31/2019 160 views

I'd like to create a ticket rule that if Custom_20 is not null that it adds 15 minutes to work adjustment.

Reason being, we've a daily ticket that we carry out and want to simplify adding work done to it.

Got his far:

update HD_TICKET



        (HD_TICKET.ID in (<TICKET_IDS>))

update ORG1.HD_WORK

    set HD_WORK.MODIFIED='.25'

Any ideas anyone?

3 Comments   [ + ] Show comments


  • Firstly you need to make sure that you custom field contains a value, I'm not sure but from a few releases back setting a default value of '0' seemed to fail. We used this mechanism as a switch field regularly before KACE "Broke" it, so I would suggest a default value of 1 rather than 0. Also your update surely needs to be set as a sum so that it adds time to the work completed, or is it just a default value that you want to set to assume that there is work done?
  • yeah, a set sum if 15 ever time. that's .25 hours.
  • yeah, a set sum if 15 ever time. that's .25 hours.

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