Cisco Call Manager (CSV) v10. 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) v10

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
Final Called Party Number	string	FINALCALLEDPARTYNUMBER
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 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
Outpulsed Calling Party Number	string	OUTPULSEDCALLINGPARTYNUMBER
Outpulsed Called Party Number	string	OUTPULSEDCALLEDPARTYNUMBER
Original Ipv4v6 Addr	string	ORIGIPV4V6ADDR
Destination Ipv4v6 Addr	string	DESTIPV4V6ADDR
Original Video Cap Codec Channel2	integer	ORIGVIDEOCAP_CODEC_CHANNEL2
Original Video Cap Bandwidth Channel2	integer	ORIGVIDEOCAP_BANDWIDTH_CHANNEL2
Original Video Cap Resolution Channel2	integer	ORIGVIDEOCAP_RESOLUTION_CHANNEL2
Original Video Transport Address IP Channel2	integer	ORIGVIDEOTRANSPORTADDRESS_IP_CHANNEL2
Original Video Transport Address Port Channel2	integer	ORIGVIDEOTRANSPORTADDRESS_PORT_CHANNEL2
Original Video Channel Role Channel2	integer	ORIGVIDEOCHANNEL_ROLE_CHANNEL2
Destination Video Cap Codec Channel2	integer	DESTVIDEOCAP_CODEC_CHANNEL2
Destination Video Cap Bandwidth Channel2	integer	DESTVIDEOCAP_BANDWIDTH_CHANNEL2
Destination Video Cap Resolution Channel2	integer	DESTVIDEOCAP_RESOLUTION_CHANNEL2
Destination Video Transport Address IP Channel2	integer	DESTVIDEOTRANSPORTADDRESS_IP_CHANNEL2
Destination Video Transport Address Port Channel2	integer	DESTVIDEOTRANSPORTADDRESS_PORT_CHANNEL2
Destination Video Channel Role Channel2	integer	DESTVIDEOCHANNEL_ROLE_CHANNEL2
Incoming ProtocolID	integer	INCOMINGPROTOCOLID
Incoming Protocol Call Ref	string	INCOMINGPROTOCOLCALLREF
Outgoing ProtocolID	integer	OUTGOINGPROTOCOLID
Outgoing Protocol Call Ref	string	OUTGOINGPROTOCOLCALLREF
Current Routing Reason	integer	CURRENTROUTINGREASON
Original Routing Reason	integer	ORIGROUTINGREASON
Last Redirecting Routing Reason	integer	LASTREDIRECTINGROUTINGREASON
Hunt Pilot Partition	string	HUNTPILOTPARTITION
Hunt PilotDN	string	HUNTPILOTDN
Called Party Pattern Usage	integer	CALLEDPARTYPATTERNUSAGE
IncomingICID	string	INCOMINGICID
Incoming OrigIOI	string	INCOMINGORIGIOI
Incoming TermIOI	string	INCOMINGTERMIOI
OutgoingICID	string	OUTGOINGICID
Outgoing OrigIOI	string	OUTGOINGORIGIOI
Outgoing TermIOI	string	OUTGOINGTERMIOI
Outpulsed Original Called Party Number	string	OUTPULSEDORIGINALCALLEDPARTYNUMBER
Outpulsed Last Redirecting Number	string	OUTPULSEDLASTREDIRECTINGNUMBER
Was Call Queued	integer	WASCALLQUEUED
Total Wait Time In Queue	integer	TOTALWAITTIMEINQUEUE
Calling Party Number uri	string	CALLINGPARTYNUMBER_URI
Original inal Called Party Number uri	string	ORIGINALCALLEDPARTYNUMBER_URI
Final Called Party Number uri	string	FINALCALLEDPARTYNUMBER_URI
Last Redirect Dn uri	string	LASTREDIRECTDN_URI
Mobile Calling Party Number	string	MOBILECALLINGPARTYNUMBER
Final Mobile Called Party Number	string	FINALMOBILECALLEDPARTYNUMBER
Original Mobile Device Name	string	ORIGMOBILEDEVICENAME
Destination Mobile Device Name	string	DESTMOBILEDEVICENAME
Original Mobile Call Duration	integer	ORIGMOBILECALLDURATION
Destination Mobile Call Duration	integer	DESTMOBILECALLDURATION
Mobile Call Type	integer	MOBILECALLTYPE
Original inal Called Party Pattern	string	ORIGINALCALLEDPARTYPATTERN
Final Called Party Pattern	string	FINALCALLEDPARTYPATTERN
Last Redirecting Party Pattern	string	LASTREDIRECTINGPARTYPATTERN
Hunt Pilot Pattern	string	HUNTPILOTPATTERN

Please select datasheet page 3COM NBX (XML, v6) 3CX AYC IPcts Aastra 470 (PC5 format) Aastra Intelligate (tab) Aastra Intelligate IP SMDR Aastra MX-ONE (ASB501 format) Aastra MX-ONE (MDFP15 format) Aastra MX-ONE Alcatel 100 model 64 phase II Alcatel 4100 Alcatel 4200 Alcatel 4300 Alcatel 4400 (FTP) Alcatel 4400 P Alcatel OmniPCX Enterprise (Ethernet Real Time) Alcatel OmniPCX Enterprise (OXE) Alcatel OmniPCX Office (OHL Driver XML) Alcatel OmniPCX Office Allworx Altigen Aristel AV38 (DD MM) Aristel AV38 Asterisk (AMI interface) Asterisk (CSV) Asterisk (Master CSV) Asterisk Fonality (CSV) AudioCodes Gateway (Extended) AudioCodes Mediant 1000 AudioCodes SBC AudioCodes VoIP Gateway Australia Mobile (CSV) Avaya (59 Chars Output Format ACM 4.0+) Avaya (Customized Output Format ACM 4.0+) Avaya (Customized Output Format ACM 6.0+) Avaya (Customized Output Format Call Center) Avaya (Enhanced Unformatted Output Format ACM 4.0+) Avaya (Expanded Output Format ACM 4.0+) Avaya (Printer Output Format ACM 4.0+) Avaya (Unformatted Output Format ACM 4.0+) Avaya (cost) Avaya ACM3 (Custom User Format) Avaya Aura S8800 (Customized Output Format ACM 6.3+) Avaya CMS (Split Feed) Avaya Communication Manager (Customized Output Format ACM 6.3+) Avaya Definity v1 Avaya G3 V12 (Unformatted ACM 3.x) Avaya G3 V12 (Unformatted Output Format) Avaya G3 V12 Avaya G3 V9 Avaya IP Office 406 (CSV) Avaya IP Office 500 (CSV) Avaya IP Office Phone (CSV) Avaya MERLIN 1030 Avaya MERLIN 3070 Avaya Merlin Magic Avaya MultiVantage (Unformatted Output Format ACM 4.0+) Avaya Partner BroadSoft BroadWorks Cadcom 3600 Cisco Call Manager (CSV) v10 Cisco Call Manager (CSV) v6 Cisco Call Manager (CSV) v7 Cisco Call Manager (CSV) v8 Cisco Call Manager Cisco Router CDR Cisco UC560 Comdial (CSV) Comdial ConversIP MP5000 Comdial DSU2 Comdial DX80 Comdial DXP (SMDR) Comdial DXP Plus (SMDA) Comdial DXP Plus (SMDR) Comdial FX Comdial MP5000 v2 Comdial DVC (Digital Voice Corp) Digium Switchvox (Event Notifications) ECI Telecom Coral III ESI (csv) ESI (tabular) ESI IVX128 ESI v2 (csv) ESI v3 (Extended Format) ESI v3 (csv) Eclipse Executone IDS Ericsson BP 250 (BiDi) Ericsson BP 250 Ericsson BP128i (Call-Hotel) Ericsson BP128i Ericsson Businessphone 250b Ericsson Businessphone 250c Ericsson Businessphone 250 Ericsson Businessphone 50-250 (CIL4HOTEL Format) Ericsson Businessphone 50-250 (Flexible CIL Format) Ericsson Businessphone 50 Ericsson MD110 (FORM2 ASB 501) Ericsson MD110 BC12 Ericsson MD110 Standard Ericsson MD110 FIAS RS232 (Micros Fidelio Interface Application over RS232) FIAS TCP (Micros Fidelio Interface Application over TCP) FreeRADIUS (Accounting Log) Fujitsu 9600 Fujitsu E650 Genbend M6 GoldStar GPS-6A Grandstream UCM6100 Grandstream UCM6200 (Real Time) Grandstream UCM6200 Grandstream UCM6500 (Real Time) Greenlite HITACHI CX-256MS HOBIC (I,II,2001) Harris 20x20M Harris 20x20 Hybrex G1-824 Hybrex GD-320 Hybrex GDS-160 Inter-Tel 5000 InterTel Axxess Iwatsu ADIX Karel MS48 Komutel Custom Format LG Aria Soho LG CS-1000 LG Ericsson IPECS MFIM50A LG GDK-100 LG GDK-162 LG GHX-1232 LG GHX-46 LG LDK-100 LG LDK-300 LG Starex VSP LG ipLDK-20 London 16 Lucent G3 MTA M-200 Matrix Eternity (Report) Matrix Eternity Meisei 100-D R3 Mitel 3000 Mitel 3300 ICP (Standard Format) Mitel 3300 ICP (Standard Full) Mitel 3300 ICP (Universal) Mitel 5000 CP Mitel 5000 Mitel CS-5000 Mitel SX 200 EL Mitel SX 2000 Mitel SX 200D Multicom (Universal) Multicom A416 Multicom A632 Multicom BS-24100 Multicom C1248 Multicom G1260 Multicom Maxicom MP80 Multicom Maxicom MXM300 Multitek 300 NCH AXON NEC (LAN Extended Format Fixed Length) NEC (LAN Flexible Format Variable Length) NEC (LAN Normal Format Fixed Length) NEC 2000 IVS Series NEC 2400 NEC Aspire (Format2,Date) NEC Aspire 300IP NEC Aspire V2 NEC Aspire NEC DS2000 NEC DSX 160 NEC DSX 80 NEC Electra Elite IPK II (no date) NEC Electra Elite IPK II NEC ElectraElite IPK (CSV) NEC ElectraElite IPK NEC Elite Series 8000 NEC NEAX2000 IPS NEC NEAX7400 ICS m100 NEC Neac 1400 NEC SL1000 NEC SL1100 NEC SV9100 (General Overseas Format) NEC SV9300 NEC Topaz NEC Univerge SV8100 (General Overseas Format) NEC Univerge SV8100 NEC XN 120 NEC Xen Axis (CSV) Nec SOPHO iS3000 (RS232, FDCR Format 4) Netas Diginet DX-1,2,3 NeutralPoint Nitsuko 124i Nitsuko 288 M2 Nitsuko 288 Nitsuko 384i Nitsuko Businesscom DS Nitsuko DX2E-32i Nitsuko Nortel CS1000 (2 rows) Nortel Meridian (1 row) Nortel Meridian (2 rows) Nortel Meridian (3 rows) Nortel Meridian (3 rows,v25) Nortel Norstar SL1 CLID Nortel Norstar SL1 Standard Nortel Norstar Standard Nortel Type 2 Onyx III Opticon IP Panasonic 576 (Caller ID) Panasonic 576 Panasonic 816 Panasonic DBS 72 CPC-A Panasonic DBS-90 Panasonic KX-HTS32 Panasonic KX-HTS824 Panasonic KX-NCP1000 Panasonic KX-NCP500 Panasonic KX-NS1000 Panasonic KX-NS300-NS500-NS700 Panasonic KX-NSX1000 Panasonic KX-NSX2000 Panasonic KX-T1232 (DD-MM-YY) Panasonic KX-T1232 Panasonic KX-T336100b Panasonic KX-T7436 Panasonic KX-TA308 Panasonic KX-TA616 Panasonic KX-TA624 Panasonic KX-TD1232 Panasonic KX-TD500 v2 (ring) Panasonic KX-TD500 v3 (cost) Panasonic KX-TD500 v4 (ring,cost) Panasonic KX-TD500 Panasonic KX-TD612 Panasonic KX-TD816 Panasonic KX-TDA100 (cost) Panasonic KX-TDA100 (ring) Panasonic KX-TDA100 (ring,ampm) Panasonic KX-TDA100 (ring,cost) Panasonic KX-TDA200 (cost) Panasonic KX-TDA200 (ring) Panasonic KX-TDA200 (ring,cost) Panasonic KX-TDA30 (cost) Panasonic KX-TDA30 (ring,cost) Panasonic KX-TDA600 (cost) Panasonic KX-TDA600 Panasonic KX-TDA Panasonic KX-TDE100 Panasonic KX-TDE200 (ring, mm.dd.yy) Panasonic KX-TDE200 (ring,cost) Panasonic KX-TEB308 (cost) Panasonic KX-TEB308 Panasonic KX-TEM824 Panasonic MU Planet IPX-2000 Quintum Tenor RADIUS (Accounting Server) Ribbon SBC (RADIUS) Rolm 9751 (ACD ANS REPORT) Rolm Redwood 9722 SPIDER Samsung DCS Compact II Samsung DCS Samsung MU Samsung NX-1232 Samsung NX-820 Samsung OfficeServ 100 Samsung OfficeServ 500 Samsung OfficeServ 7030 Samsung OfficeServ 7070 Samsung OfficeServ 7200 Samsung OfficeServ 7400 Samsung SKP-36HX Samsung SKP-56_120 Samsung SKP-816 (fixed pos) Samsung SKP-816 Samsung iDCS 100 M2 Samsung iDCS 100 Samsung iDCS 500 Selta 1000 Selta SAM Office 8 Selta Sti 100 Shoretel 6 Shoretel 7 Shoretel 9 Siemens HiPATH 1100 Siemens Hicom-118 Siemens Hicom-150 OfficeCom v2 Siemens Hicom-150 OfficeCom Siemens Hicom-250 Siemens Hicom-300E (ANI format) Siemens Hicom-300H (ANI format) Siemens Hicom-300H Siemens Hicom-350H Siemens Hipath 4000 (CDR Standard Format) Siemens Hipath 4000 (CDRE) Siemens Hipath 4000 Siemens Hipath-3350 Siemens Hipath-3500 Siemens Hipath-3550 v2 Siemens Hipath-3550 Siemens Hipath-35xx (CSV) Siemens Hipath-3700 Siemens Hipath-37xx (CSV) Siemens Hipath-37xx (Delimited by Pipe) Siemens Hipath-3800 Siemens Rolm 9751 (Compat,no ANI) Siemens Unify OpenScape Business X8 Siemens Unify Openscape 4000 (TCP) Siemens Unify Openscape 4000 Siemens Unify Openscape Office V3 Siemens iSDX Realitis Snom ONE Sonus 2000 SBC Sonus SBC (RADIUS,1000,2000) Sphere VOIP Softswitch Splicecom Maximiser TAPI data parser Tadiran Coral (1 row) Tadiran Coral (2 rows) Tadiran Coral Emerald Tadiran Coral Flexicom 400 Tadiran Coral II (2 rows) Tadiran Coral III Tadiran Coral IPX Tadiran Emerald ICE Tadiran IPX 500 (1 row) Talkswitch Tapit CSV Tekelec T6000 (CSV) Telepo 3 Telnyx CDR (CSV) Telrad v2 Telrad Tennyson SOX Toshiba IP Edge Toshiba Strata CIX Toshiba Strata CTX Toshiba Strata DK 14,40,424 Toshiba Strata DK 240,280 Toshiba Strata DK 2 Toshiba Strata DK 56 VOISpeed Vertical SBX 320 (Caller ID Name) Vodavi Starplus Vodavi XTS Welltech ePBX 100 Wypoint Yeastar (S100,S200,S300) Yeastar MyPBX Enterprise eOn Millennium v1.2 eOn Millennium

Interested in reports for PBX usage?

The PBX Reports utility that we provide includes a variety of reporting options such as manual, scheduled, and email, alongside a built-in web server and more. Implement your call accounting system for Cisco Call Manager (CSV) v10. Look here

Want PBX call logs in a database?

The standard functionality includes the logger capturing and exporting 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.