Skip to end of metadata
Go to start of metadata

Search Billing Records:

On this page:

Viewing Billing Records 

As calls traverse the SBC, Call Detail Records (CDRs) are generated and stored in /var/log/sonus/evlog/evlog directory. You can view these CDR by looking at files with the “.ACT” extension. It is useful to view these ACT logs during call debugging (to get the originating trunk group, calling and called numbers, codec used, etc.).

You may also view billing records (and other logs) from the Platform Manager. See Using Platform Manager for more information.

When downloading billing records (or other logs), you must use port 2024 to SFTP files off of the SBC.

How to Set Up SFTP from SBC to a CDR Server

  1. To create the CDR server, use the following command syntax:

    % set oam accounting cdrServer admin [primary | secondary] connectionTimeout <numeric: 15 to 600 seconds> filePrefix <name of SBC> ipAddress <ip address> password <password for ftp user> path <directory to ftp to> transferTimeout <numeric: 15 to 600 seconds> username <username of ftp user>

    An example to show the CDR server configuration and check the configuration is as follows:

    admin@SBC01> config
    admin@SBC01% set oam accounting cdrServer admin primary connectionTimeout 15 filePrefix SBC01 ipAddress 10.10.211.10 password sonus path /export/home/SBC01ACTrecs/ transferTimeout 15 username root
    admin@SBC01% commit
    admin@SBC01% quit
    
    admin@SBC01> show table oam accounting cdrServer admin
                                                                                    FILE    CONNECTION  TRANSFER
    TYPE     IP ADDRESS    USERNAME  PASSWORD         PATH                          PREFIX  TIMEOUT     TIMEOUT
    --------------------------------------------------------------------------------------------------------------
    primary  10.10.211.10  root      $3$qaO71mBy8l8=  /export/home/SBC01ACTrecs/  SBC01   15          15
    [ok][2013-10-02 06:14:49]
    admin@SBC01>
  2. Initially, the accounting field is not set to ftp or automatically roll over. Use the following command to view Rollover setting for accounting (See "acct" row in the example):

    admin@SBC01> show table oam eventLog typeAdmin
                                     MESSAGE                                                                        FILE                SYSLOG   SYSLOG    SYSLOG  RENAME
                       FILE   FILE   QUEUE    SAVE  FILTER  ROLLOVER START       ROLLOVER                 ROLLOVER  WRITE     SYSLOG    REMOTE   REMOTE    REMOTE  OPEN
    TYPE      STATE    COUNT  SIZE   SIZE     TO    LEVEL   TIME                 INTERVAL  ROLLOVER TYPE  ACTION    MODE      STATE     HOST     PROTOCOL  PORT    FILES
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    system    enabled  16     16000  32       disk  info    -                    0         nonrepetitive  stop      default   disabled  0.0.0.0  tcp       514     disabled
    debug     enabled  16     16000  32       disk  info    -                    0         nonrepetitive  stop      default   disabled  0.0.0.0  tcp       514     disabled
    trace     enabled  16     16000  32       disk  info    -                    0         nonrepetitive  stop      default   disabled  0.0.0.0  tcp       514     disabled
    acct      enabled  16     64000  32       disk  info    -                    0         nonrepetitive  stop      optimize  disabled  0.0.0.0  tcp       514     disabled
    security  enabled  16     16000  32       disk  major   -                    0         nonrepetitive  stop      default   disabled  0.0.0.0  tcp       514     disabled
    audit     enabled  32     2048   10       disk  info    -                    0         nonrepetitive  stop      default   disabled  0.0.0.0  tcp       514     disabled
    packet    enabled  32     2048   10       disk  major   -                    0         nonrepetitive  stop      default   disabled  0.0.0.0  tcp       514     disabled
    [ok][2013-10-02 06:41:58]
  3. To create the accounting file rollover and ftp, use the following command syntax, where 'T' in 'DDTHH' is a constant used to indicate the Time follows.

    % set oam eventLog typeAdmin acct rolloverStartTime <CCYY-MM-DDTHH:MM:SS> rolloverInterval <number of seconds between each file rollover> rolloverType repetitive rolloverAction start
    

    An example of the configuration and display of the accounting file rollover and ftp is as follows:

    admin@SBC01% set oam eventLog typeAdmin acct rolloverStartTime 2013-10-02T06:30:00 rolloverInterval 900 rolloverType repetitive rolloverAction start
    [ok][2013-10-02 06:41:25]
    [edit]
    admin@SBC01% commit
    Commit complete.
    [ok][2013-10-02 06:41:28]
    [edit]
    admin@SBC01% quit
    admin@SBC01> show table oam eventLog typeAdmin
                                     MESSAGE                                                                        FILE                SYSLOG   SYSLOG    SYSLOG  RENAME
                       FILE   FILE   QUEUE    SAVE  FILTER  ROLLOVER START       ROLLOVER                 ROLLOVER  WRITE     SYSLOG    REMOTE   REMOTE    REMOTE  OPEN
    TYPE      STATE    COUNT  SIZE   SIZE     TO    LEVEL   TIME                 INTERVAL  ROLLOVER TYPE  ACTION    MODE      STATE     HOST     PROTOCOL  PORT    FILES
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    system    enabled  16     16000  32       disk  info    -                    0         nonrepetitive  stop      default   disabled  0.0.0.0  tcp       514     disabled
    debug     enabled  16     16000  32       disk  info    -                    0         nonrepetitive  stop      default   disabled  0.0.0.0  tcp       514     disabled
    trace     enabled  16     16000  32       disk  info    -                    0         nonrepetitive  stop      default   disabled  0.0.0.0  tcp       514     disabled
    acct      enabled  16     64000  32       disk  info    2013-10-02T06:30:00  900       repetitive     start     optimize  disabled  0.0.0.0  tcp       514     disabled
    security  enabled  16     16000  32       disk  major   -                    0         nonrepetitive  stop      default   disabled  0.0.0.0  tcp       514     disabled
    audit     enabled  32     2048   10       disk  info    -                    0         nonrepetitive  stop      default   disabled  0.0.0.0  tcp       514     disabled
    packet    enabled  32     2048   10       disk  major   -                    0         nonrepetitive  stop      default   disabled  0.0.0.0  tcp       514     disabled
    [ok][2013-10-02 06:41:58]
  4. View CDR Server status using the following command:

    admin@SBC01> show table oam accounting cdrServer status
                               SUCCESSFUL  FAILED     PENDING
    TYPE     STATE   PROGRESS  TRANSFERS   TRANSFERS  TRANSFERS
    -------------------------------------------------------------
    primary  active  done      3           0          0
    [ok][2013-10-02 07:27:19]
  5. Verify that the files were transferred to the FTP server by logging in to the CDR server, and using the following command:

    ftp server:
    root@hostname # pwd
    /export/home/SBC01ACTrecs
    root@hostname # ls -l
    total 708
    -rw-r--r--   1 root     other     346730 Oct  2 06:45 SBC01.20131002064500.1000022.ACT
    -rw-r--r--   1 root     other        175 Oct  2 07:00 SBC01.20131002070000.1000023.ACT
    -rw-r--r--   1 root     other        175 Oct  2 07:15 SBC01.20131002071500.1000024.ACT
    root@hostname #

In this section: