KACE Product Support Question

access to variable names

08/26/2018 446 views

Is it possible to get access to the variables that are defined and used when generating an email. I would like to get to these via a custom ticket rule. Is that possible

$ticket_due_date The due date as saved on the ticket. Administrators can override automatic due dates with manual due dates if necessary.


0 Comments   [ + ] Show comments


All Answers

The variables available for a custom ticket rule are the columns selected in the SQL statement. If you use the rules wizard to generate your rule it will create quite a few of the typical variables. The beginning of the statement uses a SELECT clause to choose those columns, so you can look at that list to see the variables available. Most of the lines will end with an "AS SOMETHING" the something will be the name of the variable $something. Adding other variables is as easy as adding the appropriate column to the select list.

To get the $ticket_due_date add this above the FROM line:
(the columns are in a comma separated list, so make sure you have that comma.

Answered 08/27/2018 by: chucksteel
Red Belt

  • Thanks Chucksteel. I will try it

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