Cisco UCCE SRND's

http://www.cisco.com/en/US/products/sw/custcosw/ps1844/products_implementation_design_guides_list.html

Cisco UCCE Compatibility Matrix

http://docwiki.cisco.com/wiki/Compatibility_Matrix_for_Unified_CCE

Cisco UCCE expanding ICM SQL database

http://www.cisco.com/image/gif/paws/20493/expand_sql.pdf

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,...