CMR output does not match CMR definition V10 and V11

[dcomber76]

I'm working with importing CMR files into a DB for later processing. I created all the tables based on CMR definitions found here

http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/service/10_0_1/cdrdef/CUCM_BK_CBB143DE_00_cucm-cdr-administration-guide-100/CUCM_BK_CBB143DE_00_cucm-cdr-administration-guide-100_chapter_0111.html

and

http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/service/11_0_1/cdrdef/CUCM_BK_RFDE0054_00_cucm-cdr-administration-guide-1101/cisco_call_management_record_field_descriptions.html

Then I noticed that the fields do not match at all... I mean at all. I've obtained 3 sample CMR's from 3 different systems (3 client builds) and all have the exact same CMR fields.

The CMR definitions have loads about video but in reality the output has nothing at all.

Is there anything we are missing on the CUCM config side? Samples are obtained on the CAR portal.

Sample	Definition
cdrRecordType	cdrRecordType
globalCallID_callManagerId	globalCallID_callManagerId
globalCallID_callId	globalCallId_callId
orignodeId	nodeId
destnodeId	directoryNumber
origlegcallIdentifier	callIdentifier
destlegidentifier	dateTimeStamp
orignumberPacketsSent	numberPacketsSent
orignumberOctetsSent	numberOctetsSent
orignumberPacketsReceived	numberPacketsReceived
orignumberOctetsReceived	numberOctetsReceived
orignumberPacketsLost	numberPacketsLost
destnumberPacketsSent	jitter
destnumberOctetsSent	latency
destnumberPacketsReceived	pkid
destnumberOctetsReceived	directoryNumberPartition
destnumberPacketsLost	globalCallId_ClusterId
origjitter	deviceName
destjitter	varVQMetrics
origlatency	duration
destlatency	videoContentType
pkid	videoDuration
origdeviceName	numberVideoPacketsSent
destdeviceName	numberVideoOctetsSent
origvarVQMetrics	numberVideoPacketsReceived
destvarVQMetrics	numberVideoOctetsReceived
globalCallId_ClusterID	numberVideoPacketsLost
callingPartyNumber	videoAverageJitter
finalCalledPartyNumber	videoRoundTripTime
callingPartyNumberPartition	videoOneWayDelay
finalCalledPartyNumberPartition	videoTransmissionMetrics
	videoReceptionMetrics
	videoContentType_channel2
	videoDuration_channel2
	numberVideoPacketsSent_channel2
	numberVideoOctetsSent_channel2
	numberVideoPacketsReceived_channel2
	numberVideoOctetsReceived_channel2
	numberVideoPacketsLost_channel2
	videoAverageJitter_channel2
	videoRoundTripTime_channel2
	videoOneWayDelay_channel2
	videoReceptionMetrics_channel2
	videoTransmissionMetrics_channel2

[Manish Gogna]

Can you check if the following service parameter is set to "Enabled Regardless of CDR Enabled Flag" on cucm

Clusterwide Parameters (Device - General)

Call Diagnostics Enabled

Manish

[dcomber76]

Thanks Manish,

That flag was off, I have enabled it.

Do I need to restart any services to see a change in the file. how long do I need to wait to see the extra details..

assuming as this was off I will need to make some test calles or wait til tomorrow for the extra data to come through, unless by magic Cisco has the details cached

[Manish Gogna]

Hi,

This will only apply to the new calls now. No services need to be restarted. You should be able to see the results tomorrow if CDR Load happens at midnight. If it is 24*7 then you can check it today as well after an hour or so.

Manish

[dcomber76]

ok many thanks.. will see how it goes