Monday, August 9, 2010

CUCM CDR "Howto CUCM Call Detail Records"

http://www.cisco.com/en/US/docs/voice_ip_comm/cucmbe/service/6_0_1/car/carcdrdef.html#wpxref69753




Filename Format

The following example shows the full format of the filename:

tag_clusterId_nodeId_datetime_seqNumber

• tag—Identifies the type of file, either CDR or CMR

• clusterId—Identifies the server where the Cisco Unified Communications Manager database exists

• nodeId—Identifies the node

• datetime—UTC time in yyyymmddhhmm format

• seqnumber—Sequence number

Two examples of filenames follow:

• cdr_Cluster1_01_200404021658_1

• cmr_Cluster1_02_200404061011_6125

________________________________________

Note For Cisco Unified Communications Manager Business Edition installations, the value assigned to the clusterId equals 01.

________________________________________

Flat File Format

The CDR and CMR flat files have the following format:

• Line 1—List of field names comma separated

• Line 2—List of field type comma separated

• Line 3—Data comma separated

• Line 4—Data comma separated

The following shows an example of a flat file:

Line1-"cdrRecordType","globalCallID_callManagerId","globalCallID_callId","origLegCallIdent

ifier",...

Line2-INTEGER,INTEGER,INTEGER,INTEGER,...

Line3-1,1,388289,17586046,...

Line4-1,1,388293,17586054,...