Re: [rt-users] RES: RES: Generate end of the day report and email
Hi Diaulas, thank you for the reply but the thing is I am unable to log in to the RT when I do below export RTSERVER=http://localhost and do rt ls it prompt me for a password once I enter the password and hit enter I get below error Query:Status!='resolved' and Status!='rejected' Strong encryption not available, switched off by externalauth=0 Password will be sent to localhost unencrypted Press CTRL-C now if you do not want to continue Password: rt: Server error: Forbidden (403) As the URL I tried http://x.x.x.x as well but with the same error Thanks and Regards From: Diaulas Castro diaulas.cas...@intersolution.inf.br To: Asanka Gunasekera asanka_gunasek...@yahoo.co.uk; rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com Sent: Wednesday, 22 May 2013, 17:20 Subject: RES: [rt-users] RES: Generate end of the day report and email Sorry, didnt understand your message, but from your log I think you don’t have RTSERVER variable, Try to add on top of script: export RTSERVER=your.rt.installation if you got error try to execute a simple /usr/bin/rt ls TICKET_NUMBER That script relies on output of RT CLI command. De:Asanka Gunasekera [mailto:asanka_gunasek...@yahoo.co.uk] Enviada em: quarta-feira, 22 de maio de 2013 08:38 Para: Diaulas Castro; rt-users@lists.bestpractical.com Assunto: Re: [rt-users] RES: Generate end of the day report and email Hi Diaulas, can you tell me the user name that the rt command is looking for since I put root (of rt) and tried some and other rt account as well, but I am getting below error Query:Status!='resolved' and Status!='rejected' rt: Server error: Forbidden (403) Thank you and Best Regards From:Diaulas Castro diaulas.cas...@intersolution.inf.br To: rt-users@lists.bestpractical.com rt-users@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/CC/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@MY_DOMAIN.COM $MAIL echo To: direct...@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:#00'TRTD 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-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Asanka Gunasekera Enviada em: sexta-feira, 10 de maio de 2013 05:48 Para: rt-users@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 -- RT Training in Seattle, June 19-20: http://bestpractical.com/training
[rt-users] RES: RES: Generate end of the day report and email
Sorry, didnt understand your message, but from your log I think you don’t have RTSERVER variable, Try to add on top of script: export RTSERVER=your.rt.installation if you got error try to execute a simple /usr/bin/rt ls TICKET_NUMBER That script relies on output of RT CLI command. De: Asanka Gunasekera [mailto:asanka_gunasek...@yahoo.co.uk] Enviada em: quarta-feira, 22 de maio de 2013 08:38 Para: Diaulas Castro; rt-users@lists.bestpractical.com Assunto: Re: [rt-users] RES: Generate end of the day report and email Hi Diaulas, can you tell me the user name that the rt command is looking for since I put root (of rt) and tried some and other rt account as well, but I am getting below error Query:Status!='resolved' and Status!='rejected' rt: Server error: Forbidden (403) Thank you and Best Regards From: Diaulas Castro diaulas.cas...@intersolution.inf.brmailto:diaulas.cas...@intersolution.inf.br To: rt-users@lists.bestpractical.commailto:rt-users@lists.bestpractical.com rt-users@lists.bestpractical.commailto:rt-users@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/CC/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@MY_DOMAIN.COMmailto:MY_TICKET@MY_DOMAIN.COM $MAIL echo To: direct...@mydomain.commailto:direct...@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:#00'TRTD 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-boun...@lists.bestpractical.commailto:rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Asanka Gunasekera Enviada em: sexta-feira, 10 de maio de 2013 05:48 Para: rt-users@lists.bestpractical.commailto:rt-users@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 -- RT Training in Seattle, June 19-20: http://bestpractical.com/training
[rt-users] RES: RES: Generate end of the day report and email
Already saw, but I have so many reports and alerts by mail and some of them I cant get with dashboard/subscribe so I made some bash scripts and all of reports/alerts have the same style/looking. I have one that alert 2 times/day, he send mail to requestor telling that ticket # is awaiting for response, but I need it with same subject since the requestor reply will create new ticket . PS: I Have huge red colored text telling to not reply. I forgot dashboard/subscription when Asanka asked for this. -Mensagem original- De: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] Em nome de Thomas Sibley Enviada em: sexta-feira, 10 de maio de 2013 13:54 Para: rt-users@lists.bestpractical.com Assunto: Re: [rt-users] RES: Generate end of the day report and email On 05/10/2013 09:12 AM, Diaulas Castro wrote: Made this bash script to accomplish using RT CLI. Just customize “From:”, To:” and “Status” search in rt ls command and schedule on crontab. You really want to look at dashboards and dashboard subscriptions in RT's web interface. -- RT Training in Seattle, June 19-20: http://bestpractical.com/training -- RT Training in Seattle, June 19-20: http://bestpractical.com/training
Re: [rt-users] RES: RES: Generate end of the day report and email
On 05/10/2013 10:52 AM, Diaulas Castro wrote: Already saw, but I have so many reports and alerts by mail and some of them I cant get with dashboard/subscribe so I made some bash scripts and all of reports/alerts have the same style/looking. I have one that alert 2 times/day, he send mail to requestor telling that ticket # is awaiting for response, but I need it with same subject since the requestor reply will create new ticket . PS: I Have huge red colored text telling to not reply. That sounds like you want rt-crontool. I know you said you had no experience with it, but try starting with our draft of expanded rt-crontool docs: https://github.com/bestpractical/rt/blob/4.0/add-rt-crontool-docs/docs/automating_rt.pod -- RT Training in Seattle, June 19-20: http://bestpractical.com/training