[rt-users] HELP..I messed up..and I have 800 pissed off people on my neck.

[Jim Meyer]

On Sat, 2002-02-02 at 19:15, Kristopher Lalletti wrote:
> Make a small perl script that connects via DBI to the database.
> 
> Issue a select statement to get all your tickets between a certain time
> frame, and related data.
> 
> Foreach ticket, send out an email based on the content you want to send
> and whatever you want.

Particularly (and this is in my Postgres DB, but should work in any SQL
DB) this query gets me a list of the correspondence since midnight AM
UTC Jan 13 2002:

SELECT * FROM attachments WHERE created > '2002-01-31 00:00:00' AND
content != '';

I haven't figured out how to relate this to a ticket and queue (and thus
get the list of who to send it to) and unfortunately I've got to run for
a while. I'll have a peek at this later today if I can make some time
and see if I can share anything more.

Meanwhile, let the 800 people know three things:

0) The problem is fixed and all new correspondence will happen as
   it should (right? =),
1) The data is all in there,
2) You're working on getting the mail to happen.

It sounds like a reminder that stress kills might be in order, too.

Good luck!

--j

> 
> That's all.
> 
> -----Original Message-----
> From: rt-users-admin at lists.fsck.com
> [mailto:rt-users-admin at lists.fsck.com] On Behalf Of Per Kristiansen
> Sent: February 2, 2002 10:03 PM
> To: rt-users at lists.fsck.com
> Subject: [rt-users] HELP..I messed up..and I have 800 pissed off people
> on my neck.
> 
> okay..bear with me here...
> I just made a Horrible error...
> for the last two days we've been working on clearing out some queus
> after
> a service got run over by a herd of eager users..
> 
> all starts out well..but the I move all scripts to global..and I forgot
> one..
> the one that sends mail to the requestor when we reply to his message..
> 
> is there ANY way to resend ALL correspondance after a certain time..
> please I'm desperate...
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
-- 
Jim Meyer, Geek At Large                              purp at wildbrain.com