[Serusers] session duration accounting

[Ryan Pagquil]

Hi,
       So the only concept on how will I account for duration is to 
account for INVITE and BYE methods...BTW, where will I put those 
queries? Sorry, I'm in a stage of discovering SER.=)

Thanks,



Java Rockx wrote:

>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
>>
>>    
>>
>
>
>  
>


-- 
Ryan Pagquil
Infodyne Inc. - PhilOnline.com
3603 Antel Global Corporate Center
Doña Julia Vargas Ave.
Ortigas Center Pasig City
Tel: 687-0715
Web: www.philonline.com