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@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@lists.freeswitch.org" < freeswitch-users-request@lists.freeswitch.org> *To:* freeswitch-users@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@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@lists.freeswitch.org
You can reach the person managing the list at freeswitch-users-owner@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@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@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@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org