Get call time AFTER transfer?

[xtdirect]

VERSION: 2.6-372a
BUILD: 120713-2123

Looking for a place in the asterisk database where a call time is recorded once the agent leaves a three way conference....

The details:
I am using the agent API to control the call (not the issue... this is working great)... Doing a warm transfer by:
- Parking the call and dialing the new external number.
- Connecting the three parties together once the external number connects (Agent, Caller and External #).
- Then dropping the agent out of the call so the Caller and the External number can chat away...

Works Great... What I am looking for is a way to capture the them spent on the call AFTER the agent leaves the Caller and the External number parties.

I see that a new record is created in the asterisk.call_log table when the agent dials the external number, and that that record gets updated when the agent hangs-up the external number or leaves the three way conference.....

Is there any record of the time on the call between the Caller and the External number Once the agent has Dropped Out??

I have looked in every DB table I can think of to find this data but do not see it... Any thoughts?

Thanks in advance...

- Brian

[williamconley]

you'll need to grab the total call time for the original prospect and subtract the agent time with the prospect. They are in different tables, but the uniqueID should allow you to match them. Since both, in theory, should appear on the modify_lead page, this is a good resource to borrow the sql queries to get your data before the math.