CDR database Question

[RICHARD MESSINGER]

I have a partner that is extracting information from CDR records and has the following questions that I am not sure where I can extract the answer from the documentation.

1) Is there a way from the CDR records to determine if a call is part of a n-way conference call?

2) Am I correct in saying that if the originalCalledPartyNumber is different from the lastRedirectDN or the finalCalledPArtyNumber, then the call was forwarded?

Or will there be multiple records with the same globalCallIdentifier, one with each forwarded number as a destination and duration?

[mowour · Accepted solution]

Hi Richard,

Multiple records are logged for calls that are part of a conference. The number of CDR records generated depends on the number of participants in the conference. There should be a CDR record of each party in the conference, one for the original placed call, and another for each setup call that was used to join other parties to the conference. So for example, a 3 party Ad-Hoc conference would generate 5 CDR records.

The conference bridge port is often represented by a number in the form of “b0019901001”, and calls to the conference bridge appear as calls into this number.

So to answer your first question, you can determine if a call is part of a n-way conference call if the “finalCalledPartyNumber” is “b0019901001”.

You can also tell that a call leg is part of the conference if:

. the “origCalledPtyRedirectOnBehalfOf” is set to Conference (4)

. the “LastRedirectRedirectOnBehalfOf” is set to Conference (4)

. the “JoinOnBehalfOf” is set to Conference (4)

The original placed call and all setup calls that were used to join parties to the conference will also have both the “origCallTerminationOnBehalfOf” and the "destCallTerminationOnBehalfOf” set to Conference (4).

Perhaps the partner might find this site useful.

http://www.cisco.com/warp/public/570/avvid/voice_ip/cm_cdr/cm_cdrfaq.html

Regards,

Michael.