[Freeswitch-users] cdr minutes of use per did

[Rodney]

Avi,

thank you for quick response, I am using sqlite with fusionpbx but it is in windows, so I don't believe I can run cron jobs in windows. 


________________________________
 From: "freeswitch-users-request at lists.freeswitch.org" <freeswitch-users-request at lists.freeswitch.org>
To: freeswitch-users at lists.freeswitch.org 
Sent: Saturday, January 14, 2012 6:03 PM
Subject: FreeSWITCH-users Digest, Vol 67, Issue 137
 
----- Forwarded Message -----

Send FreeSWITCH-users mailing list submissions to
    freeswitch-users at lists.freeswitch.org

To subscribe or unsubscribe via the World Wide Web, visit
    http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
or, via email, send a message with subject or body 'help' to
    freeswitch-users-request at lists.freeswitch.org

You can reach the person managing the list at
    freeswitch-users-owner at lists.freeswitch.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of FreeSWITCH-users digest..."

Today's Topics:

   1. cdr minutes of use per did (Rodney)
   2. Re: Problems with CURL_XML and bridging ? (Bob Smith)
   3. Re: cdr minutes of use per did (Avi Marcus)

does anyone have a cdr viewer or method that can help me determine the total minutes for all calls on a specified DID for the hour/day/month to date? I would like a method to generate such a report and maybe have it emailed on a 24 hour basis to the person in charge of the DID. the following I have seen in the past with any method to find the original program that would give an output like this.
Calls by Day, DNIS -> DID ACCOUNT-> Friday, 8/19/11 (Eastern Standard Time)

Daily
Month to Date
(Start of Month = Day 21)
Day
DNIS
DNIS
Group
Total
Calls
Minutes
of Use
Average
Hold Time
(Minutes)
Total
Calls
Minutes
of Use
Average
Hold Time
(Minutes)
– No rows – Actually, you're quite right.  I've gone back and double checked.  Does not work with static XML.  Same behaviour... transfer works, bridge fails.

However I can definitely originate a call from the CLI over the same route ..... "originate sofia/gateway/mygate/12345678 &park" works great.

That's what's really bugging me, if I can CLI originate to that number, if I can call that PSTN number from my FreeSwitch softphone, why on earth
can't i do this simple bridge ! ;-(


>So doing the bridge to the same number with static XML worked, but when
> bridging to the exact same endpoint with xml_curl you're getting a 503?



It depends on how your cdr statistics are stored.. CSV file, sqlite, pgsql, mysql.. for how easy it is to run a query.
And if you want just inbound or outbound "on" that DID.

Then just add that SQL query to a script and have a cron job run it..
e.g. if you use mysql in fusionpbx to store your cdrs (via xml_cdr posts) I can run:
SELECT SUM(`billsec`)/60 FROM `v_xml_cdr` WHERE `sip_to_user` = '$number' AND `start_stamp` LIKE '2011-11%'
= 831.4500 minutes for all of November 2011. (pgsql doesn't like using a like like that on a time stamp field, it seems..)

Your query, and source info, will vary..


-Avi



On Sun, Jan 15, 2012 at 12:41 AM, Rodney <notlikeme75 at yahoo.com> wrote:

does anyone have a cdr viewer or method that can help me determine the total minutes for all calls on a specified DID for the hour/day/month to date? I would like a method to generate such a report and maybe have it emailed on a 24 hour basis to the person in charge of the DID. the following I have seen in the past with any method to find the original program that would give an output like this.
>Calls by Day, DNIS -> DID ACCOUNT-> Friday, 8/19/11 (Eastern Standard Time)
>
>Daily
>Month to Date
>(Start of Month = Day 21)
>Day
>DNIS
>DNIS
>Group
>Total
>Calls
>Minutes
>of Use
>Average
>Hold Time
>(Minutes)
>Total
>Calls
>Minutes
>of Use
>Average
>Hold Time
>(Minutes)
>– No rows – 
>_________________________________________________________________________
>Professional FreeSWITCH Consulting Services:
>consulting at freeswitch.org
>http://www.freeswitchsolutions.com
>
>
>
>
>Official FreeSWITCH Sites
>http://www.freeswitch.org
>http://wiki.freeswitch.org
>http://www.cluecon.com
>
>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/20120114/a6ca00c7/attachment-0001.html