Monthly Reports - jkossi/Bss_Support GitHub Wiki

Call Duration Report (PM MOC - Dec 2023)

# connect to server
10.135.53.124

cd /dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/

cd /dcbsapp/processed/preprocessor/gluster/csv/data/2023-11-01

# Run below scripts


``

## For PostPaid Roaming file

Update 2023-11 to the year and month you are running the report for -> 2024-01 

#!/bin/bash                                                                                                                                  
                                                                                                                                             
cd /dcbsapp/processed/preprocessor/gluster/csv/data/2023-11-01;                                                                              
cd ../2023-11-01;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-02;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-03;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-04;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-05;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-06;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-07;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-08;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-09;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-10;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-11;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-12;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-13;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-14;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-15;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-16;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-17;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-18;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-19;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-20;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-21;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-22;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-23;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-24;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-25;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-26;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-27;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-28;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-29;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-30;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;                 
cd ../2023-11-31;                                                                                                                            
for i in `ls`;do grep "Roam" $i >>/dcbsapp/processed/preprocessor/gluster/csv/mso_scripts/MonthEnd/roam_files/2311.txt;done;