KACE Product Support Question

Obtain all variable names for Kace emails notifications

03/16/2015 12107 views

We want to use the email notification feature to send ticket updates from our K1000.
The issue we are having is that Kace does not understand the SQL variables in email notification message field.
Variables from SQL like $comment & $submitter are coming out as typed, rather than being the variable value.

Does anybody understand how Kace generates these variables or where i can obtain a full list of variables?

Please see below examples of these variables;

$ticket_url, $ticket_fields_visible, $quoted_mail, $ticket_priority and $userui_url

Answer Summary:
0 Comments   [ + ] Show comments


Community Chosen Answer

For the system rules the variables can be found in the administrator guide. On the appliance browse to the Service Desk Email Notifications page (https://kace/adminui/queue_templates.php?ID=1), click the ? mark in the upper right for help, then click Email template variables.
Answered 03/17/2015 by: chucksteel
Red Belt

  • Hi Chuck,

    In version 6.3 the email notification page doesn't appear to have any obvious help or ? marks apart from the ones relating to the HTML/Markdown tick box
    • Sorry! I have now been able to access these using Google Chrome... For some reason you cannot see the help in ie11

All Answers

As of v6.4 here are the available tokens...

All Email Templates:

Ticket-Related Email Templates:

Error-Related Email Templates:
Answered 02/18/2016 by: MAXintosh
Senior Purple Belt


We find that we have to make sure that the variable is selected within the select statement of the ticket rule. If you look through a default rule created by the wizard you will find various variables in as default, as below:

                        if ((LENGTH(U1.FULL_NAME) = 0), U1.USER_NAME, U1.FULL_NAME) as OWNER_NAME,
                        U1.FULL_NAME as OWNER_FULLNAME,
                        U1.EMAIL as OWNER_EMAIL,
                        if (U1.ID is null, 'z', concat('a', if ((LENGTH(U1.FULL_NAME) = 0), U1.USER_NAME, U1.FULL_NAME))) as SORT_OWNER_NAME,
                        if ((LENGTH(U2.FULL_NAME) = 0), U2.USER_NAME, U2.FULL_NAME) as SUBMITTER_NAME,
                        U2.FULL_NAME as SUBMITTER_FULLNAME,
                        U2.EMAIL as SUBMITTER_EMAIL,

So if you want to have additional data available either as a VARIABLE or $variable within your rule, you will probably need to add in to the select statement


So that you can then use them in the email part of the rule
Answered 03/16/2015 by: Hobbsy
Red Belt

  • Hi Hobbsy,

    Thank you for the response.

    Sorry i probably wasn't clear enough.
    We are trying to get away from using ticket rules to generate emails. Instead we hope to use the default "Email on Events" which, doesn't appear to have any SQL queries attached.

    It uses its own defined variables (listed above) which, do not appear in the wizard generated SQL query
    • I believe that KACE generates those variable in the same way, but as there is no way of cracking open the default rules you are stuffed! In a lot of engagements we do tend to find that emails can be better controlled if sent from within a ticket rule, you can also ensure that duplicates are not sent out and also that alerts are sent in the right order, which I know is a common complaint.

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