Cleaning up resolved messages

I did post this before but no response was recieved so I thought I would try
again incase it was missed over your weekend.

How do you guys go about purging resolved messages?

ie. we want to keep them on the system for an arbitrary period of time and
then remove them so the resolved list is not toooo huge.

Hello this is “not recommended” but , we wrote a script to do this because
we also delete tickets due to our high ticket volume.

I wrote a script that delete dead tickets from the database. What you can do
for example is to do a search on resolved tickets that are 1 month old and
to do a mass update on them and set status to dead.

Then you just run this script and it delete all the tickets.

Script is available at:
http://dev.inet-technologies.com/rt2/

Steve Poirier
Directeur d�veloppement / Project Manager
Inet-Technologies inc.From: “Matthew Frick” mfrick@learnedsolutions.com
To: “rt-users” rt-users@lists.fsck.com
Sent: Monday, August 20, 2001 9:15 PM
Subject: [rt-users] cleaning up resolved messages.

I did post this before but no response was recieved so I thought I would
try
again incase it was missed over your weekend.

How do you guys go about purging resolved messages?

ie. we want to keep them on the system for an arbitrary period of time and
then remove them so the resolved list is not toooo huge.


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users