[Serusers] SER billing softwares

[Olivier.taylor]

try that
 
SELECT t1.from_uri as Caller,  t1.to_uri as Callee,
TIMEDIFF(t2.time, t1.time) as Duration,  t1.time as CallDate 
FROM acc t1, acc t2  WHERE t1.sip_callid = t2.sip_callid AND
((t1.fromtag = t2.fromtag and t1.totag = t2.totag) OR
 (t1.fromtag = t2.totag and t1.totag = t2.fromtag)) AND
 t1.sip_method='ACK' AND
 t2.sip_method='BYE'
order by t1.time desc


-----Message d'origine-----
De : serusers-bounces at iptel.org [mailto:serusers-bounces at lists.iptel.org] De
la part de Script Head
Envoyé : samedi 18 février 2006 2:03
À : serusers at lists.iptel.org
Objet : Re: [Serusers] SER billing softwares


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.




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20060218/b49559e9/attachment.htm>