KACE Product Support

Ok so like all ticket rules BE CAREFUL!!!!

I've done something similar like this for a client before.

Create a new rule. Don't worry about running on a schedule or anything, you'll only need it once.

You could use this as a select to find all the tickets with an owner un-assigned before a given date.

Make sure you also change your queue id to match.
SELECT *
FROM HD_TICKET T
WHERE T.CREATED < '2012-02-01'
AND OWNER_ID = 0
AND HD_QUEUE_ID = 17
Here's the update command. What i did in the example was assign them all to myself.
UPDATE HD_TICKET
SET OWNER_ID = (SELECT ID
FROM USER
WHERE USER_NAME = 'DCHRISTIAN')
WHERE HD_TICKET.ID IN (<TICKET_IDS>)


What i would do to test is add the following line to the bottom of your select.
and ID = {NUMBER OF A BAD TICKET HERE, NO BRACKETS}
If that works as expected you could do it for all the tickets in the queue.

Thanks for the help, worked perfectly!