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 -- Whatever happened to Preparations A through G? Have a great day and don't forget to laugh! http://www.gcfl.net (The Good, Clean Funnies List): Good, clean daily funnies you can safely tell your Mom!
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
I forgot you have to upgrade to 1.3.* for this. Then there is a easy to use webinterface for the GenericAgent. Yom Yom Schutte wrote:
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
Hello! On Mi, Mai 25, 2005 at 09:01:30 -0500, 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.
Please don't manipulate the queue directly via the database! that could result in a inconsistent system if you don't know exactly, what your are doing... [...]
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.
I'd update to 2.0- beta2 and use the bulk action for tickets. Or if the mails are marked as spam you could use the gneric agent to move all mails automaticly to another queue.
John
Best regards, Christian -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication!
participants (3)
-
Christian Schoepplein -
John Price -
Yom Schutte