[LS-1052] a NEW script is required to generate VD_integration_E2E file for PE routers Created: 07/Apr/26  Updated: 15/Apr/26  Due: 30/Apr/26  Resolved: 15/Apr/26

Status: Closed
Project: L3 Support
Component/s: NEP
Affects Version/s: None
Fix Version/s: None

Type: CR Priority: Normal
Reporter: Abir Messaikeh Assignee: Abir Messaikeh
Resolution: Fixed Votes: 0
Labels: None
Σ Remaining Estimate: 0 minutes Remaining Estimate: 0 minutes
Σ Time Spent: 3 hours Time Spent: 3 hours
Σ Original Estimate: Not Specified Original Estimate: Not Specified

Attachments: File 20260407_CREATE_VIEWS_NE_ROUTER_DETAILS_PE_AND_VD_INTEGRATION_E2E_V2.sql    
Sub-Tasks:
Key
 Summary
 Type
 Status
 Assignee
LS-1053 a NEW script is required to generate ... Technical task Open Bug Khaled Khalil  
LS-1054 a NEW script is required to generate ... Technical task Open Bug Khaled Khalil  
LS-1056 a NEW script is required to generate ... Technical task Open Bug Khaled Khalil  
Customer:
OMAN-Tel
Planned Start:
Planned End:
Actual Start:
Date of Baselining:

 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,



 Comments   
Comment by Marwan Kanaan [ 07/Apr/26 ]

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

Comment by Marwan Kanaan [ 08/Apr/26 ]

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

Comment by Abir Messaikeh [ 15/Apr/26 ]

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

Generated at Wed Apr 15 16:10:56 EEST 2026 using JIRA 6.1.4#6159-sha1:44eaedef2e4a625c6c7183698b2468d4719c20dc.