CDRTool is good. But I say you make your own sql queries and to process the calls. The good thing about a complete call you will be having three records containg the same sip_callid you can use this filed to find all invite/ack and bye.
<br><br><div><span class="gmail_quote">On 1/19/07, <b class="gmail_sendername">Rosa De Santis</b> &lt;<a href="mailto:rosadesantis@hotmail.com">rosadesantis@hotmail.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>Hello all.<br>I have accounting with MySQL working fine. I have records on my acc table.<br>Please, I&#39;d like to know if there is a tool to process the acc table entries to get completed calls on another MySQL table, taking into account missing BYEs or CANCELs.
<br><br>I found that CDRtool can do this and more, but its not free and it seems to be complicated.<br>Thanks in advance for any help<br><br>Rosa.<br>_________________________________________________________________<br>Descubre 
<a href="http://Live.com">Live.com</a> - tu mundo en línea reunido: noticias, deportes, el tiempo, y mucho más.<br><a href="http://www.live.com/getstarted_______________________________________________">http://www.live.com/getstarted_______________________________________________
</a><br>Serusers mailing list<br><a href="mailto:Serusers@lists.iptel.org">Serusers@lists.iptel.org</a><br><a href="http://lists.iptel.org/mailman/listinfo/serusers">http://lists.iptel.org/mailman/listinfo/serusers</a><br>
</blockquote></div><br>