KACE: Email Owner on Ticket Creation
I would like a rule that emails the owner on ticket creation. I've seen similar rules to trigger email events, but I don't know SQL well enough to figure out how to change that code to do what I want.
I am trying to use the article from KACE here: http://www.kace.com/support/resources/kb/article/How-To-Notify-Any-User-or-Group-by-Email-When-a-New-Help-Desk
When I use the SQL statement in the article as is (with changes to our URL and email address) it sends me the query results, but is not sending the assigned owner an email. I have rules set up to auto-assign tickets to owners based on our location field. I have the assign rule run first and then the email owner rule run next.
This is not really relevant, but the sql query that it sends me every time is basically unreadable in columns that are super narrow. How do I change that format?