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! _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting f�r Ihr OTRS System? => http://www.otrs.de/
