I'm in the process of configuring the K1000 service desk. I have created a rule to send an email to our IT support staff when a new ticket is created. We receive the email but it comes with so many fields that we do not need. I just want to get a simple email with "Title,Submitter,Submitted Date etc". I have changed the SQL query but I'm not getting the what I am looking for. How can I add or remove field on the email that I'm getting. I have attached a screenshot as well.

Kind regards,


0 Comments   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity


It looks like you might be using the option to email the query results to an address. That is normally used for debugging purposes. You should be specifying the email each recipient in query results option and creating a message template.
Answered 03/04/2016 by: chucksteel
Red Belt

Please log in to comment
I agree with Chuck Steel.  That looks like query results.  Here is a great article with many of the fields you are requesting.  Hopefully this will help you get the info you are looking for"
Answered 03/07/2016 by: Chris.Burgess
Orange Belt

Please log in to comment