Hi Ruben,
Please take a llok on this:
http://www.cisco.com/en/US/docs/ios/voice/cdr/developer/guide/cdrcsv.html
You'll find all the available values that CDR File Accounting can generate:
No. | Field Name | Type | Description | |||
|---|---|---|---|---|---|---|
0 | unix_time | Long | System time stamp when CDR is captured. | |||
1 | call-id | Long | Value of the Call-ID header. | |||
2 | cdr-type | Long | Template used: 0=None | |||
3 | leg-type | Long | Call leg type: 1= Telephony | |||
4 | h323-conf-id | String | Unique call identifier generated by the gateway. Used to identify the separate billable events (calls) within a single calling session. | |||
5 | peer-address | String | Number that this call was connected to in E.164 format. | |||
6 | peer-sub-address | String | Subaddress configured under a dial peer. | |||
7 | h323-setup-time | String | Setup time in Network Time Protocol (NTP) format: hour, minutes, seconds, microseconds, time_zone, day, month, day_of_month, year. | |||
8 | alert-time | String | Time at which call is alerting. | |||
9 | h323-connect-time | String | Connect time in NTP format: hour, minutes, seconds, microseconds, time_zone, day, month, day_of_month, year. | |||
10 | h323-disconnect-time | String | Disconnect time in NTP format: hour, minutes, seconds, microseconds, time_zone, day, month, day_of_month, year. | |||
11 | h323-disconnect-cause | String | Q.931 disconnect cause code retrieved from Cisco IOS call-control application programming interface (Cisco IOS CCAPI). | |||
12 | disconnect-text | String | ASCII text describing the reason for call termination. | |||
13 | h323-call-origin | String | Gateway's behavior in relation to the connection that is active for this leg. | |||
14 | charged-units | Long | Number of charged units for this connection. For incoming calls or if charging information is not supplied by the switch, the value is zero. | |||
15 | info-type | String | Type of information carried by media. 1=Other 9 not described | |||
16 | paks-out | Long | Total number of transmitted packets. | |||
17 | bytes-out | Long | Total number of transmitted bytes. | |||
18 | paks-in | Long | Total number of packets received. | |||
19 | bytes-in | Long | Total number of bytes received. | |||
20 | username | String | Username for authentication. Usually this is the same as the calling number. | |||
21 | clid | String | Calling number. | |||
22 | dnis | String | Called number. | |||
23 | gtd-orig-cic | String | Originating carrier identification code, used in routing to identify the network. | |||
24 | gtd-term-cic | String | Terminating carrier identification code. | |||
25 | tx-duration | String | Duration, in ms, of transmit path open from this peer to the voice gateway for the call. | |||
26 | peer-id | Long | ID value of the peer table entry to which this call was made. If a peer table entry for this call does not exist, the value of this object is zero. | |||
27 | peer-if-index | Long | ifIndex value of the peer table entry to which this call was made. If a peer table entry for this call does not exist, the value of this object is zero. | |||
28 | logical-if-index | Long | ifIndex value of the logical interface through which this call was made. For ISDN media, this is the ifIndex of the B channel that was used for this call. | |||
29 | acom-level | Long | Average ACOM level, in dB, for the call (ACOM is the combined loss achieved by the echo canceler). 1 indicates that the level cannot be determined or level detection is disabled. | |||
30 | noise-level | Long | Average noise level for the call, in dBm. | |||
31 | voice-tx-duration | String | Duration, in ms, for this call. | |||
32 | account-code | String | Account code entered using the Acct soft key during call setup or when connected to an active call. | |||
33 | codec-bytes | Long | Payload size of the voice packet. | |||
34 | codec-type-rate | String | Negotiated coder rate. Transmit rate of voice/fax compression to its associated call leg for the call. | |||
35 | ontime-rv-playout | Long | Duration, in ms, of voice playout from data received on time for this call. | |||
36 | remote-udp-port | Long | Remote system UDP listener port to which voice packets are transmitted. | |||
37 | remote-media-udp-port | Long | Remote-media gateway UDP port. | |||
38 | vad-enable | String | Whether or not voice-activity detection (VAD) is enabled for the voice call. | |||
39 | receive-delay | String | Average playout FIFO delay plus the decoder delay during the voice call. | |||
40 | round-trip-delay | String | Voice-packet round-trip delay, in ms, between local and remote devices on the IP backbone during a call. | |||
41 | hiwater-playout-delay | String | High-water mark voice playout FIFO delay during the voice call. | |||
42 | lowater-playout-delay | String | Low-water mark voice playout FIFO delay during the voice call. | |||
43 | gapfill-with-interpolation | String | Duration, in ms, of the voice signal played out with the signal synthesized from parameters or samples of data preceding and following in time because of voice data not received on time (or lost) from the voice gateway for this call. | |||
44 | gapfill-with-redundancy | String | Duration, in ms, of the voice signal played out with signal synthesized from redundancy parameters available because of voice data not received on time (or lost) from the voice gateway for this call. | |||
45 | gapfill-with-silence | String | Duration, in ms, of the voice signal replaced with the signal played out during silence because of voice data not received on time (or lost) from the voice gateway for this call | |||
46 | gapfill-with-prediction | String | Duration, in ms, of voice signal played out with signal synthesized from parameters or samples of data preceding in time because of voice data not received on time (or lost) from voice gateway for this call. | |||
47 | early-packets | Long | Number of received voice packets that arrived too early to store in the jitter buffer during the call. | |||
48 | late-packets | Long | Number of received voice packets that arrived too late to play out with the codec during the call. | |||
49 | lost-packets | Long | Number of lost voice packets during the call. | |||
50 | max-bitrate | Long | Maximum bandwidth used by the video call. | |||
51 | faxrelay-start-time | String | Fax start time in a call. Multiple fax start/stop time stamps can exist in one call. Recorded for both VoIP and telephony call legs. | |||
52 | faxrelay-stop-time | String | Fax stop time in a call. Multiple fax start/stop time stamps can exist in one call. Recorded for both VoIP and telephony call legs. | |||
53 | faxrelay-max-jit-buf-depth | String | Depth of the jitter buffer, in ms. | |||
54 | faxrelay-jit-buf-ovflow | String | Number of jitter buffer overflow events during the call. | |||
55 | faxrelay-init-hs-mod | String | Initial high-speed modulation and baud rate negotiated at the time the call is connected. | |||
56 | faxrelay-mr-hs-mod | String | Most recent high-speed modulation and baud rate. | |||
57 | faxrelay-num-pages | String | Total number of transmitted and received fax pages. | |||
58 | faxrelay-tx-packets | String | Number of packets transmitted. | |||
59 | faxrelay-rx-packets | String | Number of packets received. | |||
60 | faxrelay-direction | String | Whether a fax was originated (transmitted) or terminated (received) by this gateway. | |||
61 | faxrelay-pkt-conceal | String | Packet loss concealment; number of white scan lines inserted (nonzero for outbound gateway only). | |||
62 | faxrelay-ecm-status | String | Whether error correction mode is enabled. | |||
63 | faxrelay-encap-protocol | String | Encapsulation protocol used for fax transfer. | |||
64 | faxrelay-nsf-country-code | String | NSF country code of the local fax device; country name per T.35, Annex A. | |||
65 | faxrelay-nsf-manuf-code | String | NSF manufacturer code of the local fax device. | |||
66 | faxrelay-fax-success | String | Whether fax transfer was successful, the transfer failed, or indeterminate. | |||
67 | override-session-time | Long | Override session time. | |||
68 | h323-ivr-out | String | AV pairs sent from the voice gateway to the RADIUS server that you can define. You can set (write) the value with a customized Tcl IVR script. | |||
69 | internal-error-code | String | Cause of failed calls. For more information, see the "Internal Error Codes" section on page 91. | |||
70 | h323-voice-quality | String | Value representing impairment/calculated planning impairment factor (ICPIF) of the voice quality on the connection provided by lower-layer drivers (such as the digital-signal-processor). Low numbers represent better quality. | |||
71 | remote-media-address | String | Remote-media gateway IP address. | |||
72 | remote-media-id | Long | Remote-media gateway DNS name. | |||
73 | carrier-id | Long | ISUP carrier ID. | |||
74 | calling-party-category | String | Best-fit calling party category value extracted from the Generic Transparency Descriptor (GTD). Sent in start and stop accounting messages for call legs 1 and 4. Optionally, this field also contains: • • | |||
75 | originating-line-info | Long | Sent in start and stop accounting messages for call legs 1 and 4. | |||
76 | charge-number | String | Charge number used for call. | |||
77 | transmission-medium-req | Long | Sent in start and stop accounting records for call legs 1 and 4. | |||
78 | service-descriptor | String | Gatekeeper-related. | |||
79 | outgoing-area | String | Gatekeeper identifier, or the destination zone or area, of the outgoing VoIP call. | |||
80 | incoming-area | String | Gatekeeper identifier, or the source zone or area, of the incoming VoIP call. | |||
81 | out-trunkgroup-label | String | Trunk-group label associated with the group of voice ports from which the outgoing TDM call leaves the gateway. | |||
82 | out-carrier-id | String | Carrier ID of the trunk group through which the call leaves the gateway or the partnering voice services provider identifier of the outgoing VoIP call. | |||
83 | dsp-id | String | DSP ID used for the current call. | |||
84 | in-trunkgroup-label | String | Trunk group label associated with the group of voice ports from which the incoming TDM call arrived on the gateway. | |||
85 | in-carrier-id | String | Carrier ID of the trunk group through which the call arrived or the partnering voice service provider identifier of the incoming VoIP call. | |||
86 | cust-biz-grp-id | String | SIP business group ID. | |||
87 | supp-svc-xfer-by | String | Transferor information in the REFER/BYE/ALSO of SIP call. Used only in SIP call transfer. | |||
88 | voice-feature | String | Type of feature: BXFER = Blind transfer | |||
89 | feature-operation | String | Feature operation. | |||
90 | feature-op-status | String | Success (0) or failure (1). | |||
91 | feature-op-time | String | Feature operation time. Time stamp of the operation start and stop time, if applicable for a given feature. | |||
92 | feature-id | String | Feature ID of the invocation. Identifies a unique instance of a feature attribute within a gateway. This number is incremented for each added feature attribute. | |||
93 | gw-rxd-cdn | String | Called number received in the incoming signaling message before any translation rules are applied. | |||
94 | gw-rxd-cgn | String | Calling number received in the incoming signaling message before any translation rules are applied. | |||
95 | gtd-gw-rxd-ocn | String | Original calling number received by the gateway. | |||
96 | gtd-gw-rxd-cnn | String | GTD connected number. | |||
97 | gw-rxd-rdn | String | Redirection number received by the gateway. | |||
98 | gw-final-xlated-cdn | String | Called number to be sent out of the gateway. | |||
99 | gw-final-xlated-cgn | String | Calling number to be sent out of the gateway. | |||
100 | gw-final-xlated-rdn | String | Final translated received number. | |||
101 | gk-xlated-cdn | String | Called number presented by the gatekeeper in the ACF RAS message. GK/GKTMP could modify the called number by appending a prefix or leave it unchanged. | |||
102 | gk-xlated-cgn | String | Calling number presented by the gatekeeper in the ACF RAS message. The GK/GKTMP could modify the calling number which is carried in the ACF nonstandard parameter. | |||
103 | gw-collected-cdn | String | Destination number collected by the gateway (application) that is used to route the call. Only applicable for 2-stage calls. | |||
104 | ip-hop | String | Maximum number of hops in the SIP invite message. | |||
105 | redirected-station | String | Redirecting number extracted from the redirect number parameter. Sent in start accounting messages for all call legs. noa=Nature of address | |||
106 | subscriber | String | T1/channel associated signaling (CAS) or E1/R2 signal information about a subscriber. | |||
107 | in-intrfc-desc | String | Description assigned to the voice port of the incoming call. | |||
108 | out-intrfc-desc | String | Description assigned to the voice port of the outgoing call. | |||
109 | session-protocol | String | Session protocol used for calls between the local and remote router through the IP backbone. Always equal to "sip" for SIP or "Cisco" for H.323. | |||
110 | local-hostname | String | Local hostname that would be accessed or used by the SNMP MIBs. | |||
111 | backward-call-id | String | Sent in stop accounting messages for call legs 1 and 4. Also included in interim-update packets. | |||
112 | feature-id_field1 | String | Feature name. Two-Way Call (TWC), Call Forward All (CFA), Call Forward Busy (CFBY), Call Forward No Answer (CFNA), Blind Transfer (BXFER), Consultive Transfer (CXFER), Hold (HOLD), Resume (RESUME). | |||
113 | feature-id_field2 | String | Feature invocation time. | |||
TWC | CFA, CFNA, CFBY | BXFER, CXFER | HOLD/RESUME | |||
114 | feature-id_field3 | String | calling number | feature status (frs) | frs | frs |
115 | feature-id_field4 | String | called number | feature ID (fid) | fid | fid |
116 | feature-id_field5 | String | frs | fcid | fcid | fcid |
117 | feature-id_field6 | String | fid | legID | XconsID | legID |
118 | feature-id_field7 | String | fcid | frson | legID | hrson |
119 | feature-id_field8 | String | legID | fdcnt | frson | holding |
120 | feature-id_field9 | String | Not used | fwder | xsts | held |
121 | feature-id_field10 | String | Not used | fwdee | Xor | sl |
122 | feature-id_field11 | String | Not used | fwdto | Xee | usr |
123 | feature-id_field12 | String | Not used | frm | Xto | tag |
3-character country code representing the country variant extracted from the GTD Protocol Name (PRN) country field. HTH
--
Jorge Armijo
