Resolve 10k tickets

RT Users
1

over the weekend somebody in the office here created a loop in their
email, and i now have 10202 tickets that i need to reject

i cant do the “update multiple tickets”: via the web, as it will bog
sown the server, and probably not make it all the way.

is there a way via command line that one can resolve tickets from 48350
to *58550 http://rt.bizsys.tmcs/Ticket/Display.html?id=58550

2

Do you want to resolver or reject them …
if resolve then the best way is to write a script …not that hard
if reject , then whats wrong with:
mysql rt3
update Tickets set Status = “rejected” where id > 48349 and id < 58551
Roy

Chaim Rieger wrote:

3

rt edit ticket/48350-58550 set status=‘resolved’

That’s assuming RTSERVER, RTUSER and RTPASSWD environment variables are
set.

  • Dmitri.On Mon, 2006-10-09 at 09:12 -0700, Chaim Rieger wrote:

over the weekend somebody in the office here created a loop in their
email, and i now have 10202 tickets that i need to reject

i cant do the “update multiple tickets”: via the web, as it will bog
sown the server, and probably not make it all the way.

is there a way via command line that one can resolve tickets from 48350
to *58550 http://rt.bizsys.tmcs/Ticket/Display.html?id=58550

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

4

You might want to go straight to the database on this one.

-ToddOn Mon, Oct 09, 2006 at 09:12:14AM -0700, Chaim Rieger wrote:

over the weekend somebody in the office here created a loop in their
email, and i now have 10202 tickets that i need to reject

i cant do the “update multiple tickets”: via the web, as it will bog
sown the server, and probably not make it all the way.

is there a way via command line that one can resolve tickets from 48350
to *58550 http://rt.bizsys.tmcs/Ticket/Display.html?id=58550

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

5

i did

went right to mysql

Todd Chapman wrote: