[Freeswitch-users] cdr minutes of use per did

[Avi Marcus]

Windows has cron-like things. Google has several options, including the
built-in windows scheduler.

-Avi


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

> 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 <http://dev.mysql.com/doc/refman/5.1/en/select.html> SUM<http://dev.mysql.com/doc/refman/5.1/en/group-by-functions.html#function_sum>
> (`billsec`)/60 FROM `v_xml_cdr<https://sip.bestfone.com/mod/adminer/index.php?server=localhost&username=root&db=freeswitch&table=v_xml_cdr>
> ` WHERE `sip_to_user` = '$number' AND<http://dev.mysql.com/doc/refman/5.1/en/logical-operators.html#operator_and>
>  `start_stamp` LIKE<http://dev.mysql.com/doc/refman/5.1/en/string-comparison-functions.html#operator_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
>
>
>
> _________________________________________________________________________
> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20120116/49e3bdac/attachment-0001.html