Re: SQL query to generate CDR out of ACC logs

This is one I've been using, it gets me what I need.

SELECT 
                        invite.from_uri, 
                        invite.to_uri,
                        invite.sip_callid,
                        invite.timestamp as start,
                        bye.timestamp as end,
                        TIMESTAMPDIFF(MINUTE, invite.timestamp, bye.timestamp) 
as time,
                        subscriber.id,
                        user_info.first_name,
                        user_info.last_name
                FROM acc as invite, acc as bye, subscriber, subscriber as 
user_info
                WHERE
                        invite.sip_method="INVITE" AND 
                        bye.sip_method="BYE" AND
                        invite.sip_callid = bye.sip_callid AND
                        (subscriber.username = bye.username OR 
subscriber.username = 
invite.username) AND
                        user_info.username = invite.username AND
                        user_info.domain = invite.domain


On Friday 26 May 2006 12:52, Script Head wrote:
> Does anyone have a query that'd generate some sort of a CDR out of ACC log
> table? Supposely it's been posted before but I've looked thru the archives
> and didn't find it.