KACE: Custom Ticket Rule to Prevent Email Loops
The way this will work is it sets the submitter to unassigned so that Kace doesn't have an email to send it back to. When Kace receives an email, it will automatically send a confirmation back to the user, unless you have that option turned off. If it is received from an unknown or outside user, Kace will create an account for them when you have the "Accept email from unknown users" option checked. If an email address is listed in this custom ticket rule, once it saves the ticket (which it does on creation), it sets it to Unassigned for the submitter. While the system will send one email out when it creates the ticket, and the end system may send a reply, Kace will not send anything back out again, because the ticket does not have a submitter for it. So, you stop the email loop after one replied email, instead of a timed interval.
WARNING: This will execute an update query on the database. Proceed carefully. You are responsible for damages to the database.
1. Go to Helpdesk>Configuration>Rules
2. Click on Choose Action>New (Wizard)
3. Choose "Ticket Submitter User Name", select "=", and then type the email address you want to block (or anything, for that matter. will be changed later), then Next
4. Choose "Ticket Submitter User Name" again, ("change value to" should be selected), then put a 0 in the change to field. Click Done.
5. On the next screen, you will see the SQL select query. Scroll to the bottom to the where clause. Find the
USER.USER_NAME = 'firstname.lastname@example.org' entry.
Change it to
USER.EMAIL RLIKE 'email@example.comfirstname.lastname@example.orgemail@example.com'
The Syntax is important here. USER.EMAIL matches the email account of the submitter. RLIKE matches a regular expression, which in this case is a pipe (|) delimited list (or just one email. thats up to your situation) in single quotes. Do not delete any of the parenthesis. This may break your query.
6. You can preview the tickets it will find before applying the rule by clicking the "View Ticket Search Results" link.
7. Check "Email results" and enter your email if you'd like to be notified when the rule is fired off.
8. Verify the "Run update query" box is checked, and that it has:
update HD_TICKET, USER as T5
set HD_TICKET.SUBMITTER_ID = 0
(HD_TICKET.ID in (<TICKET_IDS>))
In the box. This will set the submitter to "Unassigned", virtually eliminating the reply to address.
9. Set the schedule to "On Ticket Save"