Retrieving Call Detail Records (CDR) from the RADIUS accounting server is relatively straight forward. Call Detail Records are stored on the RADIUS server in plain text in a directory named with the IP Address of the client SBC system.
Each file in the directory represents one 24-hour period and is named for the date of the day it represents. Example: Filenames = detail-YYYYMMDD. The path for any particular CDR file is: /usr/local/var/log/radius/radacct/<client-ip-address>/detail-YYYYMMDD
The following is an example of a typical Call Detail Record.
Tue Nov 22 15:20:33 2011 NET-Log-Time = "Tue Nov 22 15:20:31 2011\n" Acct-Status-Type = Start NET-Session-Ingress-CallId = 0 NET-Session-Egress-CallId = 65535 NET-Session-Generic-Id = 14 Acct-Multi-Session-Id = "132200403114" NET-Ingress-Signaling-Group = 19992 NET-Egress-Signaling-Group = 0 NET-Ingress-Channel-Number = 23 NET-Egress-Channel-Number = 0 NET-Call-Origin = 1 NET-Calling-Number = "1029" NET-Called-Number = "2006" NET-Calling-Name = "System Test" NET-Ingress-Channel-Id = "1:1:23" NET-Setup-Time = "1322004031" Acct-Session-Id = "0" NET-Firmware-Version = "2.0.0v107" NET-Local-Time-Zone = "PST8PDT" NET-Gw-Id = "f5a4fdc8f970ae35addf36" NET-Time-And-Day = "1322004031" NAS-Port = 1813 Acct-Delay-Time = 0 NAS-IP-Address = 134.56.227.230 Acct-Unique-Session-Id = "df05da217dbe16e4" Timestamp = 1322004033 Request-Authenticator = Verified
Tue Nov 22 15:20:33 2011 NET-Log-Time = "Tue Nov 22 15:20:31 2011\n" Acct-Status-Type = Start NET-Session-Ingress-CallId = 65535 NET-Session-Egress-CallId = 1 NET-Session-Generic-Id = 14 Acct-Multi-Session-Id = "132200403114" NET-Ingress-Signaling-Group = 0 NET-Egress-Signaling-Group = 5 NET-Ingress-Channel-Number = 0 NET-Egress-Channel-Number = 1 NET-Call-Origin = 2 NET-Calling-Number = "1029" NET-Called-Number = "2006" NET-Calling-Name = "System Test" NET-Egress-Channel-Id = "0:5:1" NET-Setup-Time = "1322004031" Acct-Session-Id = "1" NET-Firmware-Version = "2.0.0v107" NET-Local-Time-Zone = "PST8PDT" NET-Gw-Id = "f5a4fdc8f970ae35addf36" NET-Time-And-Day = "1322004031" NAS-Port = 1813 Acct-Delay-Time = 0 NAS-IP-Address = 134.56.227.230 Acct-Unique-Session-Id = "cb61066babf7983e" Timestamp = 1322004033 Request-Authenticator = Verified
Tue Nov 22 15:20:57 2011 NET-Log-Time = "Tue Nov 22 15:20:55 2011\n" Acct-Status-Type = Stop NET-Session-Ingress-CallId = 65535 NET-Session-Egress-CallId = 1 NET-Session-Generic-Id = 14 Acct-Multi-Session-Id = "132200403114" NET-Ingress-Signaling-Group = 0 NET-Egress-Signaling-Group = 5 NET-Ingress-Channel-Number = 0 NET-Egress-Channel-Number = 1 NET-Call-Origin = 2 NET-Call-Type = 1 NET-Routing-Table-Number = 0 NET-Primary-Routing-Number = "2006" NET-Disconnect-Cause = 16 NET-Abort-Cause = 0 Acct-Terminate-Cause = User-Request NET-Calling-Number = "1029" NET-Called-Number = "2006" NET-Calling-Name = "System Test" NET-Egress-Channel-Id = "0:5:1" Acct-Output-Packets = 228 Acct-Output-Octets = 36321 Acct-Input-Packets = 1159 Acct-Input-Octets = 185440 NET-Fwd-Flow-In-Src-Addr = "134.56.227.230" NET-Bwd-Flow-Out-Dst-Addr = "134.56.227.230" NET-Fwd-Flow-Out-Dst-Addr = "134.56.225.90" NET-Bwd-Flow-In-Src-Addr = "134.56.225.90" NET-Fwd-Flow-In-Dst-Addr = "134.56.227.230" NET-Fwd-Flow-Out-Src-Addr = "134.56.227.230" NET-Bwd-Flow-In-Dst-Addr = "134.56.227.230" NET-Bwd-Flow-Out-Src-Addr = "134.56.227.230" NET-Fwd-Flow-Out-Src-Port = 16428 NET-Bwd-Flow-In-Dst-Port = 2232 NET-Fwd-Flow-Media-Type = "3" NET-Fwd-Flow-PTime = 20 NET-Bwd-RTP-Avg-Latency = 0 NET-Bwd-RTP-MaxLatency = 0 NET-Fwd-RTP-Avg-Jitter = 0 NET-Bwd-RTP-MaxJitter = 0 NET-Bwd-RTP-Packets-Lost = 0 NET-Bwd-Octets = 185440 NET-Fwd-Flow-Out-Dst-Port = 2232 NET-Bwd-Packets = 1159 NET-Setup-Time = "1322004031" Acct-Session-Id = "1" Acct-Session-Time = 23 NET-Alert-Time = "1322004031" NET-Connect-Time = "1322004032" NET-Disconnect-Time = "1322004055" NET-Call-Duration = 23 NET-Disconnect-Initiator = 1 NET-Outbound-Seize-Time = "1322004031" NET-Post-Dial-Delay = 119091 NET-Egress-Local-Addr = "134.56.227.230" NET-Egress-Remote-Addr = "134.56.225.90" NET-Ingress-Net-Interface-Id = 775159856 NET-Egress-Net-Interface-Id = 775159858 NET-Ingress-Signaling-Port-Num = 5060 NET-Egress-Signaling-Port-Num = 5060 NET-Transport-Type = 2 NET-Firmware-Version = "2.0.0v107" NET-Local-Time-Zone = "PST8PDT" NET-Gw-Id = "f5a4fdc8f970ae35addf36" NET-Time-And-Day = "1322004055" NAS-Port = 1813 Acct-Delay-Time = 0 NAS-IP-Address = 134.56.227.230 Acct-Unique-Session-Id = "cb61066babf7983e" Timestamp = 1322004057 Request-Authenticator = Verified
Tue Nov 22 15:20:57 2011 NET-Log-Time = "Tue Nov 22 15:20:55 2011\n" Acct-Status-Type = Stop NET-Session-Ingress-CallId = 0 NET-Session-Egress-CallId = 65535 NET-Session-Generic-Id = 14 Acct-Multi-Session-Id = "132200403114" NET-Ingress-Signaling-Group = 19992 NET-Egress-Signaling-Group = 0 NET-Ingress-Channel-Number = 23 NET-Egress-Channel-Number = 0 NET-Call-Origin = 1 NET-Call-Type = 1 NET-Routing-Table-Number = 1 NET-Primary-Routing-Number = "2006" NET-Disconnect-Cause = 16 NET-Abort-Cause = 0 Acct-Terminate-Cause = User-Request NET-Egress-Final-Routing-Num = "2006" NET-Calling-Number = "1029" NET-Called-Number = "2006" NET-Calling-Name = "System Test" NET-Ingress-Channel-Id = "1:1:23" NET-Call-Number-Type = "0" NET-Call-Plan = "5" NET-Original-Called-Type = "-1" NET-Original-Called-Plan = "-1" NET-Namespace = "-3" NET-Precedence = "-1" NET-Presentation = "0" NET-Screening = "0" NET-Transfer-Capability = "0" NET-Transfer-Mode = "0" NET-Transfer-Rate = "1" NET-User-Rate = "20" NET-Setup-Time = "1322004031" Acct-Session-Id = "0" Acct-Session-Time = 23 NET-Inbound-Seize-Time = "1322004031" NET-Alert-Time = "1322004031" NET-Connect-Time = "1322004032" NET-Disconnect-Time = "1322004055" NET-Call-Duration = 23 NET-Disconnect-Initiator = 0 NET-Post-Dial-Delay = 2124 NET-Firmware-Version = "2.0.0v107" NET-Local-Time-Zone = "PST8PDT" NET-Gw-Id = "f5a4fdc8f970ae35addf36" NET-Time-And-Day = "1322004055" NAS-Port = 1813 Acct-Delay-Time = 0 NAS-IP-Address = 134.56.227.230 Acct-Unique-Session-Id = "df05da217dbe16e4" Timestamp = 1322004057 Request-Authenticator = Verified