Cisco Call Manager (CSV) v6. SMDR/CDR data format and connection settings

This data is being extracted with help of the "Advanced PBX Data Logger" software only. It may not applicable for other software titles.

Cisco Unified Communications Manager

CDR Repository Manager

Within a Cisco Unified Communications Manager server or cluster, one instance of the CDR Repository Manager runs on the CDR Repository server or node. It manages CDR files that are received from the Cisco Unified Communications Manager nodes and periodically sends the files to the specified customer/third-party billing servers via FTP/SFTP. Our PBX Data Logger polls the FTP server and retrives new data. You should add the "File" data source type and configure a FTP or SFTP connection with the FTP server.

When the file arrives on the CDR Repository server or node, the CDR Repository Manager detects it. The system archives the file in a directory that is dedicated to the date that is indicated by the UTC timestamp that was placed in the file name when the file was created.

If any external billing server is specified in the CDRM configuration, the system creates an empty file in each of the corresponding folders for CAR and the billing servers, if CAR or the corresponding billing server is activated. The CDR Agent monitors new CDR/CMR files that are generated on CallManager servers or nodes by the call processing component. It sends the files to the CDR Repository node and then deletes the local copy after the file is pushed out. The file sender component of the CDR Repository Manager detects these empty files and sends the file to the destination with the specified method. If the delivery is successful, the system removes the empty file in the destination directory. Every Cisco Unified Communications Manager can generate one CDR file and one CMR file every minute for up to 1 hour. You can configure the maximum disk space that is used for storage of CDR files in the CDR Repository through provisioning. The File Manager component of the CDR Repository Manager runs hourly. When the File Manager runs, it deletes files with dates outside the configured preservation duration. It also checks whether disk usage has exceeded the high water mark. If so, the system deletes the processed CDR files until the low water mark is reached, starting with the oldest files. However, if any CDR file to be deleted was not successfully sent to the specified billing server, the system leaves it in the CDR Repository and raises a notification or alarm. The system creates a flag file during the configured maintenance window, which denies access to the CDR files for the CDR onDemand Service. The system removes the flag file after the maintenance window expires.

For detailed procedures on configuring the CDR Repository Manager and customer billing servers, see "Cisco Unified Communications Manager Call Detail Records Administration Guide"

Architecture

Data flow diagram

CDR fields

For detailed description of CDR fields, see here:
Cisco CallManager 6
Cisco CallManager 7
Cisco CallManager 8

Configuring PBX Data Logger

1. Create the new "File" data source.
2. Click "Actions → Add...".
3. Select the "FTP" file transfer protocol and configure connection with a FTP server on your PBX.
4. Adjust read options.

Adding a new file data source for Cisco Call Manager

Cisco Call Manager. Data source selection dialog.

Configuring FTP connection to Cisco Call Manager

192.168.0.1

/path/to/files/

*.*

admin

Adjusting read options for Cisco Call Manager

Selecting the correct parser for Cisco Call Manager (CSV) v6

Cisco Call Manager (CSV) v6

Data items

Description	Data type	Column name
Cdr Record Type	integer	CDRRECORDTYPE
Date Time Origination	integer	CALL_TIME
Date Time Origination	integer	CALL_TIME2
Original Node Id	integer	ORIGNODEID
Calling Party Number	string	CALLINGPARTYNUMBER
Destination Node Id	integer	DESTNODEID
Original Called Party Number	string	ORIGINALCALLEDPARTYNUMBER
Pkid	string	PKID
Duration	integer	CALL_DURATION_S
Authorization Code Value	string	AUTH
Call duration	datetime	CALL_DURATION
Direction	string	DIRECTION
Call type	string	CALL_TYPE
Dialed phone	string	DIALED_PHONE
Caller phone	string	CALLER_PHONE
Trunk	string	TRUNK
Extension	string	EXT
Global CallID call Manager Id	integer	GLOBALCALLID_CALLMANAGERID
Global CallID call Id	integer	GLOBALCALLID_CALLID
Original Leg Call Identifier	integer	ORIGLEGCALLIDENTIFIER
Original Span	integer	ORIGSPAN
Original Ip Addr	integer	ORIGIPADDR
Calling Party Unicode Login UserID	string	CALLINGPARTYUNICODELOGINUSERID
Original Cause location	integer	ORIGCAUSE_LOCATION
Original Cause value	integer	ORIGCAUSE_VALUE
Original Precedence Level	integer	ORIGPRECEDENCELEVEL
Original Media Transport Address IP	integer	ORIGMEDIATRANSPORTADDRESS_IP
Original Media Transport Address Port	integer	ORIGMEDIATRANSPORTADDRESS_PORT
Original Media Cap payload Capability	integer	ORIGMEDIACAP_PAYLOADCAPABILITY
Original Media Cap max Frames Per Packet	integer	ORIGMEDIACAP_MAXFRAMESPERPACKET
Original Media Cap g723 Bit Rate	integer	ORIGMEDIACAP_G723BITRATE
Original Video Cap Codec	integer	ORIGVIDEOCAP_CODEC
Original Video Cap Bandwidth	integer	ORIGVIDEOCAP_BANDWIDTH
Original Video Cap Resolution	integer	ORIGVIDEOCAP_RESOLUTION
Original Video Transport Address IP	integer	ORIGVIDEOTRANSPORTADDRESS_IP
Original Video Transport Address Port	integer	ORIGVIDEOTRANSPORTADDRESS_PORT
Original RSVP Audio Stat	string	ORIGRSVPAUDIOSTAT
Original RSVP Video Stat	string	ORIGRSVPVIDEOSTAT
Destination Leg Identifier	integer	DESTLEGIDENTIFIER
Destination Span	integer	DESTSPAN
Destination Ip Addr	integer	DESTIPADDR
Final Called Party Number	string	FINALCALLEDPARTYNUMBER
Final Called Party Unicode Login UserID	string	FINALCALLEDPARTYUNICODELOGINUSERID
Destination Cause location	integer	DESTCAUSE_LOCATION
Destination Cause value	integer	DESTCAUSE_VALUE
Destination Precedence Level	integer	DESTPRECEDENCELEVEL
Destination Media Transport Address IP	integer	DESTMEDIATRANSPORTADDRESS_IP
Destination Media Transport Address Port	integer	DESTMEDIATRANSPORTADDRESS_PORT
Destination Media Cap payload Capability	integer	DESTMEDIACAP_PAYLOADCAPABILITY
Destination Media Cap max Frames Per Packet	integer	DESTMEDIACAP_MAXFRAMESPERPACKET
Destination Media Cap g723 Bit Rate	integer	DESTMEDIACAP_G723BITRATE
Destination Video Cap Codec	integer	DESTVIDEOCAP_CODEC
Destination Video Cap Bandwidth	integer	DESTVIDEOCAP_BANDWIDTH
Destination Video Cap Resolution	integer	DESTVIDEOCAP_RESOLUTION
Destination Video Transport Address IP	integer	DESTVIDEOTRANSPORTADDRESS_IP
Destination Video Transport Address Port	integer	DESTVIDEOTRANSPORTADDRESS_PORT
Destination RSVP Audio Stat	string	DESTRSVPAUDIOSTAT
Destination RSVP Video Stat	string	DESTRSVPVIDEOSTAT
Date Time Connect	datetime	DATETIMECONNECT
Date Time Disconnect	datetime	DATETIMEDISCONNECT
Last Redirect Dn	string	LASTREDIRECTDN
Original inal Called Party Number Partition	string	ORIGINALCALLEDPARTYNUMBERPARTITION
Calling Party Number Partition	string	CALLINGPARTYNUMBERPARTITION
Final Called Party Number Partition	string	FINALCALLEDPARTYNUMBERPARTITION
Last Redirect Dn Partition	string	LASTREDIRECTDNPARTITION
Original Device Name	string	ORIGDEVICENAME
Destination Device Name	string	DESTDEVICENAME
Original Call Termination On Behalf Of	integer	ORIGCALLTERMINATIONONBEHALFOF
Destination Call Termination On Behalf Of	integer	DESTCALLTERMINATIONONBEHALFOF
Original Called Party Redirect On Behalf Of	integer	ORIGCALLEDPARTYREDIRECTONBEHALFOF
Last Redirect Redirect On Behalf Of	integer	LASTREDIRECTREDIRECTONBEHALFOF
Original Called Party Redirect Reason	integer	ORIGCALLEDPARTYREDIRECTREASON
Last Redirect Redirect Reason	integer	LASTREDIRECTREDIRECTREASON
Destination Conversation Id	integer	DESTCONVERSATIONID
Global Call Id ClusterID	string	GLOBALCALLID_CLUSTERID
Join On Behalf Of	integer	JOINONBEHALFOF
Comment	string	COMMENT
Auth Code Description	string	AUTHCODEDESCRIPTION
Authorization Level	integer	AUTHORIZATIONLEVEL
Client Matter Code	string	CLIENTMATTERCODE
Original DTMF Method	integer	ORIGDTMFMETHOD
Destination DTMF Method	integer	DESTDTMFMETHOD
Call Secured Status	integer	CALLSECUREDSTATUS
Original Conversation Id	integer	ORIGCONVERSATIONID
Original Media Cap Bandwidth	integer	ORIGMEDIACAP_BANDWIDTH
Destination Media Cap Bandwidth	integer	DESTMEDIACAP_BANDWIDTH

Interested in reports for PBX usage?

We offer the PBX Reports utility with various manual, scheduled and email reports, built-in web-server, and other features. Look here

Want PBX call logs in a database?

This is the standard feature. The logger captures exports SMDR or CDR data in real-time to your database. Follow this link

Note: Products and companies mentioned here are used only for definition and identification purposes and can be trademarks and/or registered trademarks of the respective companies.