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

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.
Selecting the correct parser for Cisco Call Manager (CSV) v6
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.