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
            Permalink
            Aurobinda Panda logged work - 27/Oct/25 12:00 AM
            • Time Spent:
              1 hour
               

              EMS details need to parse for NE DB View.

            Permalink
            Natnael Asfaw logged work - 04/Nov/25 12:00 AM
            • Time Spent:
              30 minutes
               

              Apply view and generate csv file

            Permalink
            Marwan Kanaan logged work - 04/Nov/25 12:00 AM - edited
            • Time Spent:
              4 hours
               

              added a static table and update the script

            Permalink
            Aurobinda Panda logged work - 05/Nov/25 12:00 AM
            • Time Spent:
              2 hours
               

              Output checked after running the script. Found OK. asked L3 to do some changes.

            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