RE: [Serusers] session duration accounting

NOTE2: This will not work if the BYE is lost, too. Regards. G. -----Mensaje original----- De: serusers-bounces(a)iptel.org [mailto:serusers-bounces@lists.iptel.org] En nombre de Java Rockx Enviado el: lunes, 04 de julio de 2005 15:11 Para: Iqbal CC: serusers(a)lists.iptel.org Asunto: Re: [Serusers] session duration accounting Ryan, This MySQL query should do the trick. It joins the acc table to itself. One side grabs INVITE messages and the other side grabs BYE messages. NOTE: This will not work if you account for re-INVITE messages because you will then have multple INVITEs for the same call. Regards, Paul SELECT t1.from_uri as orig_number, t1.to_uri as term_number, TIMEDIFF(t2.time, t1.time) as duration, t1.timestamp 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='INVITE' AND t2.sip_method='BYE' On 7/4/05, Iqbal <iqbal(a)gigo.co.uk> wrote: _______________________________________________ Serusers mailing list serusers(a)lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers