I am looking to do 1 of the following: 1. Have a scrip that removes the requestor on a specific queue if it matches X, X of course being a specific email address.
2. A SQL query that will accomplish the above that I could run from a cron job. I have a MySQL query I thought would work, essentially the following: /usr/local/mysql/bin/mysql -u dbauname rt3 -e "update Tickets set Creator='10' where Queue='7' and Creator='2653';" This does update the creator of a given ticket that matches userid 2653 and changes it to userid 10, which is the nobody user. Even though this works, I must be missing something because there are still tickets with requestors of the userid 2653 on the ticket and not Nobody. An easier and more efficient way of doing this would be on creation using a scrip. I have a scrip which works which upon creation sets the owner automatically. I'm sure its just a slight modification to that scrip, but I just can't quite find the object information I need. My Change Owner scrip contains the following: Condition: On Create Action: User Defined Template: Global template: Blank Stage: TransactionCreate Custom Condition: is blank Custom action preparation code: return 1; Custom action cleanup code: my $newowner = "kera"; $self->TicketObj->SetOwner( $newowner ); return 1; I'm sure if I knew the syntax to modify this to change the requestor on a ticket, it'd be easier. Essentially I want the requestor to be Nobody. Thanks, James James R. Price DigitalCiti.com 3636 S. Iron St., Chicago, IL 60609 Company Tel: 888.855.5550 My Tel/Fax/Cell: 800.603.0769 Web: www.digitalciti.com Email: [EMAIL PROTECTED] _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com