This was already answered a few month ago. Someone build a script that does that.<br>
<br>
Jose Simoes<br><br><div><span class="gmail_quote">On 3/21/06, <b class="gmail_sendername">Duncan Glendinning</b> <<a href="mailto:Duncan.Glendinning@cox.net">Duncan.Glendinning@cox.net</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div style="direction: ltr;">
<div>
<p><font color="blue" face="Comic Sans MS" size="3"><span style="font-size: 12pt; color: blue;">I've successfully
configured SER to inject accounting details into a MySql DB. I've
searched various resources to see if there are MySql scripts to generate
summary and detailed accounting information for each SIP source, but have found
none. Earlier this year, there was a thread asking for open source accounting
packages, but I don't recall a reply being posted. In essence, I want to
select records within a certain time window, and then find the corresponding
BYE record for each INVITE record associated with each SIP source to determine
the duration of the call, and then accumulate the duration of all calls. Before
I develop my own scripts, I thought I'd ask you folks for a pointer to
existing examples / solutions, should they exist.</span></font></p>
<p><font color="blue" face="Comic Sans MS" size="3"><span style="font-size: 12pt; color: blue;"> </span></font></p>
<p><font color="blue" face="Comic Sans MS" size="3"><span style="font-size: 12pt; color: blue;">Thanks,</span></font></p>
<p><font color="blue" face="Comic Sans MS" size="3"><span style="font-size: 12pt; color: blue;">Duncan</span></font><font color="blue"><span style="color: blue;"></span></font></p>
<p><font color="blue" face="Comic Sans MS" size="3"><span style="font-size: 12pt; color: blue;">---</span></font><font color="blue"><span style="color: blue;"></span></font></p>
<p><font color="blue" face="Times New Roman" size="3"><span style="font-size: 12pt; color: blue;"><a href="mailto:Duncan.Glendinning@cox.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><font face="Comic Sans MS">
<span>Duncan.Glendinning@cox.net</span></font></a></span></font></p>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
</div>
</div><br>_______________________________________________<br>Serusers mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.iptel.org/mailman/listinfo/serusers" target="_blank">
http://lists.iptel.org/mailman/listinfo/serusers</a><br><br><br></blockquote></div><br>