<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Hi Diaulas, thanks you for your help, it works :) there was some control charactors in the file, I guess when I copy the script from my machine to linex</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal;"><span><br></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal;"><span>Thank you for the help</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal;"><span><br></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york',
times, serif; background-color: transparent; font-style: normal;"><span>Best Of regards</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal;"><span><br></span></div><div><br></div> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font size="2" face="Arial"> <b><span style="font-weight:bold;">From:</span></b> Asanka Gunasekera <asanka_gunasekera@yahoo.co.uk><br> <b><span style="font-weight: bold;">To:</span></b> Asanka Gunasekera <asanka_gunasekera@yahoo.co.uk>; Diaulas Castro <diaulas.castro@intersolution.inf.br> <br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, 16 July 2013, 14:43<br> <b><span style="font-weight: bold;">Subject:</span></b> Re:
RES: RES: RES: RES: [rt-users] RES: Generate end of the day report and email<br> </font> </div> <div class="y_msg_container"><br><div id="yiv8221521285"><div><div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"><div><span>Hi, Diaulas found what was wrong. the rt process owner was a user called apache, after su to apache and was able to login to RT CLI. But when I ran your script I am getting am empty mail.</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal;"><span><br></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: 'times new roman', 'new york', times, serif; background-color: transparent; font-style: normal;"><span>Thanks and best regards</span></div><div><br></div> <div style="font-family: 'times new roman', 'new
york', times, serif; font-size: 12pt;"> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font size="2" face="Arial"> <b><span style="font-weight:bold;">From:</span></b> Asanka Gunasekera <asanka_gunasekera@yahoo.co.uk><br> <b><span style="font-weight:bold;">To:</span></b> Diaulas Castro <diaulas.castro@intersolution.inf.br> <br> <b><span style="font-weight:bold;">Sent:</span></b> Tuesday, 4 June 2013, 10:15<br> <b><span style="font-weight:bold;">Subject:</span></b> Re: RES: RES: RES: RES: [rt-users] RES: Generate end of the day report and email<br> </font> </div> <div class="yiv8221521285y_msg_container"><br><div id="yiv8221521285"><div><div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"><div style="font-family: 'times new roman', 'new york', times, serif; font-size:
12pt;"><span>Hi Diaulas tanks you for the reply but I tryed below</span></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><span><br></span></div><div style="background-color:transparent;"><span style="font-style:italic;">[root@iilrt bin]# export RTSERVER=http://192.168.11.39</span></div><div style="background-color:transparent;"><span style="font-style:italic;">[root@iilrt bin]#</span></div><div style="background-color:transparent;"><span style="font-style:italic;">[root@iilrt bin]#</span></div><div style="background-color:transparent;"><span style="font-style:italic;">[root@iilrt bin]# ./rt ls</span></div><div style="background-color:transparent;"><span style="font-style:italic;">Query:Status!='resolved' and Status!='rejected'</span></div><div style="background-color:transparent;"><span style="font-style:italic;"> Strong
encryption not available, switched off by externalauth=0</span></div><div style="background-color:transparent;"><span style="font-style:italic;"> Password will be sent to
192.168.11.39 unencrypted</span></div><div style="background-color:transparent;"><span style="font-style:italic;"> Press CTRL-C now if you do not want to continue</span></div><div style="background-color:transparent;"><span style="font-style:italic;">Password:</span></div><div style="background-color:transparent;"><span style="font-style:italic;">rt: Server error: Forbidden (403)</span></div><div style="background-color:transparent;"><span style="font-style:italic;">[root@iilrt bin]# export
RTSERVER=192.168.11.39</span></div><div style="background-color:transparent;"><span style="font-style:italic;">[root@iilrt bin]#</span></div><div style="background-color:transparent;"><span style="font-style:italic;">[root@iilrt bin]#</span></div><div style="background-color:transparent;"><span style="font-style:italic;">[root@iilrt bin]# ./rt ls</span></div><div style="background-color:transparent;"><span style="font-style:italic;">Query:Status!='resolved' and Status!='rejected'</span></div><div style="background-color:transparent;"><span style="font-style:italic;"> Strong encryption not available, switched off by externalauth=0</span></div><div style="background-color:transparent;"><span style="font-style:italic;"> Password will be sent to 192.168.11.39 unencrypted</span></div><div style="background-color:transparent;"><span style="font-style:italic;"> Press CTRL-C now if you do not want to
continue</span></div><div style="background-color:transparent;"><span style="font-style:italic;">Password:</span></div><div style="background-color:transparent;"><span style="font-style:italic;"></span></div><div style="background-color:transparent;"><span style="font-style:italic;">rt: Server error: URL must be absolute (400)</span></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"><br></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;"><br></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;">I simply cnat get connected to RT</div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style:
normal;"><br></div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 16px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal;">Best Regards</div><div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"><br></div> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div style="font-family: 'times new roman', 'new york', times, serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font size="2" face="Arial"> <b><span style="font-weight:bold;">From:</span></b> Diaulas Castro <diaulas.castro@intersolution.inf.br><br> <b><span style="font-weight:bold;">To:</span></b> Asanka Gunasekera <asanka_gunasekera@yahoo.co.uk> <br> <b><span style="font-weight:bold;">Sent:</span></b> Friday, 31 May 2013, 17:09<br> <b><span style="font-weight:bold;">Subject:</span></b> RES: RES: RES: RES: [rt-users] RES: Generate end of the day
report
and email<br> </font> </div> <div class="yiv8221521285y_msg_container"><br><div id="yiv8221521285">
<style><!--
#yiv8221521285
filtered {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;}
#yiv8221521285 filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
#yiv8221521285 filtered {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
#yiv8221521285 filtered {font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;}
#yiv8221521285
p.yiv8221521285MsoNormal, #yiv8221521285 li.yiv8221521285MsoNormal, #yiv8221521285 div.yiv8221521285MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 a:link, #yiv8221521285 span.yiv8221521285MsoHyperlink
{
color:blue;text-decoration:underline;}
#yiv8221521285 a:visited, #yiv8221521285 span.yiv8221521285MsoHyperlinkFollowed
{
color:purple;text-decoration:underline;}
#yiv8221521285 pre
{
margin:0cm;margin-bottom:.0001pt;font-size:10.0pt;font-family:"Courier New";}
#yiv8221521285 p.yiv8221521285MsoAcetate, #yiv8221521285 li.yiv8221521285MsoAcetate, #yiv8221521285 div.yiv8221521285MsoAcetate
{
margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma", "sans-serif";}
#yiv8221521285 span.yiv8221521285Pr-formataoHTMLChar
{
font-family:Consolas;}
#yiv8221521285 p.yiv8221521285msoacetate, #yiv8221521285 li.yiv8221521285msoacetate, #yiv8221521285 div.yiv8221521285msoacetate
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msonormal, #yiv8221521285 li.yiv8221521285msonormal, #yiv8221521285 div.yiv8221521285msonormal
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msochpdefault, #yiv8221521285 li.yiv8221521285msochpdefault, #yiv8221521285 div.yiv8221521285msochpdefault
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msonormal1, #yiv8221521285 li.yiv8221521285msonormal1, #yiv8221521285 div.yiv8221521285msonormal1
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msoacetate1, #yiv8221521285 li.yiv8221521285msoacetate1, #yiv8221521285 div.yiv8221521285msoacetate1
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msochpdefault1, #yiv8221521285 li.yiv8221521285msochpdefault1, #yiv8221521285 div.yiv8221521285msochpdefault1
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msonormal2, #yiv8221521285 li.yiv8221521285msonormal2, #yiv8221521285 div.yiv8221521285msonormal2
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msoacetate2, #yiv8221521285 li.yiv8221521285msoacetate2, #yiv8221521285 div.yiv8221521285msoacetate2
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msonormal3, #yiv8221521285 li.yiv8221521285msonormal3, #yiv8221521285 div.yiv8221521285msonormal3
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msochpdefault2, #yiv8221521285 li.yiv8221521285msochpdefault2, #yiv8221521285 div.yiv8221521285msochpdefault2
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msonormal11, #yiv8221521285 li.yiv8221521285msonormal11, #yiv8221521285 div.yiv8221521285msonormal11
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msoacetate11, #yiv8221521285 li.yiv8221521285msoacetate11, #yiv8221521285 div.yiv8221521285msoacetate11
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msochpdefault11, #yiv8221521285 li.yiv8221521285msochpdefault11, #yiv8221521285 div.yiv8221521285msochpdefault11
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msonormal4, #yiv8221521285 li.yiv8221521285msonormal4, #yiv8221521285 div.yiv8221521285msonormal4
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msoacetate3, #yiv8221521285 li.yiv8221521285msoacetate3, #yiv8221521285 div.yiv8221521285msoacetate3
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msonormal5, #yiv8221521285 li.yiv8221521285msonormal5, #yiv8221521285 div.yiv8221521285msonormal5
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msochpdefault3, #yiv8221521285 li.yiv8221521285msochpdefault3, #yiv8221521285 div.yiv8221521285msochpdefault3
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msonormal12, #yiv8221521285 li.yiv8221521285msonormal12, #yiv8221521285 div.yiv8221521285msonormal12
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msoacetate12, #yiv8221521285 li.yiv8221521285msoacetate12, #yiv8221521285 div.yiv8221521285msoacetate12
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msochpdefault12, #yiv8221521285 li.yiv8221521285msochpdefault12, #yiv8221521285 div.yiv8221521285msochpdefault12
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msonormal21, #yiv8221521285 li.yiv8221521285msonormal21, #yiv8221521285 div.yiv8221521285msonormal21
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msoacetate21, #yiv8221521285 li.yiv8221521285msoacetate21, #yiv8221521285 div.yiv8221521285msoacetate21
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msonormal31, #yiv8221521285 li.yiv8221521285msonormal31, #yiv8221521285 div.yiv8221521285msonormal31
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msochpdefault21, #yiv8221521285 li.yiv8221521285msochpdefault21, #yiv8221521285 div.yiv8221521285msochpdefault21
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msonormal111, #yiv8221521285 li.yiv8221521285msonormal111, #yiv8221521285 div.yiv8221521285msonormal111
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msoacetate111, #yiv8221521285 li.yiv8221521285msoacetate111, #yiv8221521285 div.yiv8221521285msoacetate111
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msochpdefault111, #yiv8221521285 li.yiv8221521285msochpdefault111, #yiv8221521285 div.yiv8221521285msochpdefault111
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 span.yiv8221521285msohyperlink
{}
#yiv8221521285 span.yiv8221521285msohyperlinkfollowed
{}
#yiv8221521285 span.yiv8221521285pr-formataohtmlchar
{}
#yiv8221521285 span.yiv8221521285msohyperlink1
{}
#yiv8221521285 span.yiv8221521285msohyperlinkfollowed1
{}
#yiv8221521285 span.yiv8221521285pr-formataohtmlchar2
{}
#yiv8221521285 span.yiv8221521285msohyperlink21
{}
#yiv8221521285 span.yiv8221521285msohyperlinkfollowed21
{}
#yiv8221521285 span.yiv8221521285msohyperlink111
{}
#yiv8221521285 span.yiv8221521285msohyperlinkfollowed111
{}
#yiv8221521285 span.yiv8221521285estilodeemail17111
{}
#yiv8221521285 span.yiv8221521285textodebalochar111
{}
#yiv8221521285 span.yiv8221521285estilodeemail3111
{}
#yiv8221521285 span.yiv8221521285textodebalochar21
{}
#yiv8221521285 span.yiv8221521285pr-formataohtmlchar11
{}
#yiv8221521285 span.yiv8221521285estilodeemail501
{}
#yiv8221521285 span.yiv8221521285textodebalochar1
{}
#yiv8221521285 span.yiv8221521285estilodeemail74
{}
#yiv8221521285 span.yiv8221521285textodebalochar
{}
#yiv8221521285 p.yiv8221521285msonormal6, #yiv8221521285 li.yiv8221521285msonormal6, #yiv8221521285 div.yiv8221521285msonormal6
{
margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 span.yiv8221521285msohyperlink2
{
color:blue;text-decoration:underline;}
#yiv8221521285 span.yiv8221521285msohyperlinkfollowed2
{
color:purple;text-decoration:underline;}
#yiv8221521285 p.yiv8221521285msoacetate4, #yiv8221521285 li.yiv8221521285msoacetate4, #yiv8221521285 div.yiv8221521285msoacetate4
{
margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 span.yiv8221521285pr-formataohtmlchar1
{
font-family:Consolas;}
#yiv8221521285 p.yiv8221521285msonormal7, #yiv8221521285 li.yiv8221521285msonormal7, #yiv8221521285 div.yiv8221521285msonormal7
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msochpdefault4, #yiv8221521285 li.yiv8221521285msochpdefault4, #yiv8221521285 div.yiv8221521285msochpdefault4
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msonormal13, #yiv8221521285 li.yiv8221521285msonormal13, #yiv8221521285 div.yiv8221521285msonormal13
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msoacetate13, #yiv8221521285 li.yiv8221521285msoacetate13, #yiv8221521285 div.yiv8221521285msoacetate13
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msochpdefault13, #yiv8221521285 li.yiv8221521285msochpdefault13, #yiv8221521285 div.yiv8221521285msochpdefault13
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msonormal22, #yiv8221521285 li.yiv8221521285msonormal22, #yiv8221521285 div.yiv8221521285msonormal22
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msoacetate22, #yiv8221521285 li.yiv8221521285msoacetate22, #yiv8221521285 div.yiv8221521285msoacetate22
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msonormal32, #yiv8221521285 li.yiv8221521285msonormal32, #yiv8221521285 div.yiv8221521285msonormal32
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msochpdefault22, #yiv8221521285 li.yiv8221521285msochpdefault22, #yiv8221521285 div.yiv8221521285msochpdefault22
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msonormal112, #yiv8221521285 li.yiv8221521285msonormal112, #yiv8221521285 div.yiv8221521285msonormal112
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msoacetate112, #yiv8221521285 li.yiv8221521285msoacetate112, #yiv8221521285 div.yiv8221521285msoacetate112
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msochpdefault112, #yiv8221521285 li.yiv8221521285msochpdefault112, #yiv8221521285 div.yiv8221521285msochpdefault112
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msonormal41, #yiv8221521285 li.yiv8221521285msonormal41, #yiv8221521285 div.yiv8221521285msonormal41
{
margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 span.yiv8221521285msohyperlink11
{
color:blue;text-decoration:underline;}
#yiv8221521285 span.yiv8221521285msohyperlinkfollowed11
{
color:purple;text-decoration:underline;}
#yiv8221521285 p.yiv8221521285msoacetate31, #yiv8221521285 li.yiv8221521285msoacetate31, #yiv8221521285 div.yiv8221521285msoacetate31
{
margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 span.yiv8221521285pr-formataohtmlchar21
{
font-family:Consolas;}
#yiv8221521285 p.yiv8221521285msonormal51, #yiv8221521285 li.yiv8221521285msonormal51, #yiv8221521285 div.yiv8221521285msonormal51
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msochpdefault31, #yiv8221521285 li.yiv8221521285msochpdefault31, #yiv8221521285 div.yiv8221521285msochpdefault31
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msonormal121, #yiv8221521285 li.yiv8221521285msonormal121, #yiv8221521285 div.yiv8221521285msonormal121
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msoacetate121, #yiv8221521285 li.yiv8221521285msoacetate121, #yiv8221521285 div.yiv8221521285msoacetate121
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msochpdefault121, #yiv8221521285 li.yiv8221521285msochpdefault121, #yiv8221521285 div.yiv8221521285msochpdefault121
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msonormal211, #yiv8221521285 li.yiv8221521285msonormal211, #yiv8221521285 div.yiv8221521285msonormal211
{
margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 span.yiv8221521285msohyperlink211
{
color:blue;text-decoration:underline;}
#yiv8221521285 span.yiv8221521285msohyperlinkfollowed211
{
color:purple;text-decoration:underline;}
#yiv8221521285 p.yiv8221521285msoacetate211, #yiv8221521285 li.yiv8221521285msoacetate211, #yiv8221521285 div.yiv8221521285msoacetate211
{
margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msonormal311, #yiv8221521285 li.yiv8221521285msonormal311, #yiv8221521285 div.yiv8221521285msonormal311
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msochpdefault211, #yiv8221521285 li.yiv8221521285msochpdefault211, #yiv8221521285 div.yiv8221521285msochpdefault211
{
margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 p.yiv8221521285msonormal1111, #yiv8221521285 li.yiv8221521285msonormal1111, #yiv8221521285 div.yiv8221521285msonormal1111
{
margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 span.yiv8221521285msohyperlink1111
{
color:blue;text-decoration:underline;}
#yiv8221521285 span.yiv8221521285msohyperlinkfollowed1111
{
color:purple;text-decoration:underline;}
#yiv8221521285 p.yiv8221521285msoacetate1111, #yiv8221521285 li.yiv8221521285msoacetate1111, #yiv8221521285 div.yiv8221521285msoacetate1111
{
margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma", "sans-serif";}
#yiv8221521285 span.yiv8221521285estilodeemail171111
{
font-family:"Calibri", "sans-serif";color:#1F497D;}
#yiv8221521285 span.yiv8221521285textodebalochar1111
{
font-family:"Tahoma", "sans-serif";}
#yiv8221521285 p.yiv8221521285msochpdefault1111, #yiv8221521285 li.yiv8221521285msochpdefault1111, #yiv8221521285 div.yiv8221521285msochpdefault1111
{
margin-right:0cm;margin-left:0cm;font-size:10.0pt;font-family:"Times New Roman", "serif";}
#yiv8221521285 span.yiv8221521285estilodeemail31111
{
font-family:"Calibri", "sans-serif";color:#1F497D;}
#yiv8221521285 span.yiv8221521285textodebalochar211
{
font-family:"Tahoma", "sans-serif";}
#yiv8221521285 span.yiv8221521285pr-formataohtmlchar111
{
font-family:"Courier New";}
#yiv8221521285 span.yiv8221521285estilodeemail5011
{
font-family:"Calibri", "sans-serif";color:#1F497D;}
#yiv8221521285 span.yiv8221521285textodebalochar11
{
font-family:"Tahoma", "sans-serif";}
#yiv8221521285 span.yiv8221521285estilodeemail741
{
font-family:"Calibri", "sans-serif";color:#1F497D;}
#yiv8221521285 span.yiv8221521285textodebalochar2
{
font-family:"Tahoma", "sans-serif";}
#yiv8221521285 span.yiv8221521285EstiloDeEmail112
{
font-family:"Calibri", "sans-serif";color:#1F497D;}
#yiv8221521285 span.yiv8221521285TextodebaloChar
{
font-family:"Tahoma", "sans-serif";}
#yiv8221521285 .yiv8221521285MsoChpDefault
{
font-size:10.0pt;}
#yiv8221521285 filtered {
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
#yiv8221521285 div.yiv8221521285WordSection1
{}
--></style>
<div>
<div class="yiv8221521285WordSection1">
<div class="yiv8221521285MsoNormal"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">Try to use 192.168.11.39 as RTSERVER variable.</span></div>
<div class="yiv8221521285MsoNormal"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span></div>
<div>
<div class="yiv8221521285MsoNormal"><span lang="EN-US" style="font-size:11.0pt;color:#0070C0;"> </span></div>
<div class="yiv8221521285MsoNormal"><span style="font-size:11.0pt;color:#0070C0;">Diaulas Castro</span></div>
<div class="yiv8221521285MsoNormal"><span style="font-size:11.0pt;color:#0070C0;">Consultor Linux / Microsoft</span></div>
<div class="yiv8221521285MsoNormal"><span style="font-size:11.0pt;color:#0070C0;">InterSolution Informática</span></div>
<div class="yiv8221521285MsoNormal"><span lang="EN-US" style="font-size:11.0pt;color:#0070C0;">Tel.: ( 55 11 ) 3443-1472</span></div>
<div class="yiv8221521285MsoNormal"><span style="font-size:11.0pt;color:#0070C0;"><a rel="nofollow" target="_blank" href="http://www.intersolution.inf.br/"><span lang="EN-US" style="color:#0070C0;">www.intersolution.inf.br</span></a></span><span lang="EN-US" style="font-size:11.0pt;color:#0070C0;"></span></div>
<div class="yiv8221521285MsoNormal"><span lang="EN-US" style="font-size:11.0pt;color:#0070C0;">Oracle Certified Partner</span></div>
<div class="yiv8221521285MsoNormal"><span style="font-size:11.0pt;color:#1F497D;"><img border="0" width="133" height="81" id="yiv8221521285Imagem_x0020_1" src="cid:1.4069142645@web172606.mail.ir2.yahoo.com"></span><span style="font-size:11.0pt;color:#0070C0;"></span></div>
</div>
<div class="yiv8221521285MsoNormal"><span style="font-size:11.0pt;color:#1F497D;"> </span></div>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm;">
<div class="yiv8221521285MsoNormal"><b><span style="font-size:10.0pt;">De:</span></b><span style="font-size:10.0pt;"> Asanka Gunasekera [mailto:asanka_gunasekera@yahoo.co.uk]
<br>
<b>Enviada em:</b> quinta-feira, 30 de maio de 2013 03:02<br>
<b>Para:</b> Diaulas Castro<br>
<b>Assunto:</b> Re: RES: RES: RES: [rt-users] RES: Generate end of the day report and email</span></div>
</div>
</div>
<div class="yiv8221521285MsoNormal"> </div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;">Hi Diaulas, thank you for the reply attached is my config file</span></div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;">Best Regards</span></div>
</div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;">Asanka</span></div>
</div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><b><span lang="EN-US" style="font-size:10.0pt;color:black;">From:</span></b><span lang="EN-US" style="font-size:10.0pt;color:black;"> Diaulas Castro
<</span><span style="font-size:10.0pt;color:black;"><a rel="nofollow" ymailto="mailto:diaulas.castro@intersolution.inf.br" target="_blank" href="mailto:diaulas.castro@intersolution.inf.br"><span lang="EN-US">diaulas.castro@intersolution.inf.br</span></a></span><span lang="EN-US" style="font-size:10.0pt;color:black;">><br>
<b>To:</b> Asanka Gunasekera <</span><span style="font-size:10.0pt;color:black;"><a rel="nofollow" ymailto="mailto:asanka_gunasekera@yahoo.co.uk" target="_blank" href="mailto:asanka_gunasekera@yahoo.co.uk"><span lang="EN-US">asanka_gunasekera@yahoo.co.uk</span></a></span><span lang="EN-US" style="font-size:10.0pt;color:black;">>;
"</span><span style="font-size:10.0pt;color:black;"><a rel="nofollow" ymailto="mailto:rt-users@lists.bestpractical.com" target="_blank" href="mailto:rt-users@lists.bestpractical.com"><span lang="EN-US">rt-users@lists.bestpractical.com</span></a></span><span lang="EN-US" style="font-size:10.0pt;color:black;">"
<</span><span style="font-size:10.0pt;color:black;"><a rel="nofollow" ymailto="mailto:rt-users@lists.bestpractical.com" target="_blank" href="mailto:rt-users@lists.bestpractical.com"><span lang="EN-US">rt-users@lists.bestpractical.com</span></a></span><span lang="EN-US" style="font-size:10.0pt;color:black;">>
<br>
<b>Sent:</b> Tuesday, 28 May 2013, 17:07<br>
<b>Subject:</b> RES: RES: RES: [rt-users] RES: Generate end of the day report and email</span><span lang="EN-US" style="color:black;"></span></div>
</div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="color:black;"> </span></div>
<div id="yiv8221521285">
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">Send your RT_SiteConfig.pm</span><span style="color:black;"></span></div>
</div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm;">
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><b><span style="font-size:10.0pt;color:black;">De:</span></b><span style="font-size:10.0pt;color:black;"> Asanka Gunasekera [<a rel="nofollow" ymailto="mailto:asanka_gunasekera@yahoo.co.uk" target="_blank" href="mailto:asanka_gunasekera@yahoo.co.uk">mailto:asanka_gunasekera@yahoo.co.uk</a>]
<br>
<b>Enviada em:</b> terça-feira, 28 de maio de 2013 01:34<br>
<b>Para:</b> Diaulas Castro; <a rel="nofollow" ymailto="mailto:rt-users@lists.bestpractical.com" target="_blank" href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br>
<b>Assunto:</b> Re: RES: RES: [rt-users] RES: Generate end of the day report and email</span><span style="color:black;"></span></div>
</div>
</div>
</div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;">Hi Diaulas, I have read this document, below is my configuration</span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"><VirtualHost *:80></span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> ServerAdmin
<a rel="nofollow" ymailto="mailto:webmaster@dummy-host.example.com" target="_blank" href="mailto:webmaster@dummy-host.example.com">webmaster@dummy-host.example.com</a></span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> ServerName rt.mydomain.com</span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> ErrorLog "logs/virtual_host_80_for-mail_error.log"</span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> CustomLog "logs/virtual_host_80_for-mail.log" common</span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> AddDefaultCharset UTF-8</span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> DocumentRoot "/usr/local/rt-ora/share/html"</span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> <Location /></span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> Order allow,deny</span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> Allow from all</span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> SetHandler perl-script</span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> PerlResponseHandler Plack::Handler::Apache2</span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> PerlSetVar psgi_app /usr/local/rt-ora/sbin/rt-server</span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </Location></span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> <Perl></span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> use Plack::Handler::Apache2;</span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> Plack::Handler::Apache2->preload("/usr/local/rt-ora/sbin/rt-server");</span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </Perl></span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"></VirtualHost></span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;">And I used below parameers</span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;">RTUSER=root</span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;">RTPASSWORD=112211</span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;">RTSERVER=http://localhost</span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;">Please tell me what I am doing wrong</span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;">Thanks and Best Regards</span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;">Asanka</span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" align="center" style="text-align:center;background:white;">
<span style="color:black;">
<hr size="1" width="100%" align="center">
</span></div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><b><span lang="EN-US" style="font-size:10.0pt;color:black;">From:</span></b><span lang="EN-US" style="font-size:10.0pt;color:black;"> Diaulas Castro <</span><span style="font-size:10.0pt;color:black;"><a rel="nofollow" ymailto="mailto:diaulas.castro@intersolution.inf.br" target="_blank" href="mailto:diaulas.castro@intersolution.inf.br"><span lang="EN-US">diaulas.castro@intersolution.inf.br</span></a></span><span lang="EN-US" style="font-size:10.0pt;color:black;">><br>
<b>To:</b> Asanka Gunasekera <</span><span style="font-size:10.0pt;color:black;"><a rel="nofollow" ymailto="mailto:asanka_gunasekera@yahoo.co.uk" target="_blank" href="mailto:asanka_gunasekera@yahoo.co.uk"><span lang="EN-US">asanka_gunasekera@yahoo.co.uk</span></a></span><span lang="EN-US" style="font-size:10.0pt;color:black;">>;
"</span><span style="font-size:10.0pt;color:black;"><a rel="nofollow" ymailto="mailto:rt-users@lists.bestpractical.com" target="_blank" href="mailto:rt-users@lists.bestpractical.com"><span lang="EN-US">rt-users@lists.bestpractical.com</span></a></span><span lang="EN-US" style="font-size:10.0pt;color:black;">" <</span><span style="font-size:10.0pt;color:black;"><a rel="nofollow" ymailto="mailto:rt-users@lists.bestpractical.com" target="_blank" href="mailto:rt-users@lists.bestpractical.com"><span lang="EN-US">rt-users@lists.bestpractical.com</span></a></span><span lang="EN-US" style="font-size:10.0pt;color:black;">>
<br>
<b>Sent:</b> Monday, 27 May 2013, 17:20<br>
<b>Subject:</b> RES: RES: [rt-users] RES: Generate end of the day report and email</span><span style="color:black;"></span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="color:black;"> </span><span style="color:black;"></span></div>
</div>
<div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">Hello Asanka,</span><span style="color:black;"></span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">
</span><span style="color:black;"></span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">From
<a rel="nofollow" target="_blank" href="http://requesttracker.wikia.com/wiki/CLI">http://requesttracker.wikia.com/wiki/CLI</a>
</span><span style="color:black;"></span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><i><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">export RTUSER=your.rtusername</span></i><span style="color:black;"></span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><i><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">export RTPASSWD=your rt password</span></i><span style="color:black;"></span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><i><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">export RTSERVER=your.rt3.installation</span></i><span style="color:black;"></span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">Try with /rt after domain or anything you have configured on Apache.</span><span style="color:black;"></span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> RTSERVER=http://localhost/rt</span><span style="color:black;"></span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm;">
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><b><span style="font-size:10.0pt;color:black;">De:</span></b><span style="font-size:10.0pt;color:black;"> Asanka Gunasekera [<a rel="nofollow" ymailto="mailto:asanka_gunasekera@yahoo.co.uk" target="_blank" href="mailto:asanka_gunasekera@yahoo.co.uk">mailto:asanka_gunasekera@yahoo.co.uk</a>]
<br>
<b>Enviada em:</b> segunda-feira, 27 de maio de 2013 07:59<br>
<b>Para:</b> Diaulas Castro; <a rel="nofollow" ymailto="mailto:rt-users@lists.bestpractical.com" target="_blank" href="mailto:rt-users@lists.bestpractical.com">
rt-users@lists.bestpractical.com</a><br>
<b>Assunto:</b> Re: RES: [rt-users] RES: Generate end of the day report and email</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;">Hi Diaulas, thank you for the reply but the thing is I am unable to log in to the RT when I do below</span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><i><span style="color:black;">export RTSERVER=http://localhost</span></i><span style="color:black;"></span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;">and do </span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><i><span style="color:black;">rt ls </span></i><span style="color:black;"></span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;">it prompt me for a password once I enter the password and hit enter I get below error</span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><i><span style="color:black;">Query:Status!='resolved' and Status!='rejected'</span></i><span style="color:black;"></span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><i><span style="color:black;"> Strong encryption not available, switched off by externalauth=0</span></i><span style="color:black;"></span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><i><span style="color:black;"> Password will be sent to localhost unencrypted</span></i><span style="color:black;"></span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><i><span style="color:black;"> Press CTRL-C now if you do not want to continue</span></i><span style="color:black;"></span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><i><span style="color:black;">Password:</span></i><span style="color:black;"></span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><i><span style="color:black;">rt: Server error: Forbidden (403)</span></i><span style="color:black;"></span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="color:black;">As the URL I tried
</span><span style="color:black;"><a rel="nofollow" target="_blank" href="http://x.x.x.x/"><span lang="EN-US">http://x.x.x.x</span></a></span><span lang="EN-US" style="color:black;"> as well but with the same error</span><span style="color:black;"></span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="color:black;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;">Thanks and Regards</span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" align="center" style="text-align:center;background:white;">
<span style="color:black;">
<hr size="1" width="100%" align="center">
</span></div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><b><span lang="EN-US" style="font-size:10.0pt;color:black;">From:</span></b><span lang="EN-US" style="font-size:10.0pt;color:black;"> Diaulas Castro <</span><span style="font-size:10.0pt;color:black;"><a rel="nofollow" ymailto="mailto:diaulas.castro@intersolution.inf.br" target="_blank" href="mailto:diaulas.castro@intersolution.inf.br"><span lang="EN-US">diaulas.castro@intersolution.inf.br</span></a></span><span lang="EN-US" style="font-size:10.0pt;color:black;">><br>
<b>To:</b> Asanka Gunasekera <</span><span style="font-size:10.0pt;color:black;"><a rel="nofollow" ymailto="mailto:asanka_gunasekera@yahoo.co.uk" target="_blank" href="mailto:asanka_gunasekera@yahoo.co.uk"><span lang="EN-US">asanka_gunasekera@yahoo.co.uk</span></a></span><span lang="EN-US" style="font-size:10.0pt;color:black;">>;
"</span><span style="font-size:10.0pt;color:black;"><a rel="nofollow" ymailto="mailto:rt-users@lists.bestpractical.com" target="_blank" href="mailto:rt-users@lists.bestpractical.com"><span lang="EN-US">rt-users@lists.bestpractical.com</span></a></span><span lang="EN-US" style="font-size:10.0pt;color:black;">" <</span><span style="font-size:10.0pt;color:black;"><a rel="nofollow" ymailto="mailto:rt-users@lists.bestpractical.com" target="_blank" href="mailto:rt-users@lists.bestpractical.com"><span lang="EN-US">rt-users@lists.bestpractical.com</span></a></span><span lang="EN-US" style="font-size:10.0pt;color:black;">>
<br>
<b>Sent:</b> Wednesday, 22 May 2013, 17:20<br>
<b>Subject:</b> RES: [rt-users] RES: Generate end of the day report and email</span><span style="color:black;"></span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="color:black;"> </span><span style="color:black;"></span></div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">Sorry, didnt understand your message, but from your log I think you don’t have RTSERVER variable,</span><span style="color:black;"></span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">Try to add on top of script:</span><span style="color:black;"></span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:10.0pt;color:black;">export RTSERVER=your.rt.installation</span><span style="color:black;"></span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">if you got error try to execute a simple /usr/bin/rt ls TICKET_NUMBER</span><span style="color:black;"></span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">That script relies on output of RT CLI command.</span><span style="color:black;"></span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm;">
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><b><span style="font-size:10.0pt;color:black;">De:</span></b><span style="font-size:10.0pt;color:black;"> Asanka Gunasekera [<a rel="nofollow" ymailto="mailto:asanka_gunasekera@yahoo.co.uk" target="_blank" href="mailto:asanka_gunasekera@yahoo.co.uk">mailto:asanka_gunasekera@yahoo.co.uk</a>]
<br>
<b>Enviada em:</b> quarta-feira, 22 de maio de 2013 08:38<br>
<b>Para:</b> Diaulas Castro; <a rel="nofollow" ymailto="mailto:rt-users@lists.bestpractical.com" target="_blank" href="mailto:rt-users@lists.bestpractical.com">
rt-users@lists.bestpractical.com</a><br>
<b>Assunto:</b> Re: [rt-users] RES: Generate end of the day report and email</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;">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</span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;">Query:Status!='resolved' and Status!='rejected'</span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;">rt: Server error: Forbidden (403)</span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;">Thank you and Best Regards</span></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" align="center" style="text-align:center;background:white;">
<span style="color:black;">
<hr size="1" width="100%" align="center">
</span></div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><b><span lang="EN-US" style="font-size:10.0pt;color:black;">From:</span></b><span lang="EN-US" style="font-size:10.0pt;color:black;"> Diaulas Castro <</span><span style="font-size:10.0pt;color:black;"><a rel="nofollow" ymailto="mailto:diaulas.castro@intersolution.inf.br" target="_blank" href="mailto:diaulas.castro@intersolution.inf.br"><span lang="EN-US">diaulas.castro@intersolution.inf.br</span></a></span><span lang="EN-US" style="font-size:10.0pt;color:black;">><br>
<b>To:</b> "</span><span style="font-size:10.0pt;color:black;"><a rel="nofollow" ymailto="mailto:rt-users@lists.bestpractical.com" target="_blank" href="mailto:rt-users@lists.bestpractical.com"><span lang="EN-US">rt-users@lists.bestpractical.com</span></a></span><span lang="EN-US" style="font-size:10.0pt;color:black;">" <</span><span style="font-size:10.0pt;color:black;"><a rel="nofollow" ymailto="mailto:rt-users@lists.bestpractical.com" target="_blank" href="mailto:rt-users@lists.bestpractical.com"><span lang="EN-US">rt-users@lists.bestpractical.com</span></a></span><span lang="EN-US" style="font-size:10.0pt;color:black;">>
<br>
<b>Sent:</b> Friday, 10 May 2013, 21:42<br>
<b>Subject:</b> [rt-users] RES: Generate end of the day report and email</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="color:black;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">Made this bash script to accomplish using RT CLI.</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">Just customize “From:”, To:” and “Status” search in rt ls command and schedule on crontab.</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">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. (<a rel="nofollow" target="_blank" href="http://postimg.org/image/yfmlp9307/">http://postimg.org/image/yfmlp9307/</a>)</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> If you want to color the rows use this before sendmail command:</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> sed -i -e '/Nobody/s/D2EAF1/CCCCCC/g' $MAIL</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> sed -i -e '/diaulas.castro/s/D2EAF1/6FCCFF/g' $MAIL</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> This will change all tickets by nobody to gray and Diaulas.castro to light blue</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">PS: I know! RT-CRONTOOL exist, but I m not perl expert.. =(</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">####################################</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">export RTORDERBY=owner</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">MAIL=/tmp/rel_todos_tickets_abertos.sh.mail</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">echo "From:
<a rel="nofollow" ymailto="mailto:MY_TICKET@MY_DOMAIN.COM" target="_blank" href="mailto:MY_TICKET@MY_DOMAIN.COM">MY_TICKET@MY_DOMAIN.COM</a> " > $MAIL</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">echo "To:
<a rel="nofollow" ymailto="mailto:DIRECTORS@MYDOMAIN.COM" target="_blank" href="mailto:DIRECTORS@MYDOMAIN.COM">DIRECTORS@MYDOMAIN.COM</a>" >> $MAIL</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">echo "MIME-Version: 1.0" >> $MAIL</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">echo 'Content-type: text/html; charset=iso-8859-1' >> $MAIL</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">echo " boundary=`date +%s`/rt.MY.DOMAIN.COM" >> $MAIL</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">echo "Subject: All open Tickets:$(date +%d/%m/%y)" >> $MAIL</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">echo "" >> $MAIL</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">echo "<html>" >> $MAIL</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">echo "<HEAD>" >> $MAIL</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">echo "</HEAD>" >> $MAIL</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">echo "<BODY>" >> $MAIL</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">echo "<span style=\'font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D\'>" >> $MAIL</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">echo "<table>">> $MAIL</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">/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</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">while read line ; do</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> 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"</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">done < /tmp/rel.tmp >> $MAIL</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">echo "</table>">> $MAIL</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">echo "</BODY>" >> $MAIL</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">echo "</html>" >> $MAIL</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;">/usr/sbin/sendmail -t < $MAIL</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D;"> </span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm;">
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><b><span style="font-size:10.0pt;color:black;">De:</span></b><span style="font-size:10.0pt;color:black;">
<a rel="nofollow" ymailto="mailto:rt-users-bounces@lists.bestpractical.com" target="_blank" href="mailto:rt-users-bounces@lists.bestpractical.com">rt-users-bounces@lists.bestpractical.com</a> [<a rel="nofollow" ymailto="mailto:rt-users-bounces@lists.bestpractical.com" target="_blank" href="mailto:rt-users-bounces@lists.bestpractical.com">mailto:rt-users-bounces@lists.bestpractical.com</a>]
<b>Em nome de </b>Asanka Gunasekera<br>
<b>Enviada em:</b> sexta-feira, 10 de maio de 2013 05:48<br>
<b>Para:</b> <a rel="nofollow" ymailto="mailto:rt-users@lists.bestpractical.com" target="_blank" href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br>
<b>Assunto:</b> [rt-users] Generate end of the day report and email</span><span style="color:black;"></span></div>
</div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;">Hi, is there any way to auto generate end of the day report and emal this to management (all open, all new etc)</span></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;">I am using RT4 and oracle database on redhat</span></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;">Thanks and Regards</span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div style="margin-bottom:12.0pt;">
<div>
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"><br>
<br>
<br>
-- <br>
RT Training in Seattle, June 19-20: <a rel="nofollow" target="_blank" href="http://bestpractical.com/training">
http://bestpractical.com/training</a></span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div style="margin-bottom:12.0pt;">
<div>
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div style="margin-bottom:12.0pt;">
<div class="yiv8221521285MsoNormal" style="background:white;"><span style="color:black;"> </span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div class="yiv8221521285MsoNormal" style="margin-bottom:12.0pt;background:white;"><span style="color:black;"> </span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div><br><br></div> </div> </div> </div></div></div><br><br></div> </div> </div> </div></div></div><br><br></div> </div> </div> </div></body></html>