[rt-users] Mail Loop 1000+ Bad Tickets

[Jason Maderios]

All,




My RT (1..0.6) got into a debate with a PVCS ticket system.  Apparently
they were arguing over who could get the last "Thank You- We recv'd your
response and it is being handled" in.  Now I have 1000+ open tickets
clogging my queue.  Anyone know the SQL statement to mysql in witch to
kill all tickets where requestor = "bad.boy at pvcs.machine" in a manner
where I do not break anything in RT?



TIA,

Jason Maderios
Lead Linux Administrator
TogetherSoft Corp.