[Serusers] session duration accounting

[Iqbal]

put those queries in mysql and it should lookup your acc table

Iqbal

Ryan Pagquil wrote:

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