Scribd Logo
Upload

Welcome to Scribd!

  • 18 views

    sub6 scrpit

    Uploaded by

    aslam_326580186

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    sub6 scrpit

    Uploaded by

    aslam_326580186
    18 views6 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    18 views6 pages

    sub6 scrpit

    Uploaded by

    aslam_326580186

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 6

    Sub6 script

    1. First we have to merge SUB6 ON AIR TRACKER and SUB6 ON AIR


    INDOOR TRACKER

    2. Then after merging sheet we have to match all the column same details in
    same line
    3. Then we have to make 11 digit serial by concatenate ORU ProductCode
    and sub6 ORU Serial .

    4. After concatenate we have to remove “EC” and “=ORU” from serial


    number and also check length of serial number should 11 digit .

    5. If serial number is not 11 digit then we have to make it by using this


    formula “=IF(LEN(H2)<5,REPT(0,5-LEN(H2))&H2,H2) “
    6. Then we have to merge gNBid and vDU by using concatenate formula
    {=CONCATENATE(J2,"-du",K2)} .

    after all these final sheet looks like as file given below.

    As shown in below image

    Note :- After merging both sheet we have to match all the column
    same details in same line .

    7. After merging the sheet we have to create input sheet for sub6 script.
    You can find input sheet from this path in WINSCP server “
    /home/sysadmin/AltiostarAutomation5G/DU_Cell_Serial_Number_Che
    ck_2023_11_07/input” in file name is scheduled_oru_input.csv .

    8. In input file we to four details “ gc_ip , gnb_duid , serial_number,


    sector_id “ these details we found these detail in on air sheet same that
    we merge .

    Note;- Input file should be change every week or when something


    change in on air sheet

    9. After input sheet automation server will take 20-22 minute to complete.
    And output will get on BOX on given path “ Box\008 Automation_RMOP\
    RAN Automation Output\5G\DU_Cell_Serial_Number_Check “ . file
    name is DU_CELLSTATUS_current date.
    > output file

    10. After we get output then we need all on air sub6 site details. These
    details found in ON air sheet

    NR Cell ID
    NR Cell
    Name
    5G SARF ID
    Sector
    Name
    DU Name
    SN
    gNBid
    Gnb-du
    GC
    build
    Perfecture
    GC Name

    11. After these we take site status form output sheet and by using vlookup ,
    from serial number to column number{6.7.9} . Cell_Status ,
    Carrier_Status , Rumgr_State .

    condition for site active and operational.

    Cell_Status Carrier_Status Rumgr_State


    NRCELL_DU_ACTIVE NRSECTOR_CARRIER_TRANSMITTING RU_TIMING_LOCKED
    NRCELL_DU_ACTIVE NRSECTOR_CARRIER_TRANSMITTING RU_TIMING_LOCKED
    NRCELL_DU_ACTIVE NRSECTOR_CARRIER_TRANSMITTING RU_TIMING_LOCKED

    condition for site down.

    Cell_Status Carrier_Status Rumgr_State


    RU_WAIT_FOR_CALL_HOM
    NRCELL_DU_IDLE NRSECTOR_CARRIER_BASEBAND_CONFIGURED E
    NRCELL_DU_IDLE NRSECTOR_CARRIER_CONFIGURED RU_TIMING_UNLOCKED
    NRCELL_DU_IDLE NRSECTOR_CARRIER_CONFIGURED RU_TIMING_UNLOCKED
    RU_WAIT_FOR_CALL_HOM
    NRCELL_DU_IDLE NRSECTOR_CARRIER_UNINITIALIZED E
    RU_WAIT_FOR_CALL_HOM
    NRCELL_DU_IDLE NRSECTOR_CARRIER_BASEBAND_CONFIGURED E
    RU_WAIT_FOR_CALL_HOM
    NRCELL_DU_IDLE NRSECTOR_CARRIER_BASEBAND_CONFIGURED E

    12. After taking site status we put active site as operational and down site as
    down in L1 remark .
    For some site we don’t get output we get { #na } for these site we have to
    run script again by using same step creating input file with different name .
    And put in WINSCP server and run a python path on SXHELL

    command to run script.

    1 command;- ssh sysadmin@240b:c010:101:54ab:ffff:ffff:ffff:ff02

    2 command;- sysadmin

    3 command ;- cd
    /home/sysadmin/AltiostarAutomation5G/DU_Cell_Serial_Number_Check_2023
    _11_07

    4 command ;- python3.6 du_cell_status.py -inputfile amit.csv

    and output you will get on same path “ Box\008 Automation_RMOP\RAN


    Automation Output\5G\DU_Cell_Serial_Number_Check “ . file name is
    DU_CELLSTATUS_current date.

    Then after this all step we map tt for down site and create tt for new down
    site.

    You might also like