[LS-640] GPON DB view for InfoVista Created: 11/Sep/25  Updated: 20/Oct/25  Due: 17/Sep/25  Resolved: 20/Oct/25

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

Type: CR Priority: Normal
Reporter: Shamim Ahmed Assignee: Shamim Ahmed
Resolution: Fixed Votes: 0
Labels: None
Σ Remaining Estimate: 0 minutes Remaining Estimate: 0 minutes
Σ Time Spent: 1 day, 1 hour, 30 minutes Time Spent: 1 day, 1 hour, 30 minutes
Σ Original Estimate: Not Specified Original Estimate: Not Specified

Attachments: File 20250917_GPON_INFOVISTA_VIEW.sql     File 20250917_GPON_INFOVISTA_VIEW.sql     Microsoft Excel GPON_Infovista_view_Structure.xlsx     File MDU Report.csv     File Multi Technology Access Report.csv     File ONTs Report.csv     PNG File Screenshot 2025-10-07 081354.png     PNG File Screenshot 2025-10-07 081534.png     PNG File Screenshot 2025-10-07 082011.png     PNG File Screenshot 2025-10-07 082059.png    
Sub-Tasks:
Key
 Summary
 Type
 Status
 Assignee
LS-641 GPON DB view for InfoVista Requiremen... Technical task Open Bug Khaled Khalil  
LS-650 GPON DB view for InfoVista Design Ses... Technical task Open Bug Khaled Khalil  
LS-654 GPON DB view for InfoVista : Testing Technical task Open Bug Khaled Khalil  
Customer:
OMAN-Tel
Planned Start:
Planned End:
Product: NEP
Actual Start:
Date of Baselining:

 Description   

We need to create a new DB view for OLT,MSAN, MDU and BONT nodes with attached structure

source of info is OLT , MSAN, MDU and BONT reports and Site report ( attached here )

 Comments   
Comment by Marwan Kanaan [ 17/Sep/25 ]

Dear @Salem Dannawi,

The view is finished please share. 
View attached.

Best Regards,
Marwan Kanaan I Software Developer

Comment by Abir Messaikeh [ 29/Sep/25 ]

CSV generated by Script sent to Azrin and awaiting confirmation

Comment by Abir Messaikeh [ 02/Oct/25 ]

as per Azrin Comment , we need below update in view

insert a new column i.e KEYWORD and fill with default value GPON. Secondly rename TAG with TYPE as shown below

Comment by Marwan Kanaan [ 07/Oct/25 ]

Dear @Shamim Ahmed,

It seems that the search criteria are not being used as intended.

Regarding your last email, I ran the same view script that I shared previously, and here is the result:
For the ONT node, the IP appears correctly without any issues.

ss

Furthermore, I checked the Excel sheet shared by Natnael and found the following:

ss

As for the node OT74_01_MA5600T_OLT, I could not find it in either the view or the Excel sheet.

ss
ss

Please try to verify the output on your side, and if any issue occurs, feel free to contact me on Teams.

Comment by Marwan Kanaan [ 09/Oct/25 ]

Dear @Shamim Ahmed,

The view has been fixed as requested. Kindly find the updated view query attached please apply it and verify the results.

Comment by Abir Messaikeh [ 15/Oct/25 ]

attached latest script after excluding node Id with names having space

Generated at Fri Apr 17 10:59:48 EEST 2026 using JIRA 6.1.4#6159-sha1:44eaedef2e4a625c6c7183698b2468d4719c20dc.