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@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@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers