[Freeswitch-users] Script for ASR & ACD Monitoring

[Abdul Basit]

For asterisk, ASR and ACD is as follows: (just addition) billsec is 14th
field

cat /var/log/asterisk/cdr-csv/Master.csv | sed "s/\\\"//g" | awk '{ FS=",";
}{ if($14>0){ CONN=CONN+1; BSEC=BSEC+$14} TOTAL=TOTAL+1; }END{ print
"CONNECT: "CONN; print "TOTAL: " TOTAL; ASR=(CONN/TOTAL)*100; print "ASR:
"ASR; print "BILLSEC: "BSEC; print "ACD: "BSEC/CONN; if(ASR<100){
system("echo send email");} }'

here is the result

CONNECT: 1573542
TOTAL: 1584174
ASR: 99.3289
BILLSEC: 448223564
ACD: 284.85
send email


-- 
Regards,

Abdul Basit | +92 32 1416 4196 | +92 30 0841 1445

On Fri, Oct 28, 2011 at 8:33 PM, Michael Collins <msc at freeswitch.org> wrote:

> Basic awk scripting. The $9 means "ninth field" and $14 means "14th" field.
> Those are the respective locations of the "billsec" field in the FS and
> Asterisk Master.csv files.
>
> -MC
>
>
> On Fri, Oct 28, 2011 at 12:47 AM, Faisal Rehman <
> faisal.rehman22 at hotmail.com> wrote:
>
>>  Hi Micheal,
>>
>> What would be the difference between $14 and $9, will you please a little
>> explain?
>>
>>
>> Thanks
>>
>> Faisal Rehman
>>
>> ------------------------------
>> Date: Thu, 27 Oct 2011 08:40:12 -0700
>> From: msc at freeswitch.org
>>
>> To: freeswitch-users at lists.freeswitch.org
>> Subject: Re: [Freeswitch-users] Script for ASR & ACD Monitoring
>>
>>
>>
>> On Thu, Oct 27, 2011 at 1:02 AM, Faisal Rehman <
>> faisal.rehman22 at hotmail.com> wrote:
>>
>>  Hi David,
>>
>> Thanks for sharing the script but will that work too for Asterisk's
>> Master.csv if I needed the ASR & ACD records from that file?
>>
>>
>> Use $14 (instead of $9) for Asterisk's Master.csv file.
>> -MC
>>
>>
>>
>>
>> Regards,
>>
>> Faisal Rehman
>>
>> ------------------------------
>> From: david.villasmil.work at gmail.com
>> Date: Wed, 26 Oct 2011 19:48:57 +0200
>> To: freeswitch-users at lists.freeswitch.org
>> Subject: Re: [Freeswitch-users] Script for ASR & ACD Monitoring
>>
>> Hello,
>>
>> That's a faily simple bash script.
>>
>> "cat" the log file to an awk script like so;
>>
>> 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");} }'
>>
>> the "system" is where you put the mail command
>>
>> also, bear in mind that the master can get VERY large if you don't rotate
>> it.
>>
>> david
>>
>> On Wed, Oct 26, 2011 at 1:59 PM, Faisal Rehman <
>> faisal.rehman22 at hotmail.com> wrote:
>>
>>  *Hi Waseem,*
>>
>> 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.
>>
>>
>> Thanks in Advance!!
>>
>> *Faisal Rehman
>> *
>> ------------------------------
>> From: wasim at convergence.pk
>> Date: Tue, 25 Oct 2011 07:32:35 +0500
>> To: freeswitch-users at lists.freeswitch.org
>> Subject: Re: [Freeswitch-users] Script for ASR & ACD Monitoring
>>
>>
>> Faisal:
>>
>> Load up the CDR into a db (MySQL or otherwise) ...
>>
>> For ACD you'll want a SQL query akin
>>
>>    - SELECT COUNT(*) AS calls_answered, SUM(billusec) AS billusec,
>>    SUM(billusec)/COUNT(*) AS acd FROM freeswitchdb.freeswitchcdr WHERE
>>    disposition=1;
>>
>> For ASR you'll need another query
>>
>>    - SELECT COUNT(*) AS calls_total FROM freeswitchdb.freeswitchcdr;
>>    - ASR is calls_answered/calls_total
>>
>> There is sample (read: poor) code in
>> http://jira.freeswitch.org/browse/FS-1981
>> which a google for "freeswitch ACD ASR" would have helped you get to in
>> the first place.
>>
>> -wasim
>>
>> On Mon, Oct 24, 2011 at 15:39, Faisal Rehman <faisal.rehman22 at hotmail.com
>> > wrote:
>>
>>  Hi Everyone,
>>
>> 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.
>>
>>
>> Thanks
>>
>>
>> Faisal Rehman
>>
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>>
>>
>>
>>
>> --
>> wasim h. baig | principal consultant | convergence pk | +92 30 0850 8070| peace be upon you ...
>>
>> FreeSWITCH-users mailing list FreeSWITCH-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-usersUNSUBSCRIBE:
>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>>
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>>
>>
>>
>> FreeSWITCH-users mailing list FreeSWITCH-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-usersUNSUBSCRIBE:
>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>>
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>>
>>
>>
>> FreeSWITCH-users mailing list FreeSWITCH-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-usersUNSUBSCRIBE:
>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>>
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>>
>>
>
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20111028/3c76a47a/attachment.html