[Serusers] HELP: how to get correct call duration??

[Mohammad Khan]

Yes, the duration of call should be just the way you said.
But I am not aware about any UA can send msg back to other UA right 
after pick up the call.

I just use the following query to get successfull calls
select sip_callid from acc where sip_status=200 group by sip_callid 
having count(*) = 3;

If you know the way to get exact call duration, please share with me.
I know, the way I am doing it is couple of seconds more than the actual 
duraion.

Thanks,
Mohammad




Charles Wang wrote:

>Hi,
>
>I think that the ACK after INVITE is only the callee(UAC) receives my
>INVITE and ready to start RINGING. But this time is not the really
>Call Start.
>Generally, the start time of call should be callee hangup the phone
>after ringing.
>Do you have any idea about it? 
>
>On 4/28/05, info at beeplove.com <info at beeplove.com> wrote:
>  
>
>>Actually, to get call duration, you need to use ACK and BYE (both should
>>have status 200).
>>INVITE sends an request to other party to initiate a call.
>>Other party send ACK with status 200 to receive the call.
>>
>>Original Message:
>>-----------------
>>From: Charles Wang lazy.charles at gmail.com
>>Date: Thu, 28 Apr 2005 02:49:42 +0800
>>To: serusers at lists.iptel.org
>>Subject: [Serusers] HELP: how to get correct call duration??
>>
>>
>>Hi, ALL:
>>
>>I know ser can insert INVITE & BYE records to acc table.
>>Maybe the timestamp of BYE record is correct but the timestamp
>>of INVITE is not equal to the call start(after the callee answered).
>>Is there any method to generate a record with timestamp when the callee
>>answer?
>>I think that it should be the callee responses "200 OK" after "100 Trying".
>>How to do it???
>>
>>--
>>
>>Best Regards
>>Charles
>>
>>_______________________________________________
>>Serusers mailing list
>>serusers at lists.iptel.org
>>http://lists.iptel.org/mailman/listinfo/serusers
>>
>>--------------------------------------------------------------------
>>mail2web - Check your email from the web at
>>http://mail2web.com/ .
>>
>>
>>    
>>
>
>
>  
>