File Naming and Location
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
Call Detail Record Format
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
Overview
Content Tools