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.

            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 ]
            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

            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
            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 ]
            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.

            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 ]
            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.
            Aurobinda Panda made changes -
            Status QA In Progress [ 10015 ] Closed [ 6 ]
            Resolution Fixed [ 1 ]
            Transition Time In Source Status Execution Times Last Executer Last Execution Date
            Opened Opened Pending Requirements Pending Requirements
            		8d 2h 58m 1 Khaled Khalil 04/Nov/25 8:39 AM
            Pending Requirements Pending Requirements Pending Design Session Pending Design Session
            		7s 1 Khaled Khalil 04/Nov/25 8:39 AM
            Pending Design Session Pending Design Session Dev Scheduled Dev Scheduled
            		8s 1 Khaled Khalil 04/Nov/25 8:39 AM
            Dev Scheduled Dev Scheduled Implementation in progress Implementation in progress
            		9s 1 Khaled Khalil 04/Nov/25 8:39 AM
            Implementation in progress Implementation in progress To Be Released To Be Released
            		11s 1 Khaled Khalil 04/Nov/25 8:39 AM
            To Be Released To Be Released Ready for QA Ready for QA
            		5s 1 Khaled Khalil 04/Nov/25 8:39 AM
            Ready for QA Ready for QA QA In Progress QA In Progress
            		20h 1 Aurobinda Panda 05/Nov/25 4:39 AM
            QA In Progress QA In Progress Closed Closed
            		7d 6h 19m 1 Aurobinda Panda 12/Nov/25 10:59 AM
            Subversion JIRA

            Links Hierarchy

            		  Documentation

            Invalid license: EXPIRED

            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