<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"Pré-formatação HTML Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Texto de balão Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.Pr-formataoHTMLChar
{mso-style-name:"Pré-formatação HTML Char";
mso-style-priority:99;
mso-style-link:"Pré-formatação HTML";
font-family:Consolas;}
p.yiv5805313959msoacetate, li.yiv5805313959msoacetate, div.yiv5805313959msoacetate
{mso-style-name:yiv5805313959msoacetate;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.yiv5805313959msonormal, li.yiv5805313959msonormal, div.yiv5805313959msonormal
{mso-style-name:yiv5805313959msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.yiv5805313959msochpdefault, li.yiv5805313959msochpdefault, div.yiv5805313959msochpdefault
{mso-style-name:yiv5805313959msochpdefault;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.yiv5805313959msonormal1, li.yiv5805313959msonormal1, div.yiv5805313959msonormal1
{mso-style-name:yiv5805313959msonormal1;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.yiv5805313959msoacetate1, li.yiv5805313959msoacetate1, div.yiv5805313959msoacetate1
{mso-style-name:yiv5805313959msoacetate1;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.yiv5805313959msochpdefault1, li.yiv5805313959msochpdefault1, div.yiv5805313959msochpdefault1
{mso-style-name:yiv5805313959msochpdefault1;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.yiv5805313959msonormal2, li.yiv5805313959msonormal2, div.yiv5805313959msonormal2
{mso-style-name:yiv5805313959msonormal2;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.yiv5805313959msoacetate2, li.yiv5805313959msoacetate2, div.yiv5805313959msoacetate2
{mso-style-name:yiv5805313959msoacetate2;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.yiv5805313959msonormal3, li.yiv5805313959msonormal3, div.yiv5805313959msonormal3
{mso-style-name:yiv5805313959msonormal3;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.yiv5805313959msochpdefault2, li.yiv5805313959msochpdefault2, div.yiv5805313959msochpdefault2
{mso-style-name:yiv5805313959msochpdefault2;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.yiv5805313959msonormal11, li.yiv5805313959msonormal11, div.yiv5805313959msonormal11
{mso-style-name:yiv5805313959msonormal11;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.yiv5805313959msoacetate11, li.yiv5805313959msoacetate11, div.yiv5805313959msoacetate11
{mso-style-name:yiv5805313959msoacetate11;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.yiv5805313959msochpdefault11, li.yiv5805313959msochpdefault11, div.yiv5805313959msochpdefault11
{mso-style-name:yiv5805313959msochpdefault11;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.yiv5805313959msohyperlink
{mso-style-name:yiv5805313959msohyperlink;}
span.yiv5805313959msohyperlinkfollowed
{mso-style-name:yiv5805313959msohyperlinkfollowed;}
span.yiv5805313959pr-formataohtmlchar
{mso-style-name:yiv5805313959pr-formataohtmlchar;}
span.yiv5805313959msohyperlink2
{mso-style-name:yiv5805313959msohyperlink2;}
span.yiv5805313959msohyperlinkfollowed2
{mso-style-name:yiv5805313959msohyperlinkfollowed2;}
span.yiv5805313959msohyperlink11
{mso-style-name:yiv5805313959msohyperlink11;}
span.yiv5805313959msohyperlinkfollowed11
{mso-style-name:yiv5805313959msohyperlinkfollowed11;}
span.yiv5805313959estilodeemail1711
{mso-style-name:yiv5805313959estilodeemail1711;}
span.yiv5805313959textodebalochar11
{mso-style-name:yiv5805313959textodebalochar11;}
span.yiv5805313959estilodeemail311
{mso-style-name:yiv5805313959estilodeemail311;}
span.yiv5805313959textodebalochar2
{mso-style-name:yiv5805313959textodebalochar2;}
span.yiv5805313959pr-formataohtmlchar1
{mso-style-name:yiv5805313959pr-formataohtmlchar1;}
span.yiv5805313959estilodeemail50
{mso-style-name:yiv5805313959estilodeemail50;}
span.yiv5805313959textodebalochar
{mso-style-name:yiv5805313959textodebalochar;}
p.yiv5805313959msonormal4, li.yiv5805313959msonormal4, div.yiv5805313959msonormal4
{mso-style-name:yiv5805313959msonormal4;
margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.yiv5805313959msohyperlink1
{mso-style-name:yiv5805313959msohyperlink1;
color:blue;
text-decoration:underline;}
span.yiv5805313959msohyperlinkfollowed1
{mso-style-name:yiv5805313959msohyperlinkfollowed1;
color:purple;
text-decoration:underline;}
p.yiv5805313959msoacetate3, li.yiv5805313959msoacetate3, div.yiv5805313959msoacetate3
{mso-style-name:yiv5805313959msoacetate3;
margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.yiv5805313959pr-formataohtmlchar2
{mso-style-name:yiv5805313959pr-formataohtmlchar2;
font-family:Consolas;}
p.yiv5805313959msonormal5, li.yiv5805313959msonormal5, div.yiv5805313959msonormal5
{mso-style-name:yiv5805313959msonormal5;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.yiv5805313959msochpdefault3, li.yiv5805313959msochpdefault3, div.yiv5805313959msochpdefault3
{mso-style-name:yiv5805313959msochpdefault3;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.yiv5805313959msonormal12, li.yiv5805313959msonormal12, div.yiv5805313959msonormal12
{mso-style-name:yiv5805313959msonormal12;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.yiv5805313959msoacetate12, li.yiv5805313959msoacetate12, div.yiv5805313959msoacetate12
{mso-style-name:yiv5805313959msoacetate12;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.yiv5805313959msochpdefault12, li.yiv5805313959msochpdefault12, div.yiv5805313959msochpdefault12
{mso-style-name:yiv5805313959msochpdefault12;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.yiv5805313959msonormal21, li.yiv5805313959msonormal21, div.yiv5805313959msonormal21
{mso-style-name:yiv5805313959msonormal21;
margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.yiv5805313959msohyperlink21
{mso-style-name:yiv5805313959msohyperlink21;
color:blue;
text-decoration:underline;}
span.yiv5805313959msohyperlinkfollowed21
{mso-style-name:yiv5805313959msohyperlinkfollowed21;
color:purple;
text-decoration:underline;}
p.yiv5805313959msoacetate21, li.yiv5805313959msoacetate21, div.yiv5805313959msoacetate21
{mso-style-name:yiv5805313959msoacetate21;
margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.yiv5805313959msonormal31, li.yiv5805313959msonormal31, div.yiv5805313959msonormal31
{mso-style-name:yiv5805313959msonormal31;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.yiv5805313959msochpdefault21, li.yiv5805313959msochpdefault21, div.yiv5805313959msochpdefault21
{mso-style-name:yiv5805313959msochpdefault21;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.yiv5805313959msonormal111, li.yiv5805313959msonormal111, div.yiv5805313959msonormal111
{mso-style-name:yiv5805313959msonormal111;
margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.yiv5805313959msohyperlink111
{mso-style-name:yiv5805313959msohyperlink111;
color:blue;
text-decoration:underline;}
span.yiv5805313959msohyperlinkfollowed111
{mso-style-name:yiv5805313959msohyperlinkfollowed111;
color:purple;
text-decoration:underline;}
p.yiv5805313959msoacetate111, li.yiv5805313959msoacetate111, div.yiv5805313959msoacetate111
{mso-style-name:yiv5805313959msoacetate111;
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.yiv5805313959estilodeemail17111
{mso-style-name:yiv5805313959estilodeemail17111;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.yiv5805313959textodebalochar111
{mso-style-name:yiv5805313959textodebalochar111;
font-family:"Tahoma","sans-serif";}
p.yiv5805313959msochpdefault111, li.yiv5805313959msochpdefault111, div.yiv5805313959msochpdefault111
{mso-style-name:yiv5805313959msochpdefault111;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:10.0pt;
font-family:"Times New Roman","serif";}
span.yiv5805313959estilodeemail3111
{mso-style-name:yiv5805313959estilodeemail3111;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.yiv5805313959textodebalochar21
{mso-style-name:yiv5805313959textodebalochar21;
font-family:"Tahoma","sans-serif";}
span.yiv5805313959pr-formataohtmlchar11
{mso-style-name:yiv5805313959pr-formataohtmlchar11;
font-family:"Courier New";}
span.yiv5805313959estilodeemail501
{mso-style-name:yiv5805313959estilodeemail501;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.yiv5805313959textodebalochar1
{mso-style-name:yiv5805313959textodebalochar1;
font-family:"Tahoma","sans-serif";}
span.EstiloDeEmail74
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.TextodebaloChar
{mso-style-name:"Texto de balão Char";
mso-style-priority:99;
mso-style-link:"Texto de balão";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="PT-BR" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Send your RT_SiteConfig.pm<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">De:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Asanka Gunasekera [mailto:asanka_gunasekera@yahoo.co.uk]
<br>
<b>Enviada em:</b> terça-feira, 28 de maio de 2013 01:34<br>
<b>Para:</b> Diaulas Castro; rt-users@lists.bestpractical.com<br>
<b>Assunto:</b> Re: RES: RES: [rt-users] RES: Generate end of the day report and email<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black">Hi Diaulas, I have read this document, below is my configuration<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"><VirtualHost *:80><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> ServerAdmin <a href="mailto:webmaster@dummy-host.example.com">
webmaster@dummy-host.example.com</a><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> ServerName rt.mydomain.com<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> ErrorLog "logs/virtual_host_80_for-mail_error.log"<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> CustomLog "logs/virtual_host_80_for-mail.log" common<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> AddDefaultCharset UTF-8<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> DocumentRoot "/usr/local/rt-ora/share/html"<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> <Location /><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> Order allow,deny<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> Allow from all<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> SetHandler perl-script<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> PerlResponseHandler Plack::Handler::Apache2<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> PerlSetVar psgi_app /usr/local/rt-ora/sbin/rt-server<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> </Location><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> <Perl><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> use Plack::Handler::Apache2;<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> Plack::Handler::Apache2->preload("/usr/local/rt-ora/sbin/rt-server");<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"> </Perl><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"></VirtualHost><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black">And I used below parameers<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black">RTUSER=root<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black">RTPASSWORD=112211<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black">RTSERVER=http://localhost<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black">Please tell me what I am doing wrong<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black">Thanks and Best Regards<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black">Asanka<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:black"><o:p> </o:p></span></p>
</div>
<div>
<div>
<div>
<div class="MsoNormal" align="center" style="text-align:center;background:white">
<span style="color:black">
<hr size="1" width="100%" align="center">
</span></div>
<p class="MsoNormal" style="background:white"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black"> Diaulas Castro
<</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black"><a 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;font-family:"Arial","sans-serif";color:black">><br>
<b>To:</b> Asanka Gunasekera <</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black"><a 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;font-family:"Arial","sans-serif";color:black">>;
"</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black"><a 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;font-family:"Arial","sans-serif";color:black">"
<</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black"><a 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;font-family:"Arial","sans-serif";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 lang="EN-US" style="color:black"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="color:black"><o:p> </o:p></span></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D">Hello Asanka,</span><span style="color:black"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D">
</span><span style="color:black"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D">From
<a href="http://requesttracker.wikia.com/wiki/CLI" target="_blank">http://requesttracker.wikia.com/wiki/CLI</a>
</span><span style="color:black"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" 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"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" 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"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" 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"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" 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"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> RTSERVER=http://localhost/rt</span><span style="color:black"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<div>
<p class="MsoNormal" 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 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 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"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black"> <o:p></o:p></span></p>
</div>
<div>
<div>
<div>
<p class="MsoNormal" 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<o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black"> <o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><i><span style="color:black">export RTSERVER=http://localhost</span></i><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black"> <o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black">and do <o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black"> <o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><i><span style="color:black">rt ls </span></i><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black"> <o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" 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<o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black"> <o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><i><span style="color:black">Query:Status!='resolved' and Status!='rejected'</span></i><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><i><span style="color:black"> Strong encryption not available, switched off by externalauth=0</span></i><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><i><span style="color:black"> Password will be sent to localhost unencrypted</span></i><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" 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"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><i><span style="color:black">Password:</span></i><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><i><span style="color:black">rt: Server error: Forbidden (403)</span></i><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black"> <o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="color:black">As the URL I tried
</span><span style="color:black"><a href="http://x.x.x.x/" target="_blank"><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"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="color:black"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black">Thanks and Regards<o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<div>
<div class="MsoNormal" align="center" style="text-align:center;background:white">
<span style="color:black">
<hr size="1" width="100%" align="center">
</span></div>
<div>
<p class="MsoNormal" 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 href="mailto:diaulas.castro@intersolution.inf.br" target="_blank"><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 href="mailto:asanka_gunasekera@yahoo.co.uk" target="_blank"><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 href="mailto:rt-users@lists.bestpractical.com" target="_blank"><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 href="mailto:rt-users@lists.bestpractical.com" target="_blank"><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"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="color:black"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" 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"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" 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"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:10.0pt;color:black">export RTSERVER=your.rt.installation</span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" 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"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" 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"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<div>
<div>
<p class="MsoNormal" 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 href="mailto:asanka_gunasekera@yahoo.co.uk" target="_blank">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 href="mailto:rt-users@lists.bestpractical.com" target="_blank">
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"><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black"> <o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" 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<o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black"> <o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black">Query:Status!='resolved' and Status!='rejected'<o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black">rt: Server error: Forbidden (403)<o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black"> <o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black">Thank you and Best Regards<o:p></o:p></span></p>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black"> <o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<div class="MsoNormal" align="center" style="text-align:center;background:white">
<span style="color:black">
<hr size="1" width="100%" align="center">
</span></div>
<div>
<div>
<p class="MsoNormal" 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 href="mailto:diaulas.castro@intersolution.inf.br" target="_blank"><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 href="mailto:rt-users@lists.bestpractical.com" target="_blank"><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 href="mailto:rt-users@lists.bestpractical.com" target="_blank"><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"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="color:black"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" 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"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" 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"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" 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 href="http://postimg.org/image/yfmlp9307/" target="_blank">http://postimg.org/image/yfmlp9307/</a>)</span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" 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"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" 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"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" 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"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" 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"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" 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"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D">####################################</span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D">export RTORDERBY=owner</span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" 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"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D">echo "From:
<a href="mailto:MY_TICKET@MY_DOMAIN.COM" target="_blank">MY_TICKET@MY_DOMAIN.COM</a> " > $MAIL</span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D">echo "To:
<a href="mailto:DIRECTORS@MYDOMAIN.COM" target="_blank">DIRECTORS@MYDOMAIN.COM</a>" >> $MAIL</span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" 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"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" 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"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" 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"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" 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"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D">echo "" >> $MAIL</span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D">echo "<html>" >> $MAIL</span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D">echo "<HEAD>" >> $MAIL</span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D">echo "</HEAD>" >> $MAIL</span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D">echo "<BODY>" >> $MAIL</span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" 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"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D">echo "<table>">> $MAIL</span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" 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"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D">while read line ; do</span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" 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"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D">done < /tmp/rel.tmp >> $MAIL</span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D">echo "</table>">> $MAIL</span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D">echo "</BODY>" >> $MAIL</span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D">echo "</html>" >> $MAIL</span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D">/usr/sbin/sendmail -t < $MAIL</span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span lang="EN-US" style="font-size:11.0pt;color:#1F497D"> </span><span style="color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><b><span style="font-size:10.0pt;color:black">De:</span></b><span style="font-size:10.0pt;color:black">
<a href="mailto:rt-users-bounces@lists.bestpractical.com" target="_blank">rt-users-bounces@lists.bestpractical.com</a> [<a href="mailto:rt-users-bounces@lists.bestpractical.com" target="_blank">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 href="mailto:rt-users@lists.bestpractical.com" target="_blank">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"><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black"> <o:p></o:p></span></p>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" 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)<o:p></o:p></span></p>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black"> <o:p></o:p></span></p>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black">I am using RT4 and oracle database on redhat<o:p></o:p></span></p>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black"> <o:p></o:p></span></p>
</div>
</div>
</div>
</div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="color:black">Thanks and Regards<o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div style="margin-bottom:12.0pt">
<div>
<p class="MsoNormal" style="background:white"><span style="color:black"><br>
<br>
<br>
-- <br>
RT Training in Seattle, June 19-20: <a href="http://bestpractical.com/training" target="_blank">
http://bestpractical.com/training</a><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div style="margin-bottom:12.0pt">
<p class="MsoNormal" style="background:white"><span style="color:black"> <o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt;background:white"><span style="color:black"><o:p> </o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</body>
</html>