Syntax errors on extremely basic SQL queries


I am looking into creating custom ticket rules for our one queue, however when trying to develop the SQL, even extremely simple SQL queries like "select ID from HD_TICKET" will throw a syntax error when I click on "View Ticket Search Results".

Are the database field names different from the example given, or is there some setting I need to configure, or what?

Thank you,

1 Comment   [ + ] Show comment
  • @TheMohawkNinja,
    I have noticed on some tables that you must include the table in the prefix of the select query? No idea why but you might try this....


    I am also curious if this works for you as I just ran into this yesterday when writing some custom reports. - cstewy 3 weeks ago

Answers (2)

Posted by: barchetta 1 month ago
4th Degree Black Belt

Doesnt work usually because your rule has variables or commands relative to the current ticket (run on save)..  I would suggest you connect a sql editor to your kace db to play around.. but I have to tell you, after 2 yrs of learning kace rules, it takes a ton of time to understand how kace does sql rules.  

Posted by: chucksteel 1 month ago
Red Belt

I have written a lot of custom ticket rules and I almost never use the View Ticket Search Results link. I agree with barchetta, use a tool like MySQL Workbench to test your queries.

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