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.
          There are no Sub-Tasks for this issue.

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            Marwan Kanaan added a comment -

            Dear @Aurobinda Panda,

            Kindly find the updated script attached.

            Please note that the queries in EMS_CONNECTIONS_INSERTS should be executed first before running the main query.

            Best Regards,
            Marwan Kanaan I Software Developer

            Show
            Marwan Kanaan added a comment - Dear @Aurobinda Panda, Kindly find the updated script attached. Please note that the queries in EMS_CONNECTIONS_INSERTS should be executed first before running the main query. Best Regards, Marwan Kanaan I Software Developer
            Hide
            Permalink
            Aurobinda Panda added a comment -

            Thank you @marwan.

            I am closing the ticket.

            Show
            Aurobinda Panda added a comment - Thank you @marwan. I am closing the ticket.
            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