Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

t_Termination_Call_Detail table and PeripheralCallType field

Hi,

     We recently upgraded from UCCE 6 (with IP IVR) to UCCE 7.5 with CVP 7.

I usually run a query against the t_termination_call_detail table and search for the different PeripheralCallType results (i.e. 1 fro inbound, 9 for outbound, and 7 for out dialer)

I've noticed that when I run the same query on the 7 version I don't have any PeripheralCallType of tyep 9.

Are the dialer calls registered in this table?

thanks

1 REPLY
New Member

Re: t_Termination_Call_Detail table and PeripheralCallType field

Hi

Please try from Dialer Detail table . below sample sql

select  PeripheralCallKey from Dialer_Detail
where DateTime >= '2010-08-04 00:00:00.000'
              AND DateTime <= '2010-08-04 23:59:00.000'

              AND CallResult in (10)

  --10-Customer answered and was connected to agent

use "PeripheralCallKey" to link with TCD.

Hope this will help.

Thanks

Regards,

Param

387
Views
0
Helpful
1
Replies