Mail Loop 1000+ Bad Tickets

#1

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@pvcs.machine” in a manner
where I do not break anything in RT?

TIA,

Jason Maderios
Lead Linux Administrator
TogetherSoft Corp.

#2

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@pvcs.machine” in a manner
where I do not break anything in RT?

Something like this will do. You could also add commands within the loop
to remove those RT1 transaction files which are clogging up your disk.

$ for rt in rtq queuename -open -user bad.boy@pvcs.machine | \ perl -e 'while(<>){chomp;print "$1\n" if(m/^\s*(\d+)\s+/);}' ; do
echo “yes” | rt -kill $rt ;
done

                         Bruce Campbell                            RIPE
                                                                    NCC
                                                             Operations