L3 Support
  1. L3 Support
  2. LS-536

OT | Network Element DB view file preparation for AgileOps

        Details

        • Customer:
          OMAN-Tel
        • REQUESTER:
          EXTERNAL

          Description

          it is required to collect different attributes from Site component report and prepare a Network Element Report DB view report & Global SRAN-BSs Report.
          This file will be shared with OT team under agile Ops.

          1. Text File
            20250901_NE_ELEMENT_VIEW.txt
            19 kB
            Marwan Kanaan
          2. Text File
            20250901_SRAN_BS_VIEW.txt
            1 kB
            Marwan Kanaan
          3. Microsoft Excel
            Global Report SRAN_28-07.xlsx
            381 kB
            Aurobinda Panda
          4. Microsoft Excel
            NE Report_28-07.xlsx
            2.26 MB
            Aurobinda Panda
          5. Microsoft Word
            Network Element DB View.docx
            71 kB
            Aurobinda Panda

          Issue Links

          is blocked by

          Technical task - Created by JIRA Agile - do not edit or delete. Issue type for a technical task. LS-769 Adding EMS Details to NE DB View Design Session

          • Normal - To be fixed once possible
          • Cancelled - null

          Technical task - Created by JIRA Agile - do not edit or delete. Issue type for a technical task. LS-770 Adding EMS Details to NE DB View : Testing

          • Normal - To be fixed once possible
          • Cancelled - null

          CR - LS-751 Adding EMS Details to NE DB View

          • Normal - To be fixed once possible
          • Closed - The issue is considered finished, the resolution is correct. Issues which are closed can be reopened.
          relates to

          Technical task - Created by JIRA Agile - do not edit or delete. Issue type for a technical task. LS-769 Adding EMS Details to NE DB View Design Session

          • Normal - To be fixed once possible
          • Cancelled - null

          Technical task - Created by JIRA Agile - do not edit or delete. Issue type for a technical task. LS-770 Adding EMS Details to NE DB View : Testing

          • Normal - To be fixed once possible
          • Cancelled - null

          CR - LS-751 Adding EMS Details to NE DB View

          • Normal - To be fixed once possible
          • Closed - The issue is considered finished, the resolution is correct. Issues which are closed can be reopened.

            Activity

            Ascending order - Click to sort in descending order
            Permalink
            Aurobinda Panda logged work - 01/Aug/25 12:00 AM
            • Time Spent:
              3 hours
               

              Requirements checked & document preparation

            Aurobinda Panda made changes -
            Field Original Value New Value
            Gantt Options Milestone (set to milestone: having a due date but zero effort)
            Planned Start 2025-08-06 24:00 (milestone: set planned start date to due date)
            Planned End 2025-08-06 24:00 (milestone: set planned end date to due date)
            Permalink
            Aurobinda Panda logged work - 04/Aug/25 12:00 AM
            • Time Spent:
              1 hour, 30 minutes
               

              Requirements checked & document preparation

            Aurobinda Panda made changes -
            Remaining Estimate 0 minutes [ 0 ]
            Time Spent 3 hours [ 10800 ]
            Worklog Id 273401 [ 273401 ]
            Aurobinda Panda made changes -
            Baseline Start 2025-08-06 24:00 (set baseline based of initial work logging)
            Baseline End 2025-08-06 24:00 (set baseline based of initial work logging)
            Aurobinda Panda made changes -
            Time Spent 3 hours [ 10800 ] 4 hours, 30 minutes [ 16200 ]
            Worklog Id 273402 [ 273402 ]
            Aurobinda Panda made changes -
            Assignee Aurobinda Panda [ apanda ] Khaled Khalil [ kkhalil ]
            Aurobinda Panda made changes -
            Description it is required to collect different attributes from Site component report and prepare a Network Element Report DB view report.
            This file will be shared with OT team under agile Ops.             		it is required to collect different attributes from Site component report and prepare a Network Element Report DB view report & Global SRAN-BSs Report.
            This file will be shared with OT team under agile Ops.
            Aurobinda Panda made changes -
            Attachment Network Element DB View.docx [ 114600 ]
            Attachment Global Report SRAN_28-07.xlsx [ 114601 ]
            Attachment NE Report_28-07.xlsx [ 114602 ]
            Aurobinda Panda made changes -
            Summary Network Element DB view file preparation OT | Network Element DB view file preparation
            Abir Messaikeh made changes -
            Summary OT | Network Element DB view file preparation OT | Network Element DB view file preparation for AgileOps
            Hassan Abdine made changes -
            Status Opened [ 1 ] Pending Requirements [ 10300 ]
            Assignee Khaled Khalil [ kkhalil ] Nouha Mhadhbi [ nmhadhbi ]
            Hassan Abdine made changes -
            Status Pending Requirements [ 10300 ] Pending Design Session [ 10112 ]
            Assignee Nouha Mhadhbi [ nmhadhbi ] Khaled Khalil [ kkhalil ]
            Hassan Abdine made changes -
            Status Pending Design Session [ 10112 ] Dev Scheduled [ 10014 ]
            Assignee Khaled Khalil [ kkhalil ] Nouha Mhadhbi [ nmhadhbi ]
            Permalink
            Nouha Mhadhbi logged work - 29/Aug/25 12:00 AM
            • Time Spent:
              7 hours
               

              LS-536

            Permalink
            Marwan Kanaan logged work - 01/Sep/25 12:00 AM
            • Time Spent:
              1 day, 1 hour
               

              optimized and cleaned the NE_ELEMENT_VIEW by reducing repeated joins, standardizing column names, and improving readability and performance, and also created the SRAN_BS_VIEW

            Marwan Kanaan made changes -
            Assignee Nouha Mhadhbi [ nmhadhbi ] Marwan Kanaan [ mkanaan ]
            Hide
            Permalink
            Marwan Kanaan added a comment -

            Dear @Aurobinda Panda,

            kindly know that the views are completed.

            scripts attatched

            Best Regards,
            Marwan Kanaan I Software Developer

            Show
            Marwan Kanaan added a comment - Dear @Aurobinda Panda, kindly know that the views are completed. scripts attatched Best Regards, Marwan Kanaan I Software Developer
            Marwan Kanaan made changes -
            Attachment 20250901_NE_ELEMENT_VIEW.txt [ 116611 ]
            Attachment 20250901_SRAN_BS_VIEW.txt [ 116612 ]
            Marwan Kanaan made changes -
            Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
            Marwan Kanaan made changes -
            Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
            Marwan Kanaan made changes -
            Time Spent 4 hours, 30 minutes [ 16200 ] 1 day, 5 hours, 30 minutes [ 48600 ]
            Worklog Id 276132 [ 276132 ]
            Khaled Khalil made changes -
            Status To Be Released [ 10400 ] Ready for QA [ 10023 ]
            Assignee Marwan Kanaan [ mkanaan ] Aurobinda Panda [ apanda ]
            Permalink
            Aurobinda Panda logged work - 09/Sep/25 12:00 AM
            • Time Spent:
              1 hour
               

              DB View files validated.

            Hide
            Permalink
            Aurobinda Panda added a comment -

            Dear team,
            As checked, the output files are correct. But it is found that the separate SRANBS View file contains the role nodes are available in network View report.
            So it is not required to share separate SranBS view file.

            Show
            Aurobinda Panda added a comment - Dear team, As checked, the output files are correct. But it is found that the separate SRANBS View file contains the role nodes are available in network View report. So it is not required to share separate SranBS view file.
            Aurobinda Panda made changes -
            Status Ready for QA [ 10023 ] QA In Progress [ 10015 ]
            Aurobinda Panda made changes -
            Status QA In Progress [ 10015 ] Closed [ 6 ]
            Resolution Fixed [ 1 ]
            Aurobinda Panda made changes -
            Time Spent 1 day, 5 hours, 30 minutes [ 48600 ] 1 day, 6 hours, 30 minutes [ 52200 ]
            Worklog Id 276747 [ 276747 ]
            Hide
            Permalink
            Khaled Khalil added a comment -

            The time spent on this CR is 2 days (Nouha 1 day and Marwan 1 day)

            Show
            Khaled Khalil added a comment - The time spent on this CR is 2 days (Nouha 1 day and Marwan 1 day)
            Nouha Mhadhbi made changes -
            Time Spent 1 day, 6 hours, 30 minutes [ 52200 ] 2 days, 5 hours, 30 minutes [ 77400 ]
            Worklog Id 277144 [ 277144 ]
            Abir Messaikeh made changes -
            Link This issue relates to MOB-7347 [ MOB-7347 ]
            Aurobinda Panda made changes -
            Link This issue is blocked by LS-751 [ LS-751 ]
            Abir Messaikeh made changes -
            Link This issue relates to LS-751 [ LS-751 ]
            Khaled Khalil made changes -
            Link This issue is blocked by LS-769 [ LS-769 ]
            Khaled Khalil made changes -
            Link This issue relates to LS-769 [ LS-769 ]
            Khaled Khalil made changes -
            Link This issue is blocked by LS-770 [ LS-770 ]
            Khaled Khalil made changes -
            Link This issue relates to LS-770 [ LS-770 ]
            Transition Time In Source Status Execution Times Last Executer Last Execution Date
            Opened Opened Pending Requirements Pending Requirements
            		26d 23h 32m 1 Hassan Abdine 28/Aug/25 8:46 AM
            Pending Requirements Pending Requirements Pending Design Session Pending Design Session
            		5s 1 Hassan Abdine 28/Aug/25 8:46 AM
            Pending Design Session Pending Design Session Dev Scheduled Dev Scheduled
            		22s 1 Hassan Abdine 28/Aug/25 8:47 AM
            Dev Scheduled Dev Scheduled Implementation in progress Implementation in progress
            		4d 4h 52m 1 Marwan Kanaan 01/Sep/25 1:39 PM
            Implementation in progress Implementation in progress To Be Released To Be Released
            		5s 1 Marwan Kanaan 01/Sep/25 1:39 PM
            To Be Released To Be Released Ready for QA Ready for QA
            		6m 11s 1 Khaled Khalil 01/Sep/25 1:45 PM
            Ready for QA Ready for QA QA In Progress QA In Progress
            		7d 15h 55m 1 Aurobinda Panda 09/Sep/25 5:41 AM
            QA In Progress QA In Progress Closed Closed
            		11s 1 Aurobinda Panda 09/Sep/25 5:41 AM
            Subversion JIRA

            Links Hierarchy

            		  Documentation

            Invalid license: EXPIRED

            Cancel

              People

              • Assignee:
                Aurobinda Panda
                Reporter:
                Aurobinda Panda
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved:
                  Planned Start:
                  Planned End:
                  Actual Start:
                  Date of Baselining:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 days, 5 hours, 30 minutes
                  2d 5h 30m

                    Drag and Drop