KACE Product Support

I played with this along with a tip from GillySpy how to specify an email address in the Email Column field and cam up with the following. Working fine here, although not sure if it's entirely clean. Hopefully this can save someone else some time.

John
______________________________

Title:
Unassigned Tickets

Order:
11

Notes:
Sends an email when a ticket has sat in queue longer than specified period (1 hour).

Frequency:
15 minutes

Select Query:
Select 'you@company.com' as SUPPORT, T.ID as ID, T.TITLE as Issue, S.FULL_NAME as Submitter, T.CREATED as Created FROM HD_TICKET T
JOIN USER S ON (S.ID = T.SUBMITTER_ID)
WHERE T.CREATED < SUBDATE(NOW(), INTERVAL 1 HOUR)
AND T.OWNER_ID = 0
ORDER BY T.ID ASC

______________________________

X Send an email for each result row

Subject:
Unassigned Ticket

Email Column:
SUPPORT

Email Body:
Unassiged ticket in queue, please review.

$created
$id
$issue
$submitter
______________________________

Hey James,

You can definitely do this with a ticket rule mate. You could write something a bit like this

Select T.ID as TicketID, T.TITLE as TicketTitle, T.CREATED as TicketCreated
FROM HD_TICKET T
WHERE T.CREATED < SUBDATE(NOW(), INTERVAL 2 DAY)
AND T.OWNER_ID = 0
ORDER BY T.CREATED ASC

You could set as a result to this to email certain people with the details of the tickets it outputs.
I'd set this rule to run on a schedule, maybe every 2 hours.

-Dave

Thanks, let me see what I can break, er do.

One tweak I made to the Email Body section for clairty:

Unassiged ticket in queue, please review.

Created: $created
Ticket ID: $id
Issue: $issue
Submitter: $submitter