Hello,<div><br></div><div>That's a faily simple bash script. </div><div><br></div><div>"cat" the log file to an awk script like so;</div><div><br></div><div>cat /usr/local/freeswitch/log/cdr-csv/Master.csv | sed "s/\\\"//g" | awk '{ FS=","; }{ if($9>0){ CONN=CONN+1; } TOTAL=TOTAL+1; }END{ print "CONNECT: "CONN; print "TOTAL: " TOTAL; ASR=(CONN/TOTAL)*100; print "ASR: "ASR; if(ASR<100){ system("echo send email");} }' </div>
<div><br></div><div>the "system" is where you put the mail command</div><div><br></div><div>also, bear in mind that the master can get VERY large if you don't rotate it.</div><div><br></div><div>david<br><br>
<div class="gmail_quote">On Wed, Oct 26, 2011 at 1:59 PM, Faisal Rehman <span dir="ltr"><<a href="mailto:faisal.rehman22@hotmail.com">faisal.rehman22@hotmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div><div dir="ltr">
<b>Hi Waseem,</b><div><br></div><div>Thanks for your help, I saw the scripts that were on the link that you provided to me but actually the problem is that I don't want to involve the database though it is a bit difficult task but according to my requirement I just want to read the whole Master.csv file & if the ASR or ACD is low on any server, it should send me email, so my question is how can I skip the database from it to interact directly with the Master.csv file.</div>
<div><br></div><div><br></div><div>Thanks in Advance!!</div><div><br></div><div><b>Faisal Rehman<br></b><br><div><hr>From: <a href="mailto:wasim@convergence.pk" target="_blank">wasim@convergence.pk</a><br>Date: Tue, 25 Oct 2011 07:32:35 +0500<br>
To: <a href="mailto:freeswitch-users@lists.freeswitch.org" target="_blank">freeswitch-users@lists.freeswitch.org</a><br>Subject: Re: [Freeswitch-users] Script for ASR & ACD Monitoring<div><div></div><div class="h5"><br>
<br><div dir="ltr">Faisal:<div><br></div><div>Load up the CDR into a db (MySQL or otherwise) ...</div><div><br></div><div>For ACD you'll want a SQL query akin</div><div><ul><li>SELECT COUNT(*) AS calls_answered, SUM(billusec) AS billusec, SUM(billusec)/COUNT(*) AS acd FROM freeswitchdb.freeswitchcdr WHERE disposition=1;</li>
</ul></div><div>For ASR you'll need another query</div><div><ul><li>SELECT COUNT(*) AS calls_total FROM freeswitchdb.freeswitchcdr;</li><li>ASR is calls_answered/calls_total</li></ul><div>There is sample (read: poor) code in <a href="http://jira.freeswitch.org/browse/FS-1981" target="_blank">http://jira.freeswitch.org/browse/FS-1981</a></div>
</div><div>which a google for "freeswitch ACD ASR" would have helped you get to in the first place.</div><div><br></div><div>-wasim</div><div><br><div>On Mon, Oct 24, 2011 at 15:39, Faisal Rehman <span dir="ltr"><<a href="mailto:faisal.rehman22@hotmail.com" target="_blank">faisal.rehman22@hotmail.com</a>></span> wrote:<br>
<blockquote style="border-left:1px #ccc solid;padding-left:1ex">
<div><div dir="ltr">
Hi Everyone,<div><br></div><div>I want to write a script that reads the Master.csv & generate an alert if the ASR & ACD is low from the desired value. Anybody has written such script, please help me write it or provide any sample.</div>
<div><br></div><div><br></div><div>Thanks</div><div><br></div><font color="#888888"><div><br></div><div>Faisal Rehman</div> </font></div></div>
<br><br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br>wasim h. baig | principal consultant | convergence pk | <a href="tel:%2B92%2030%200850%208070" value="+923008508070" target="_blank">+92 30 0850 8070</a> | peace be upon you ...<br>
</div></div>
<br>FreeSWITCH-users mailing list
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a></div></div></div></div> </div></div>
<br><br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br></div>