cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
820
Views
0
Helpful
0
Replies

Relation between Call Detail Record (CM CDR) and Termination Call Detail (awdb ICM)

cristian.gomes
Level 1
Level 1

Hello There,

I am handling with a report that needs to relate each call registered on CDR with the awbd on ICM. At the first time i joined the formula

"(globalCallID_callManagerId * 0x1000000) + globalCallID_callId" to the ICM.PeripheralCallKey and it worked... just for a few time.

After looking forward, i saw if a call had some transfer or conference, the PeripheralCallKey won't be not unique... so my "solution" failed...

At the second time, i tryed to join the OUTGOINGPROTOCOLCALLREF and INCOMINGPROTOCOLCALLREF to the ICM.CALLREFERENCEID and ICM.CALLGUID - but this relation does not have a pattern, than i can't join my calls from CDR to ICM.

Please, someone knows if there is other way to join my calls from CDR to ICM?

Regards,

Guilherme

0 Replies 0