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.