How to Collect All CDRs from the NBRS Server for SO Clients

Overview

This article provides instructions for collecting all Call Detail Records (CDRs) from the NBRS server for SO clients. The process includes accessing the server, locating the appropriate directory, configuring the date range in a script, and executing the script to extract and consolidate the CDRs. The final output is a CSV file containing the CDR data, including platform and OS version information.

---

Solution

To collect all CDRs for SO clients from the NBRS server, follow these steps:

Prerequisites

• SSH access to the NBRS server.

• Sufficient privileges to execute scripts and read files from the SCDR directory.

• Known input date range in YYYYMMDD format.

• Availability of the script SOClientAllCDR.sh under the directory:

  /mnt/genband/billing/billable

Step-by-Step Instructions

1. Access the NBRS Server

   • Use an SSH client to connect to the NBRS server.

   • Use the appropriate credentials (e.g., Kandy.io credentials for UAE).

2. Navigate to the SCDR Directory

   Run the following command after logging in:

   cd /mnt/genband/billing/billable

3. Configure the Date Range in the Script

   Open the script in a text editor:

   vi SOClientAllCDR.sh

   Update the start_date and end_date variables in the CONFIG section to reflect the desired date range:

   start_date="YYYYMMDD" end_date="YYYYMMDD"

   Example:

   start_date="20250821" end_date="20250821"

4. Run the CDR Collection Script

   Execute the script to collect and consolidate the CDRs:

   ./SOClientAllCDR.sh

   The script will process all relevant SCDR files in the specified date range and generate a CSV file named AllCdrs_WithOS.csv in the same directory.
   
   

5. Validate the Output

   • Confirm that the expected number of SCDR files were processed.

   • Verify that AllCdrs_WithOS.csv is generated and is not empty.

   • Optionally inspect the contents of the CSV to ensure field completeness.

Troubleshooting

If no output is generated or the script fails to find files:

• Ensure the date range matches the SCDR files available in the directory.

• Check file permissions using:

  ls -l

---

Reference Documentation

• Kandy GitHub Repository - NBRS SO Client CDR Run Book