SMDR, CDR data captured by Advanced PBX Data Logger from Cisco Call Manager (CSV)

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

Description	Data type	Column name
Trunk	integer	TRUNK
Extension	integer	EXT
Authorization code	integer	FLAG1
Gglobal CallID CallManagerId	integer	GLOBALCALLID_CALLMANAGERID
Global CallID	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 MediaCap Payload Capability	integer	ORIGMEDIACAP_PAYLOADCAPABILITY
Original MediaCap Max Frames Per Packet	integer	ORIGMEDIACAP_MAXFRAMESPERPACKET
Original MediaCap G723 Bitrate	integer	ORIGMEDIACAP_G723BITRATE
Original VideoCap Codec	integer	ORIGVIDEOCAP_CODEC
Original VideoCap Bandwidth	integer	ORIGVIDEOCAP_BANDWIDTH
Original VideoCap 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 User ID	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 MediaCap Payload Capability	integer	DESTMEDIACAP_PAYLOADCAPABILITY
Destination MediaCap Max Frames Per Packet	integer	DESTMEDIACAP_MAXFRAMESPERPACKET
Destination MediaCap G723 Bitrate	integer	DESTMEDIACAP_G723BITRATE
Destination VideoCap Codec	integer	DESTVIDEOCAP_CODEC
Destination VideoCap Bandwidth	integer	DESTVIDEOCAP_BANDWIDTH
Destination VideoCap 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
Connect date time	integer	DATETIMECONNECT
Disconnect date time	integer	DATETIMEDISCONNECT
Last redirect	string	LASTREDIRECTDN
Packet ID	string	PKID
Original Called Party Number Partition	string	ORIGINALCALLEDPARTYNUMBERPARTITION
Calling Party Number Partition	string	CALLINGPARTYNUMBERPARTITION
Final Called Party Number Partition	string	FINALCALLEDPARTYNUMBERPARTITION
Last Redirect 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 Reason	integer	LASTREDIRECTREDIRECTREASON
Destination Conversation ID	integer	DESTCONVERSATIONID
Global CallId Cluster ID	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 MediaCap Bandwidth	integer	ORIGMEDIACAP_BANDWIDTH
Destination MediaCap Bandwidth	integer	DESTMEDIACAP_BANDWIDTH
Authorization Code Value	string	AUTHORIZATIONCODEVALUE
Outpulsed Calling Party Number	string	OUTPULSEDCALLINGPARTYNUMBER
Outpulsed Called Party Number	string	OUTPULSEDCALLEDPARTYNUMBER
Original IPv4v6 Addr	string	ORIGIPV4V6ADDR
Destination IPv4v6 Addr	string	DESTIPV4V6ADDR
Original VideoCap Codec Channel2	integer	ORIGVIDEOCAP_CODEC_CHANNEL2
Original VideoCap Bandwidth Channel2	integer	ORIGVIDEOCAP_BANDWIDTH_CHANNEL2
Original VideoCap 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 VideoChannel_Role_Channel2	integer	ORIGVIDEOCHANNEL_ROLE_CHANNEL2
Destination VideoCap Codec Channel2	integer	DESTVIDEOCAP_CODEC_CHANNEL2
Destination VideoCap Bandwidth Channel2	integer	DESTVIDEOCAP_BANDWIDTH_CHANNEL2
Destination VideoCap 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
Call time	datetime	CALL_TIME
Call duration	datetime	CALL_DURATION
Direction	string	DIRECTION
Call type	string	CALL_TYPE
Caller phone	string	CALLER_PHONE
Dialed phone	string	DIALED_PHONE

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

Please, select datasheet page 3COM NBX (XML, v6) AYC IPcts Aastra Intelligate (tab) Aastra MX-ONE Alcatel 100 model 64 phase II Alcatel 4100 Alcatel 4200 Alcatel 4300 Alcatel 4400 P Alcatel OmniPCX Enterprise (OXE) Alcatel OmniPCX Office Allworx Altigen Aristel AV38 (DD MM) Aristel AV38 Asterisk Fonality (CSV) Australia Mobile (CSV) Avaya (59 Chars Output Format ACM 4.0+) 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 Definity v1 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 Cadcom 3600 Cisco Call Manager v6 (CSV) Cisco Call Manager v7 (CSV) Cisco Call Manager v8 (CSV) Cisco Call Manager 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) ECI Telecom Coral III ESI (csv) ESI (tabular) ESI IVX128 ESI v2 (csv) 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 Ericsson MD110 BC12 Ericsson MD110 Standard Ericsson MD110 Fujitsu 9600 Fujitsu E650 Genbend M6 GoldStar GPS-6A Greenlite HITACHI CX-256MS Harris 20x20M Harris 20x20 Hybrex GD-320 Hybrex GDS-160 Inter-Tel 5000 InterTel Axxess Iwatsu ADIX Karel MS48 LG Aria Soho LG CS-1000 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 Meisei 100-D R3 Mitel 3300 ICP (Standard Format) Mitel 3300 ICP (Standard Full) Mitel 3300 ICP (full time) Mitel 3300 ICP Mitel 5000 Mitel CS-5000 Mitel SX 200 EL Mitel SX 2000 Mitel SX 200D Mitel Multicom (Universal) Multicom A416 Multicom A632 Multicom BS-24100 Multicom C1248 Multicom G1260 Multicom Maxicom MP80 Multicom Maxicom MXM300 Multitek 300 NCH AXON NEC 2000 IVS Series NEC 2400 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 NEAX 2000 (IP) NEC NEAX2000 IPS NEC NEAX7400 ICS m100 NEC Neac 1400 NEC Univerge SV8100 NEC XN 120 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 (2 rows) Nortel Meridian (3 rows) 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-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 v2 (cost) Panasonic KX-TDA600 Panasonic KX-TDE-200 (ring,cost) Panasonic KX-TDE200 (ring, mm.dd.yy) Panasonic KX-TEB308 (cost) Panasonic KX-TEB308 Panasonic KX-TEM824 Panasonic MU Planet IPX-2000 Quintum Tenor 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 7200 Samsung SKP-36HX Samsung SKP-56_120 Samsung SKP-816H (fixed pos) Samsung SKP-816 Samsung iDCS 100 M2 Samsung iDCS 100 Samsung iDCS 500 Selta SAMoffice 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 (CDRE) Siemens Hipath 4000 Siemens Hipath-3350 Siemens Hipath-3500 Siemens Hipath-3550 (DDMMYY) Siemens Hipath-35xx (CSV) Siemens Hipath-35xx (CSV,MMDDYY) Siemens Hipath-3700 (MMDDYY) Siemens Hipath-3700 Siemens Hipath-37xx (CSV, DDMMYY) Siemens Hipath-37xx (CSV, MMDDYY) Siemens Hipath-37xx (Delimited, DDMMYY) Siemens Hipath-3800 Siemens iSDX Realitis Sphere VOIP Softswitch Tadiran Coral (1 row) Tadiran Coral (2 rows) Tadiran Coral Emerald Tadiran Coral Flexicom 400 Tadiran Coral III Tadiran Coral IPX Tadiran IPX 500 (1 row) Talkswitch Tapit CSV Tekelec T6000 (CSV) Telrad v2 Telrad Tennyson SOX 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 Vodavi Starplus Vodavi XTS Welltech ePBX 100 Wypoint eOn Millennium v1.2 eOn Millennium

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.