L3 Support
  1. L3 Support
  2. LS-1052

a NEW script is required to generate VD_integration_E2E file for PE routers

        Details

        • Type: CR CR
        • Status: Closed Closed (View Workflow)
        • Priority: Normal Normal
        • Resolution: Fixed
        • Component/s: NEP
        • Labels:
          None Labels
        • Customer:
          OMAN-Tel

          Description

          OT is requesting to create and expose new view called VD_Integration_E2E typically similar to the existing VD_Integration ,that allows PE routers to be displayed as well.

          Header will be as showing in below:

          Keyword IPSLA HQ Loopback PE/Branch WANIP
          #SNMP_CATEGORY TAG IP_ADDRESS SNMP_COMMUNITY NAME CUSTOMER_NAME CUSTOMER_ID CUSTOMER_GROUP SITE_CODE LOCATION_CITY LOCATION_REGION RESOURCE_TYPE NE_POSITION VENDOR SLA_CATEGORY SNMPWR COUNTRY SERVICE_NAME BC_CATEGORY SERVICE_TAG CUSTOMER_HQ_NE ACCOUNT_NUMBER 22 23 UNION_ORDER CUSTOMER_OWNER
          IPSLA 82.178.0.150 100.64.2.102 MINI OF INTERIOR (MOIN) udp-jitter NDC-E2E-VALUE-MAIN-LINK Oman Default Site MO-INTERIOR-AL-LAKBI-3G4G CM0000000000202 Cisco EGOV 683 3
          IPSLA 82.178.0.150 100.64.2.4 MINI OF INTERIOR (MOIN) udp-jitter NDC-E2E-VALUE-MAIN-LINK Oman Default Site MO-INTERIOR-DAMA-3G4G CM0000000000202 Cisco EGOV 703 3
          IPSLA 82.178.0.150 100.64.2.7 MINI OF INTERIOR (MOIN) udp-jitter NDC-E2E-VALUE-MAIN-LINK Oman Default Site MO-INTERIOR-REEMA-3G4G CM0000000000202 Cisco EGOV 734 3
          IPSLA 82.178.0.150 100.64.25.4 COUNCIL ADMINISTRATIVE AFFAIRS JUDICIARY (CAAJ) udp-jitter NDC-E2E-VALUE-MAIN-LINK DHOFAR Oman CAAJ-NP-SADAH-3G Sadah Bronze CAAJ-NP-SADAH-3G CM0000000000805 Cisco EGOV 88 3

          Please ping me if you need any clarification.

          Best Regards,

            Activity

            Ascending order - Click to sort in descending order
            Abir Messaikeh made changes -
            Field Original Value New Value
            Gantt Options Milestone (set to milestone: having a due date but zero effort)
            Planned Start 2026-04-30 24:00 (milestone: set planned start date to due date)
            Planned End 2026-04-30 24:00 (milestone: set planned end date to due date)
            Khaled Khalil made changes -
            Assignee Khaled Khalil [ kkhalil ] 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 -
            Assignee Khaled Khalil [ kkhalil ] Marwan Kanaan [ mkanaan ]
            Hide
            Permalink
            Marwan Kanaan added a comment -

            Dear @Khaled Ayoubi,

            Kindly find the attached script. For further clarification, it contains two views:

            • NE_ROUTER_DETAILS_PE: This view is dedicated to PE routers and must be applied first.
            • VD_INTEGRATION_E2E: This view functions similarly to the existing one, with the addition of joining the newly introduced view above.

            Please ensure the correct order of execution as mentioned.

            Best Regards,
            Marwan Kanaan I Software Developer

            Show
            Marwan Kanaan added a comment - Dear @Khaled Ayoubi, Kindly find the attached script. For further clarification, it contains two views: NE_ROUTER_DETAILS_PE: This view is dedicated to PE routers and must be applied first. VD_INTEGRATION_E2E: This view functions similarly to the existing one, with the addition of joining the newly introduced view above. Please ensure the correct order of execution as mentioned. Best Regards, Marwan Kanaan I Software Developer
            Marwan Kanaan made changes -
            Attachment 20260407_CREATE_VIEWS_NE_ROUTER_DETAILS_PE_AND_VD_INTEGRATION_E2E.sql [ 131912 ]
            Marwan Kanaan 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 Marwan Kanaan [ mkanaan ] Abir Messaikeh [ amessaikeh ]
            Permalink
            Marwan Kanaan logged work - 08/Apr/26 12:00 AM - edited
            • Time Spent:
              3 hours
               

              fixed and optimized the views

            Marwan Kanaan made changes -
            Attachment 20260407_CREATE_VIEWS_NE_ROUTER_DETAILS_PE_AND_VD_INTEGRATION_E2E.sql [ 131912 ]
            Hide
            Permalink
            Marwan Kanaan added a comment -

            Dear @Khaled M Ayoubi,

            Please find attached the updated version of the scripts, including optimizations applied across all of them.

            Best Regards,
            Marwan Kanaan I Software Developer

            Show
            Marwan Kanaan added a comment - Dear @Khaled M Ayoubi, Please find attached the updated version of the scripts, including optimizations applied across all of them. Best Regards, Marwan Kanaan I Software Developer
            Marwan Kanaan made changes -
            Remaining Estimate 0 minutes [ 0 ]
            Time Spent 3 hours [ 10800 ]
            Worklog Id 296409 [ 296409 ]
            Marwan Kanaan made changes -
            Baseline Start 2026-04-30 24:00 (set baseline based of initial work logging)
            Baseline End 2026-04-30 24:00 (set baseline based of initial work logging)
            Marwan Kanaan made changes -
            Worklog Id 296409 [ 296409 ]
            Abir Messaikeh made changes -
            Status Ready for QA [ 10023 ] QA In Progress [ 10015 ]
            Hide
            Permalink
            Abir Messaikeh added a comment -

            new report provided to InfoVista but it cannot be used by them with current design they have
            topic still under discussion at OT level so i am closing this ticket for now

            Show
            Abir Messaikeh added a comment - new report provided to InfoVista but it cannot be used by them with current design they have topic still under discussion at OT level so i am closing this ticket for now
            Abir Messaikeh 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
            		10m 21s 1 Khaled Khalil 07/Apr/26 9:09 AM
            Pending Requirements Pending Requirements Pending Design Session Pending Design Session
            		6s 1 Khaled Khalil 07/Apr/26 9:09 AM
            Pending Design Session Pending Design Session Dev Scheduled Dev Scheduled
            		7s 1 Khaled Khalil 07/Apr/26 9:09 AM
            Dev Scheduled Dev Scheduled Implementation in progress Implementation in progress
            		4s 1 Khaled Khalil 07/Apr/26 9:09 AM
            Implementation in progress Implementation in progress To Be Released To Be Released
            		53m 19s 1 Marwan Kanaan 07/Apr/26 10:03 AM
            To Be Released To Be Released Ready for QA Ready for QA
            		2m 43s 1 Khaled Khalil 07/Apr/26 10:05 AM
            Ready for QA Ready for QA QA In Progress QA In Progress
            		8d 57m 1 Abir Messaikeh Wednesday 11:02 AM
            QA In Progress QA In Progress Closed Closed
            		1m 35s 1 Abir Messaikeh Wednesday 11:04 AM
            Subversion JIRA

            Links Hierarchy

            		  Documentation

            Invalid license: EXPIRED

            Cancel

              People

              • Assignee:
                Abir Messaikeh
                Reporter:
                Abir Messaikeh
              • 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 - 3 hours
                  3h

                    Drag and Drop