Hi
<span style>Brynjolfur,</span><div><div style="text-align:left"><font color="#222222" face="arial, sans-serif"><span style="white-space:nowrap"><br></span></font></div><div style="text-align:left"><font color="#222222" face="arial, sans-serif"><span style="white-space:nowrap">Yes, this is exactly what I am looking for - hopefully in English :-)</span></font></div>
<div style="text-align:left"><font color="#222222" face="arial, sans-serif"><span style="white-space:nowrap"><br></span></font></div><div style="text-align:left"><font color="#222222" face="arial, sans-serif"><span style="white-space:nowrap">Date or range selection would make this perfect. I have been looking for something like this for quite a while but there is none. I would really appreciate it if you share this with me.</span></font></div>
<div style="text-align:left"><font color="#222222" face="arial, sans-serif"><span style="white-space:nowrap"><br></span></font></div><div style="text-align:left"><font color="#222222" face="arial, sans-serif"><span style="white-space:nowrap">Question here, does the .php code read from database and displays or does it analyse the custom-cdr.csv file?</span></font></div>
<div style="text-align:left"><font color="#222222" face="arial, sans-serif"><span style="white-space:nowrap"><br></span></font></div><div style="text-align:left"><font color="#222222" face="arial, sans-serif"><span style="white-space:nowrap">Best,</span></font></div>
<div style="text-align:left"><font color="#222222" face="arial, sans-serif"><span style="white-space:nowrap"><br></span></font></div><br><div class="gmail_quote">On Fri, Feb 10, 2012 at 4:10 AM, Brynjolfur Thorvardsson <span dir="ltr"><<a href="mailto:binni@itanet.nu">binni@itanet.nu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="DA" link="blue" vlink="purple"><div><p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Hi, I forgot to add that you are free to use my code, I’ll mail it later today.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><div><div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">Fra:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:asterisk-users-bounces@lists.digium.com" target="_blank">asterisk-users-bounces@lists.digium.com</a> [mailto:<a href="mailto:asterisk-users-bounces@lists.digium.com" target="_blank">asterisk-users-bounces@lists.digium.com</a>] <b>På vegne af </b>Brynjolfur Thorvardsson<br>
<b>Sendt:</b> 10. februar 2012 09:47</span></p><div class="im"><br><b>Til:</b> Asterisk Users Mailing List - Non-Commercial Discussion<br></div><b>Emne:</b> Re: [asterisk-users] Is there a php script to analyse and show call detail reports from Asterisk CDR?<u></u><u></u><p>
</p></div></div><div><div class="h5"><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Hi, I’m working on a small php program for just this. I guess from your question that you have Asterisk writing to a CDR database table, in which case you should be able to use my .php code fairly easily. It’s nothing fancy but does give me a graphical presentation of calls/15minute segments.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Attached is a screenshot of a graph, I have 1,5+ million entries in the table but there is no noticeable lag in refreshing the graph. At the moment it refreshes only when the button is pressed (the text is in Danish ...) but changing it to refresh automatically every 15 minutes wouldn’t be a major problem. I’m working on adding the option of selecting date ranges, it’s all still a work in progress!<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Regards<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Binni<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">Fra:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:asterisk-users-bounces@lists.digium.com" target="_blank">asterisk-users-bounces@lists.digium.com</a> [<a href="mailto:asterisk-users-bounces@lists.digium.com" target="_blank">mailto:asterisk-users-bounces@lists.digium.com</a>] <b>På vegne af </b>asterisk jobs<br>
<b>Sendt:</b> 9. februar 2012 16:36<br><b>Til:</b> Asterisk Users Mailing List - Non-Commercial Discussion<br><b>Emne:</b> [asterisk-users] Is there a php script to analyse and show call detail reports from Asterisk CDR?<u></u><u></u></span></p>
</div><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Hi everyone,<u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">I have tons of CDR from an Asterisk with a PRI connection. I want to know som extra details about the calls like the maximum number of calls in peak hours, etc...so I am looking for a php or other type of script that would show this to me in a GUI graphica format. Ideally, it would amazing to feed the asteriskcdrdb table to the program and get back the results without installing anything on the Asterisk server as I don't want to tamper with the server.<u></u><u></u></p>
</div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Is there such a tool?<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Thanks,<u></u><u></u></p>
</div><p> <u></u><u></u></p><p> <u></u><u></u></p></div></div></div></div><br>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br></div>