[rt-users] RES: Generate end of the day report and email

Asanka Gunasekera asanka_gunasekera at yahoo.co.uk
Fri May 10 22:26:27 EDT 2013


Thank you Diaulas, this looks neet

Bet Regards


________________________________
 From: Diaulas Castro <diaulas.castro at intersolution.inf.br>
To: "rt-users at lists.bestpractical.com" <rt-users at lists.bestpractical.com> 
Sent: Friday, 10 May 2013, 21:42
Subject: [rt-users] RES:  Generate end of the day report and email
 


 
Made this bash script to accomplish using RT CLI.
 
Just customize “From:”,  To:” and “Status” search in rt ls command and schedule on crontab.
 
This script will list all tickets and mail fields to temp file after that a while loop will add html tags (tables and rows) trough command sed, so I got a nice looking mail report. (http://postimg.org/image/yfmlp9307/)
 
  If you want to color the rows use this before sendmail command:
 
  sed -i -e '/Nobody/s/D2EAF1/CCCCCC/g'          $MAIL
  sed -i -e '/diaulas.castro/s/D2EAF1/6FCCFF/g'   $MAIL
    This will change all tickets by nobody to gray and Diaulas.castro to light blue
 
 
PS: I know! RT-CRONTOOL exist, but I m not perl expert.. =(
 
 
 
####################################
export RTORDERBY=owner
 
MAIL=/tmp/rel_todos_tickets_abertos.sh.mail
echo "From: MY_TICKET at MY_DOMAIN.COM "                > $MAIL
echo "To: DIRECTORS at MYDOMAIN.COM"     >> $MAIL
echo "MIME-Version: 1.0"                                >> $MAIL
echo 'Content-type: text/html; charset=iso-8859-1'      >> $MAIL
echo " boundary=`date +%s`/rt.MY.DOMAIN.COM"     >> $MAIL
echo "Subject: All open Tickets:$(date +%d/%m/%y)"       >> $MAIL
echo ""                                                 >> $MAIL
echo "<html>"                                           >> $MAIL
echo "<HEAD>"                                           >> $MAIL
echo "</HEAD>"                                          >> $MAIL
echo "<BODY>"                                           >> $MAIL
echo "<span style=\'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D\'>" >> $MAIL
echo "<table>">>                                        $MAIL
 
/usr/bin/rt ls "Status != resolved AND Status != report AND Status != plantao AND Status != stalled" -f id,subject,queue,status,owner,lastupdated |iconv -f UTF-8 -t ISO8859-1 > /tmp/rel.tmp
while read line ; do
  echo  "<span style='color:#000000'><TR><TD style='background:#D2EAF1;padding:0cm 5.4pt 0cm 5.4pt'>$line</TD></TR></span" | sed "s/    /<TD style='background:#D2EAF1'>/g"
 
done < /tmp/rel.tmp >> $MAIL
 
echo "</table>">> $MAIL
echo "</BODY>"                                          >> $MAIL
echo "</html>"                                          >> $MAIL
 
/usr/sbin/sendmail -t < $MAIL
 
 
 
De:rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] Em nome de Asanka Gunasekera
Enviada em: sexta-feira, 10 de maio de 2013 05:48
Para: rt-users at lists.bestpractical.com
Assunto: [rt-users] Generate end of the day report and email
 
Hi, is there any way to auto generate end of the day report and emal this to management (all open, all new etc)
 
I am using RT4 and oracle database on redhat
 
Thanks and Regards


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130511/45718f54/attachment.htm>


More information about the rt-users mailing list