CDRs

CDRs for mobile terminated and mobile originated SMS

CDRs can be downloaded for messages submitted to the platform by customers and for messages submitted to suppliers by the platform. The date/time range, customer, supplier or customer-supplier combination can be specified for the CDRs produced.

CDRs are generated for database records that are updated within 15 seconds of message submission or message state being updated.

Download CDRs from Reports > CDRs or Reports > CDRs > Advanced. Aggregated traffic reports are documented in Reports.

Download CDRs

Use Reports > CDRs > Advanced for faster downloads and for Full CDRs. The Reports > CDRs section will be upgraded for faster performance; until then the portal recommends Advanced.

Reports > CDRsReports > CDRs > Advanced
RangeDate rangeDate and time range
Customer CDRsYes (completed, all, pending, failed)Yes (completed, all, pending, failed)
Supplier CDRsYesYes
Full CDRsNoYes

Steps

  1. Open Reports > CDRs > Advanced (or Reports > CDRs).
  2. Set the date (or date/time) range and time zone.
  3. Choose the Customer, Supplier or Full tab.
  4. Select a customer and SMPP account, a supplier and SMSC, or both (Full).
  5. Click Check. The record count is shown (customer downloads also show pending and failed counts).
  6. Click the download button for the CDR type you want. The file is a CSV named report-cdr-<timestamp>.csv.

Download is disabled when there are no matching records, or when the count is greater than 850,000. Narrow the range or filter and click Check again.

CSV files include a UTF-8 BOM so message text displays correctly in Microsoft Excel.

Customer CDRs

Download CDRs based on the customer who submitted the messages. Filter by customer and SMPP account.

The following types of CDR can be produced:

TypeDescriptionPeriod used
Completed messagesOnly messages that have reached a final state (delivered or undeliverable).ts_completion
All messagesAll messages regardless of state.ts_esme_submit
Pending messagesOnly messages that have not yet reached a final state.ts_esme_submit
Failed messagesOnly messages that have reached a failed final state (status greater than 2).ts_esme_submit

Completed downloads therefore include messages that finished in the selected range, even if they were submitted earlier. All, pending and failed downloads include messages submitted in the selected range.

CDR format:

ts_completion, svc_node, esme_msg_id, customer, system_id, ts_esme_submit, srcton, srcnpi, srcaddr, msisdn, country, network, status, error, ts_dlr_ack, revenue_val, revenue_cur, registered_delivery, data_coding, esm_class, type, short_message, short_message_raw

status, data_coding and short_message are written in human-readable form.

Supplier CDRs

Download CDRs based on the supplier to where messages were submitted. Filter by supplier and SMSC. There is a single Download button (all matching attempts in the range).

The period is the time the platform submitted the message to the supplier (ts_submit).

CDR format:

ts_submit, svc_node, esme_msg_id, smsc, system_id, ts_completion, msgid, submit_error, cost_val, cost_cur, network, status, error

Full CDRs

Available in Reports > CDRs > Advanced only.

CDRs based on the customer who submitted messages and the suppliers to where messages were onward submitted by the platform. Filter by customer, SMPP account, supplier and SMSC. There is a single Download button.

CDR format:

ts_completion, svc_node, esme_msg_id, customer, system_id, ts_esme_submit, srcton, srcnpi, srcaddr, msisdn, country, network, status, error, ts_dlr_ack, revenue_val, revenue_cur, registered_delivery, data_coding, esm_class, type, short_message, short_message_raw, ts_submit, smsc, smsc_system_id, msgid, submit_error, cost_val, cost_cur

CDR fields

FieldDescription
ts_completionTimestamp for when the message reached a final state (delivered or undeliverable)
svc_nodeSSG node to where the message was submitted by the customer
esme_msg_idID of the message on the SSG node (<node hex>-<message hex>)
customerCustomer name
system_idSMPP system ID used by the customer to submit the message
ts_esme_submitTimestamp for when the customer submitted the message to the platform
srctonSource address TON
srcnpiSource address NPI
srcaddrSource address
msisdnDestination address
countryCountry of the destination address
networkNetwork of the destination address
statusDelivery status (see below)
errorDelivery error (normally as returned by the supplier SMSC)
ts_dlr_ackTimestamp for when the customer acknowledged the DLR
revenue_valPrice value of the message from the pricing plan
revenue_curPrice currency of the message from the pricing plan
registered_deliveryRegistered delivery value as set by the customer when the message was submitted
data_codingData coding (see below)
esm_classESM class value as set by the customer when the message was submitted
typeMT (outbound) or MO (inbound)
short_messageShort message in text form (UDH skipped; UCS2 decoded to UTF-8)
short_message_rawOriginal short-message field (hex)
ts_submitTimestamp for when the platform submitted the message to the supplier
smscIdentifier for the supplier SMSC to where the message was submitted
smsc_system_idSMPP system ID used with the supplier SMSC
msgidMessage ID returned by the supplier SMSC
submit_errorSMPP command status returned by the supplier SMSC in submit_sm_resp
cost_valCost value of the message from supplier costs
cost_curCost currency of the message from supplier costs

Status values

status is exported as SMPP-style text:

ValueMeaning
ENROUTEPending (scheduled or enroute)
DELIVRDDelivered
EXPIREDExpired
DELETEDCancelled
UNDELIVUndeliverable
ACCEPTDAccepted
UNKNOWNUnknown
REJECTDRejected
SKIPPEDSkipped

Data coding values

ValueMeaning
MC DefaultDCS 0
IA5/ASCIIDCS 1
Octet (8-bit)DCS 2 or 4
Latin 1 (ISO-8859-1)DCS 3
JISDCS 5
Cyrillic (ISO-8859-5)DCS 6
Latin/Hebrew (ISO-8859-8)DCS 7
UCS2DCS 8

Limits and API

Individual message records used for CDRs are retained for the last 3 months by default. See Data retention.

A portal download is limited to 850,000 records. For larger volumes, or to retrieve CDRs automatically, use the Management API:


Did this page help you?