[Serusers] session duration accounting

[Gustavo García]

NOTE2: This will not work if the BYE is lost, too.

Regards.
G.

-----Mensaje original-----
De: serusers-bounces at iptel.org [mailto:serusers-bounces at lists.iptel.org] En nombre
de Java Rockx
Enviado el: lunes, 04 de julio de 2005 15:11
Para: Iqbal
CC: serusers at 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 at gigo.co.uk> wrote:
> its records the INVITE and BYE, so fro there you can work out the
> session duration
> 
> Iqbal
> 
> Ryan Pagquil wrote:
> 
> > guys,
> >       just want to ask if i can make ser to account session durations
> > for billing purposes?
> >
> > Thanks,
> >
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers
>

_______________________________________________
Serusers mailing list
serusers at lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers