cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Community Helping Community

423
Views
0
Helpful
3
Replies
Beginner

Different times in UCCX database don't seem to add up?

'Hi,
I am making some reports from the UCCX database. To examine the database I use SQuirrel.
In the documentation it states that the total connection time of an incoming call is found in:

contactcalldetail.connecttime

I assumed that this would equal the sum of the time spent in de CSQ queue + the time spent with the agent:

contactqueuedetail.queuetime + agentconnectiondetail.ringtime + agentconnectiondetail.talktime + agentconnectiondetail.holdtime

However i do see different outcomes, sometimes missing some seconds and sometime not.

An example of the output table:

sessionidtargetidconnecttimequeuetimeringtimetalktimeholdtimeworktime
9,000,000,053395312121200
9,000,000,05539251915000
9,000,000,05539251915000
9,000,000,0613827221700
9,000,000,0643833112500
9,000,000,0674832112400
9,000,000,089501144200
9,000,000,093511344400
9,000,000,095502122800
9,000,000,097512260000
9,000,000,104501622900
9,000,000,1065018111000
9,000,000,1085022221400
9,000,000,1135216228060
9,000,000,12652191112060
9,000,000,14152255514046
9,000,000,1435266244271060
9,000,000,14652814471044

The query i build in squirrel

select contactqueuedetail.sessionid,targetid, connecttime,contactqueuedetail.queuetime,  agentconnectiondetail.ringtime, agentconnectiondetail.talktime, agentconnectiondetail.holdtime,agentconnectiondetail.worktime from contactqueuedetail join contactroutingdetail on contactroutingdetail.sessionid=contactqueuedetail.sessionid join contactcalldetail on contactqueuedetail.sessionid=contactcalldetail.sessionid join agentconnectiondetail on contactqueuedetail.sessionid=agentconnectiondetail.sessionid where contactcalldetail.startdatetime > '2016-09-01 00:00:00' and contactcalldetail.enddatetime < '2016-09-01 23:00:00'

Even when going through the tables by hand and selecting on the sessionid I get the same result.
All the calls made on that date are simple test calls, no overflow and just 1 agent logged in.

I am sure I am missing something but what?

Everyone's tags (2)
3 REPLIES 3
Cisco Employee

Re: Different times in UCCX database don't seem to add up?

Hi,

Most of the Columns that your are showing in the table is already available as stock reports in CCX, can you check if the data you see and what is shown in the CCX reports are identical for comparison, you can check the reporting guide for which tables these stock reports are referring to, so that your getting the data from the correct source.

Regards,

Ratish

Beginner

Re: Different times in UCCX database don't seem to add up?

Hi,

I looked for 9,000,000,061 in the various reports:

This is what i found:

  

Agentdetail report
talktime17
duration20

    

Detailed call by call ccdr report
talktime17
queuetime2
Endtime - starttime27 9-1-2016  9:42:219/1/16 9:41:54 am

  

Detailed Call CSQ Agent Report
ringtime2

Is the duration of an ACD call the Endtime - starttime (27 seconds) or is the duration of an ACD call talktime+ringtime+queuetime (17+4+4=21 seconds) although the agentdetail report shows 20 seconds (could be rounding error)

What is the difference between the 27 second duration and the 20 (21) second duration.

Either I am missing something or I don't understand something.

Regards,

René

Highlighted
Cisco Employee

Re: Different times in UCCX database don't seem to add up?

In Agent Detail report the Duration is sum of Talk time and Work time.

In CCDR report the start - End time is Queue time+ ring time+ Talk time+ Hold time+ Work time.

I think if your seeing a diff between Start- end vs the total duration then its a bug, let me check and get back.

Regards,

Ratish

CreatePlease to create content
Content for Community-Ad
FusionCharts will render here