Skip to content

Instantly share code, notes, and snippets.

@michelep

michelep/rt-daily

Created July 12, 2021 07:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save michelep/0b0fca7a7089d77e5f8e8e1feb2a17d6 to your computer and use it in GitHub Desktop.
Save michelep/0b0fca7a7089d77e5f8e8e1feb2a17d6 to your computer and use it in GitHub Desktop.
Download ZIP
Daily cron script for RR (RequestTracker) ticketing system
Raw
rt-daily
#!/bin/bash
#
# This daily cron script needed for maintain clean RT database: remove old rejected and deleted tickets, remove old resolved tickets
#
DATE=`date --i`
# Delete rejected and deleted old tickets
/opt/rt4/sbin/rt-shredder --sqldump /var/rt4/backup/RT_old_${DATE}.sql --plugin 'Tickets=query,(Status="deleted" OR Status="rejected") AND LastUpdated > "730 days ago";limit,100' --force 2>&1
# Delete resolved old tickets
# /opt/rt4/sbin/rt-shredder --sqldump /var/rt4/backup/RT_old_${DATE}.sql --plugin 'Tickets=query,Status="resolved" AND LastUpdated > "730 days ago";limit,100' --force 2>&1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment