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…
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.
That’s all.-----Original Message-----
From: rt-users-admin@lists.fsck.com
[mailto:rt-users-admin@lists.fsck.com] On Behalf Of Per Kristiansen
Sent: February 2, 2002 10:03 PM
To: rt-users@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@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users
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:
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@lists.fsck.com
[mailto:rt-users-admin@lists.fsck.com] On Behalf Of Per Kristiansen
Sent: February 2, 2002 10:03 PM
To: rt-users@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@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users
rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users
Jim Meyer, Geek At Large purp@wildbrain.com
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:
- The problem is fixed and all new correspondence will happen as
it should (right? =),- The data is all in there,
- You’re working on getting the mail to happen.
It sounds like a reminder that stress kills might be in order, too.
Good luck!
Hehe…thanks
When I woke up today it turns out one of the other people working on it
had made a perl program tat fixed it…phu…sometimes I forget how truly
blessed it can be working with people who actually know stuff beyond their
immediate jobs 
Per Kristiansen
per@gathering.org