Details
-
Type:
CR
-
Status:
Closed
(View Workflow)
-
Priority:
Normal
-
Resolution: Fixed
-
Component/s: NEP
-
Labels:None Labels
-
Customer:OMAN-Tel
-
Product:NEP
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 )
Attachments
Open Bug
Activity
- All
- Comments
- Work Log
- History
- Activity
- Links Hierarchy
- Transitions
- Trace
CSV generated by Script sent to Azrin and awaiting confirmation
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
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.
Dear @Shamim Ahmed,
The view has been fixed as requested. Kindly find the updated view query attached please apply it and verify the results.
attached latest script after excluding node Id with names having space
Dear @Salem Dannawi,
The view is finished please share.
View attached.
Best Regards,
Marwan Kanaan I Software Developer