[Serusers] session duration accounting

[Java Rockx]

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
>