[Freeswitch-users] Script for ASR & ACD Monitoring

[Wasim Baig]

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 ...
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20111025/1e761b23/attachment-0001.html