Bulk changes to tickets?

Hello,

I’m wondering if it’s possible to make a bulk change to
my RT database? I’ve got a pile of sysadmin tickets, and
have decided to start subcategorising them with custom fields.
There’s around 500 or so tickets in my queue, and I want to be able to
add/set a value in my custom field for that queue for tickets
that match a search criteria. Eg: I want to set the
"job type" custom field to “DNS renewals” for all the
tickets that match “content = domain renewal”.

Is there a supported way to do this or should I do it through
mysql? I’m running RT 3.0.10 at the moment … looking to upgrade to
3.2.0 soon.

thanks!

Carl

Vivitec Pty. Ltd.
Suite 6, 51-55 City Rd.
Southbank, 3006.
Ph. +61 3 8626 5626
Fax +61 3 9682 1000