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?
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.
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