<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=906030411-18022006><FONT face=Arial color=#0000ff size=2>try
that</FONT></SPAN></DIV>
<DIV><SPAN class=906030411-18022006></SPAN> </DIV>
<DIV><SPAN class=906030411-18022006><FONT face=Arial color=#0000ff size=2>SELECT
t1.from_uri as Caller, t1.to_uri as Callee,<BR>TIMEDIFF(t2.time, t1.time)
as Duration, t1.time as CallDate <BR>FROM acc t1, acc t2 WHERE
t1.sip_callid = t2.sip_callid AND<BR>((t1.fromtag = t2.fromtag and t1.totag =
t2.totag) OR<BR> (t1.fromtag = t2.totag and t1.totag = t2.fromtag))
AND<BR> t1.sip_method='ACK' AND<BR> t2.sip_method='BYE'<BR>order by
t1.time desc<BR></FONT></SPAN></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=fr dir=ltr align=left><FONT face=Tahoma
size=2>-----Message d'origine-----<BR><B>De :</B>
serusers-bounces@iptel.org [mailto:serusers-bounces@lists.iptel.org] <B>De la part
de</B> Script Head<BR><B>Envoyé :</B> samedi 18 février 2006
2:03<BR><B>À :</B> serusers@lists.iptel.org<BR><B>Objet :</B> Re:
[Serusers] SER billing softwares<BR><BR></FONT></DIV>Well another newbie
question - is it possible to generate CDR either directly or by parsing logs?
Has something like this been done? I have Googled this more than once and
haven't stumbled on anything like that.<BR><BR><BR></BLOCKQUOTE></BODY></HTML>