Thx Rudi. but this query results in *Empty set (0.32 sec) src AND dst like number *seems to be the problem area. * * Also, how can I get the hold time & talk time as separate values OR may be total call connect time & talk time (the difference of the 2 will be hold time).
Thx Sans On Wed, Aug 4, 2010 at 6:18 PM, Rudi Oosthuizen <[email protected]>wrote: > Mysql > Use asteriskcdrdb; > Select calldate,src,dst,disposition,duration,billsec,uniqueid from cdr > where src like 'NUMBER' and dst like 'NUMBER' order by calldate; > > > Rudi Oosthuzen > > > > > > > Hi, > > > Can someone help me formulate MySQL Query(s) which will help me > extract the > > following details for a given DID (date range can be excluded for > > simplicity). > > > Date-Time > > DNID (I am recording this is `userfield`) > > CLID > > time-1 (when call was received) > > time-2 (when call was answered by agent) > > time-3 (when call was hung-up) > > > My Call flow is as follows: > > - Caller dials a DNID > > - Call enters queue > > - Call rings in round-robin format to all logged in agents > > - Agent answers call > > - Both parties hand-up > > > Any help with MySQL queries or pointers are deeply appreciated. > > > Thx > > Sans >
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
