Does anyone know what must be present in the select query for the "Results are tickets, add a comment to each one" feature to work?  Although the box is checked, my comments never show up in the tickets.  
2 Comments   [ + ] Show Comments

Comments

  • At a minimum I believe you need to return HD_TICKET.ID. Have you turned on the option to send the query results to an email to make sure it is matching the tickets you expect?
    • Chuck, in my select query I do have HD_TICKET.ID as ticknum. Perhaps I need it just as HD_TICKET.ID? The custom ticket rule also sends out an email which does work. I wanted to record within the ticket that the rule was activated.
      • Yes, I think there needs to be a column named ID returned. I know that KACE uses this in the <ticket_ids> variable that you can use in the update query and I'm assuming it uses the same method to add a comment to each ticket.
  • Chuck - that did it! Thanks again for your help!
Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity

Share