Hi
Noob question here.
Trying to use rt-shredder from a bash script using a bash date variable
to wipeout tickets but shredder seems to ignore my date parameter which
I assume is because its badly formatted.
Have gotten this to work using a fixed date/time -
/#!/bin/sh//
//filename=date +%Y%m%dT%H%M%S-0001.sql//
///opt/rt4/sbin/rt-shredder --sqldump
/opt/stf/backups/rt-shredder/$filename --force --plugin Ti//
//ckets=query,"(Queue = ‘Supplier invoices’) AND status = ‘resolved’ AND//
// resolved > ‘2016-08-01 00:00:00.00’ ;limit,2000"/
but I would like it to work like this -
/#!/bin/sh//
//filename=date +%Y%m%dT%H%M%S-0001.sql//
//cutoff=date +%Y-%m-%d --date='2 years ago'//
//cutoff="’$cutoff 00:00:00’"//
//echo $cutoff//
///opt/rt4/sbin/rt-shredder --sqldump
/opt/stf/backups/rt-shredder/$filename --force --plugin Ti//
//ckets=query,"(Queue = ‘MCL - Supplier invoices’) AND status =
‘resolved’ AND resolved > $cuto//
//ff ;limit,2000"/
Is this possible from a bash script, any help greatly appreciated.
Kind Rgards
TomC
Hi
Noob question here.
Trying to use rt-shredder from a bash script using a bash date variable to
wipeout tickets but shredder seems to ignore my date parameter which I
assume is because its badly formatted.
Have gotten this to work using a fixed date/time -
#!/bin/sh
filename=date +%Y%m%dT%H%M%S-0001.sql
/opt/rt4/sbin/rt-shredder --sqldump /opt/stf/backups/rt-shredder/$filename
–force --plugin Ti
ckets=query,“(Queue = ‘Supplier invoices’) AND status = ‘resolved’ AND
resolved > ‘2016-08-01 00:00:00.00’ ;limit,2000”
but I would like it to work like this -
#!/bin/sh
filename=date +%Y%m%dT%H%M%S-0001.sql
cutoff=date +%Y-%m-%d --date='2 years ago'
cutoff=“‘$cutoff 00:00:00’”
echo $cutoff
/opt/rt4/sbin/rt-shredder --sqldump /opt/stf/backups/rt-shredder/$filename
–force --plugin Ti
ckets=query,“(Queue = ‘MCL - Supplier invoices’) AND status = ‘resolved’ AND
resolved > $cuto
ff ;limit,2000”
I believe shredder will respect relative time constraints:
1 day ago
etc.
You could try passing a relative date to shredder (thus bypassing the
call to date) and seeing if that works.
-m