L3 Support
  1. L3 Support
  2. LS-751

Adding EMS Details to NE DB View

        Details

        • Customer:
          OMAN-Tel
        • Complexity:
          Medium
        • Severity:
          Major
        • REQUESTER:
          EXTERNAL

          Description

          Dear Khaled Khalil,

          Please assign a resource to check for below requirement.

          It is required to add the EMS details to NE DB view. Currently the NE DB view file shared with customer is not having any EMS details.

          I have attached a sheet where the NODE_TYPE, NE_TYPE, VENDOR details along with the EMS_NAME.

          1. File
            20250901_NE_ELEMENT_VIEW.sql
            18 kB
            Marwan Kanaan
          2. File
            EMS_CONNECTIONS_INSERTS.sql
            51 kB
            Marwan Kanaan
          3. Microsoft Excel
            EMS Details.xlsx
            20 kB
            Aurobinda Panda
          1. EMS Details.jpg
            56 kB
          2. NE DB View file.jpg
            70 kB

          Issue Links

          blocks

          CR - LS-536 OT | Network Element DB view file preparation for AgileOps

          • 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

          CR - LS-536 OT | Network Element DB view file preparation for AgileOps

          • 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
            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-10-31 24:00 (milestone: set planned start date to due date)
            Planned End 2025-10-31 24:00 (milestone: set planned end date to due date)
            Aurobinda Panda made changes -
            Link This issue is subtask of MOB-7347 [ MOB-7347 ]
            Aurobinda Panda made changes -
            Remaining Estimate 0 minutes [ 0 ]
            Time Spent 1 hour [ 3600 ]
            Worklog Id 281636 [ 281636 ]
            Aurobinda Panda made changes -
            Baseline Start 2025-10-31 24:00 (set baseline based of initial work logging)
            Baseline End 2025-10-31 24:00 (set baseline based of initial work logging)
            Aurobinda Panda made changes -
            Attachment EMS Details.jpg [ 120606 ]
            Attachment NE DB View file.jpg [ 120607 ]
            Aurobinda Panda made changes -
            Link This issue blocks LS-536 [ LS-536 ]
            Abir Messaikeh made changes -
            Link This issue relates to LS-536 [ LS-536 ]
            Khaled Khalil made changes -
            Assignee Khaled Khalil [ kkhalil ] Marwan Kanaan [ mkanaan ]
            Marwan Kanaan made changes -
            Attachment 20250901_NE_ELEMENT_VIEW.sql [ 121207 ]
            Attachment EMS_CONNECTIONS_INSERTS.sql [ 121208 ]
            Marwan Kanaan made changes -
            Assignee Marwan Kanaan [ mkanaan ] Aurobinda Panda [ apanda ]
            Marwan Kanaan made changes -
            Assignee Aurobinda Panda [ apanda ] Marwan Kanaan [ mkanaan ]
            Khaled Khalil made changes -
            Status Opened [ 1 ] Pending Requirements [ 10300 ]
            Khaled Khalil made changes -
            Status Pending Requirements [ 10300 ] Pending Design Session [ 10112 ]
            Assignee Marwan Kanaan [ mkanaan ] Khaled Khalil [ kkhalil ]
            Khaled Khalil made changes -
            Status Pending Design Session [ 10112 ] Dev Scheduled [ 10014 ]
            Khaled Khalil made changes -
            Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
            Khaled Khalil made changes -
            Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
            Khaled Khalil made changes -
            Status To Be Released [ 10400 ] Ready for QA [ 10023 ]
            Assignee Khaled Khalil [ kkhalil ] Aurobinda Panda [ apanda ]
            Natnael Asfaw made changes -
            Time Spent 1 hour [ 3600 ] 1 hour, 30 minutes [ 5400 ]
            Worklog Id 282539 [ 282539 ]
            Aurobinda Panda made changes -
            Status Ready for QA [ 10023 ] QA In Progress [ 10015 ]
            Marwan Kanaan made changes -
            Time Spent 1 hour, 30 minutes [ 5400 ] 5 hours, 30 minutes [ 19800 ]
            Worklog Id 282615 [ 282615 ]
            Marwan Kanaan made changes -
            Worklog Id 282615 [ 282615 ]
            Aurobinda Panda made changes -
            Time Spent 5 hours, 30 minutes [ 19800 ] 7 hours, 30 minutes [ 27000 ]
            Worklog Id 282630 [ 282630 ]
            Aurobinda Panda made changes -
            Status QA In Progress [ 10015 ] Closed [ 6 ]
            Resolution Fixed [ 1 ]
            Cancel

              People

              • Assignee:
                Aurobinda Panda
                Reporter:
                Aurobinda Panda
              • Votes:
                0 Vote for this issue
                Watchers:
                2 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 - 7 hours, 30 minutes
                  7h 30m

                    Drag and Drop