TMobile DB introduction

Log File Upload

How to upload log files

• Upload by web

  • http://173.249.196.168/log_upload/
    
  • Drag ZIP file or DML file and click "Upload" button. 
    

    

  • When log upload completes, it'll show "done".

• Upload ZIP file by FTP

• • FTP server: 173.249.196.168
    user ID: log_upload
    password: wm_log_upload
  • You can't upload DML file without compression
  • You should ZIP log files and upload ZIP file
  • When ZIP file upload is complete, server will move ZIP file to other folder, and unzip, and process log files

Database Explanation

How to access DB

• MySQL DB

  • IP: 173.249.196.168
    username: tmo_db
    password: wm_tmo_db

How to monitor uploaded log files

• Monitor uploaded log files by web

  • http://173.249.196.168/log_list/

How to view DB

DB Table explanation

• tb_wm__1_log_info
  
  • • 'logfile_id' column - ID of log file
    • 'logfile_name' column - log file name (*.DML)
    • 'logfile_size' column - log file size in bytes
    • 'uploader_name' column - uploader
    • 'uploader_email' column
    • 'upload_datetime' column - uploaded time
    • 'm_starttime' column - measurement start time
    • 'm_endtime' column - measurement end time
• tb_wm__2_data_field_info
  

  

  • dma_field_name - internal ID (for server developer)
  • dma_group_name - group and name of KPI (that user will see in LMA)
  • table_name - table name in this DB
  • field_name - field name in table
  • field_type - field type in table
  • If you change favorite file to includes more KPIs, new KPIs will be added as new record in this 'tb_wm__2_data_field_info' table.
• Other tables
  • tb_wm_ce_... - Events 
  • tb_wm_cr_... - Call Results
  • tb_wm_sv_... - Sampled Values
• table naming
  • general - General
  • nr5g - NR 5G
  • lte - LTE
  • ltea - LTE-A