Why dont you use the GenericAgent. This tool is made for this problem. Yom John Price wrote:
I managed to get about 1,100 SPAM messages into the receiving queue and I would like a quick way to move them to the spam queue (so they will get removed).
I thought about manipulating the SQL database directly, but I can't find the correct tables and columns to change to move a ticket from one queue to another.
I think I can use a SELECT statement with "where a_subject like '%text%'" to find the tickets I need to move, but can someone explain how the tickets are assigned to queues (or point me to some documentation on this)?
I'm running version 1.2.4, so if there is a better way to do this in this or a newer version, I'd be willing to upgrade or take another approach.
Thanks for the help and the great product!
John