L3 Support
  1. L3 Support
  2. LS-640

GPON DB view for InfoVista

        Details

        • Type: CR CR
        • Status: Closed Closed (View Workflow)
        • Priority: Normal 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 )

          1. File
            20250917_GPON_INFOVISTA_VIEW.sql
            5 kB
            Abir Messaikeh
          2. File
            20250917_GPON_INFOVISTA_VIEW.sql
            5 kB
            Marwan Kanaan
          3. Microsoft Excel
            GPON_Infovista_view_Structure.xlsx
            10 kB
            Salem Dannawi
          4. File
            MDU Report.csv
            86 kB
            Salem Dannawi
          5. File
            Multi Technology Access Report.csv
            279 kB
            Salem Dannawi
          6. File
            ONTs Report.csv
            512 kB
            Salem Dannawi
          1. Screenshot 2025-10-07 081354.png
            20 kB
          2. Screenshot 2025-10-07 081534.png
            20 kB
          3. Screenshot 2025-10-07 082011.png
            53 kB
          4. Screenshot 2025-10-07 082059.png
            18 kB

            Activity

            Ascending order - Click to sort in descending order
            Permalink
            Salem Dannawi logged work - 11/Sep/25 12:00 AM
            • Time Spent:
              1 hour, 30 minutes
               

              match each variable with its correct report and share it

            Salem Dannawi made changes -
            Field Original Value New Value
            Gantt Options Milestone (set to milestone: having a due date but zero effort)
            Planned Start 2025-09-17 24:00 (milestone: set planned start date to due date)
            Planned End 2025-09-17 24:00 (milestone: set planned end date to due date)
            Salem Dannawi made changes -
            Attachment GPON_Infovista_view_Structure.xlsx [ 117407 ]
            Salem Dannawi made changes -
            Attachment MDU Report.csv [ 117408 ]
            Attachment Multi Technology Access Report.csv [ 117409 ]
            Attachment ONTs Report.csv [ 117410 ]
            Salem Dannawi made changes -
            Remaining Estimate 0 minutes [ 0 ]
            Time Spent 1 hour, 30 minutes [ 5400 ]
            Worklog Id 277197 [ 277197 ]
            Salem Dannawi made changes -
            Baseline Start 2025-09-17 24:00 (set baseline based of initial work logging)
            Baseline End 2025-09-17 24:00 (set baseline based of initial work logging)
            Khaled Khalil made changes -
            Assignee Khaled Khalil [ kkhalil ] Mustapha Al-Hage [ malhage ]
            Marwan Kanaan made changes -
            Assignee Mustapha Al-Hage [ malhage ] Marwan Kanaan [ mkanaan ]
            Permalink
            Marwan Kanaan logged work - 16/Sep/25 12:00 AM
            • Time Spent:
              5 hours
               

              finished the view

            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 ]
            Assignee Khaled Khalil [ kkhalil ] Marwan Kanaan [ mkanaan ]
            Khaled Khalil made changes -
            Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
            Assignee Marwan Kanaan [ mkanaan ] Khaled Khalil [ kkhalil ]
            Khaled Khalil made changes -
            Assignee Khaled Khalil [ kkhalil ] Marwan Kanaan [ mkanaan ]
            Marwan Kanaan made changes -
            Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
            Hide
            Permalink
            Marwan Kanaan added a comment -

            Dear @Salem Dannawi,

            The view is finished please share. 
            View attached.

            Best Regards,
            Marwan Kanaan I Software Developer

            Show
            Marwan Kanaan added a comment - Dear @Salem Dannawi, The view is finished please share.  View attached. Best Regards, Marwan Kanaan I Software Developer
            Marwan Kanaan made changes -
            Attachment 20250917_GPON_INFOVISTA_VIEW.sql [ 117800 ]
            Marwan Kanaan made changes -
            Time Spent 1 hour, 30 minutes [ 5400 ] 6 hours, 30 minutes [ 23400 ]
            Worklog Id 277831 [ 277831 ]
            Khaled Khalil made changes -
            Status To Be Released [ 10400 ] Ready for QA [ 10023 ]
            Assignee Marwan Kanaan [ mkanaan ] Salem Dannawi [ sdannawi ]
            Permalink
            Marwan Kanaan logged work - 22/Sep/25 12:00 AM
            • Time Spent:
              1 hour
               

              fix the view

            Marwan Kanaan made changes -
            Time Spent 6 hours, 30 minutes [ 23400 ] 7 hours, 30 minutes [ 27000 ]
            Worklog Id 278169 [ 278169 ]
            Abir Messaikeh made changes -
            Status Ready for QA [ 10023 ] QA In Progress [ 10015 ]
            Assignee Salem Dannawi [ sdannawi ] Abir Messaikeh [ amessaikeh ]
            Hide
            Permalink
            Abir Messaikeh added a comment -

            CSV generated by Script sent to Azrin and awaiting confirmation

            Show
            Abir Messaikeh added a comment - CSV generated by Script sent to Azrin and awaiting confirmation
            Hide
            Permalink
            Abir Messaikeh added a comment -

            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

            Show
            Abir Messaikeh added a comment - 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
            Abir Messaikeh made changes -
            Status QA In Progress [ 10015 ] Bug/s Found [ 10208 ]
            Abir Messaikeh made changes -
            Assignee Abir Messaikeh [ amessaikeh ] Marwan Kanaan [ mkanaan ]
            Abir Messaikeh made changes -
            Reporter Salem Dannawi [ sdannawi ] Shamim Ahmed [ sahmed ]
            Hide
            Permalink
            Marwan Kanaan added a comment -

            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.

            Show
            Marwan Kanaan added a comment - 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.
            Marwan Kanaan made changes -
            Attachment Screenshot 2025-10-07 082059.png [ 119202 ]
            Attachment Screenshot 2025-10-07 082011.png [ 119203 ]
            Attachment Screenshot 2025-10-07 081534.png [ 119204 ]
            Attachment Screenshot 2025-10-07 081354.png [ 119205 ]
            Marwan Kanaan made changes -
            Assignee Marwan Kanaan [ mkanaan ] Khaled Khalil [ kkhalil ]
            Permalink
            Marwan Kanaan logged work - 09/Oct/25 12:00 AM
            • Time Spent:
              1 hour
               

              changes made on the view

            Marwan Kanaan made changes -
            Assignee Khaled Khalil [ kkhalil ] Marwan Kanaan [ mkanaan ]
            Marwan Kanaan made changes -
            Assignee Marwan Kanaan [ mkanaan ] Shamim Ahmed [ sahmed ]
            Marwan Kanaan made changes -
            Attachment 20250917_GPON_INFOVISTA_VIEW.sql [ 117800 ]
            Hide
            Permalink
            Marwan Kanaan added a comment -

            Dear @Shamim Ahmed,

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

            Show
            Marwan Kanaan added a comment - Dear @Shamim Ahmed, The view has been fixed as requested. Kindly find the updated view query attached please apply it and verify the results.
            Marwan Kanaan made changes -
            Attachment 20250917_GPON_INFOVISTA_VIEW.sql [ 119442 ]
            Marwan Kanaan made changes -
            Time Spent 7 hours, 30 minutes [ 27000 ] 1 day, 30 minutes [ 30600 ]
            Worklog Id 279855 [ 279855 ]
            Permalink
            Marwan Kanaan logged work - 15/Oct/25 12:00 AM
            • Time Spent:
              1 hour
               

              another request is done

            Abir Messaikeh made changes -
            Attachment 20250917_GPON_INFOVISTA_VIEW.sql [ 119815 ]
            Hide
            Permalink
            Abir Messaikeh added a comment -

            attached latest script after excluding node Id with names having space

            Show
            Abir Messaikeh added a comment - attached latest script after excluding node Id with names having space
            Marwan Kanaan made changes -
            Time Spent 1 day, 30 minutes [ 30600 ] 1 day, 1 hour, 30 minutes [ 34200 ]
            Worklog Id 280602 [ 280602 ]
            Abir Messaikeh made changes -
            Status Bug/s Found [ 10208 ] Closed [ 6 ]
            Resolution Fixed [ 1 ]
            Transition Time In Source Status Execution Times Last Executer Last Execution Date
            Opened Opened Pending Requirements Pending Requirements
            		5d 5h 17m 1 Khaled Khalil 16/Sep/25 11:20 AM
            Pending Requirements Pending Requirements Pending Design Session Pending Design Session
            		6s 1 Khaled Khalil 16/Sep/25 11:20 AM
            Pending Design Session Pending Design Session Dev Scheduled Dev Scheduled
            		14s 1 Khaled Khalil 16/Sep/25 11:20 AM
            Dev Scheduled Dev Scheduled Implementation in progress Implementation in progress
            		6s 1 Khaled Khalil 16/Sep/25 11:20 AM
            Implementation in progress Implementation in progress To Be Released To Be Released
            		18h 22m 1 Marwan Kanaan 17/Sep/25 5:43 AM
            To Be Released To Be Released Ready for QA Ready for QA
            		7h 56m 1 Khaled Khalil 17/Sep/25 1:40 PM
            Ready for QA Ready for QA QA In Progress QA In Progress
            		11d 23h 46m 1 Abir Messaikeh 29/Sep/25 1:26 PM
            QA In Progress QA In Progress Bug/s Found Bug/s Found
            		2d 19h 48m 1 Abir Messaikeh 02/Oct/25 9:15 AM
            Bug/s Found Bug/s Found Closed Closed
            		18d 5h 32m 1 Abir Messaikeh 20/Oct/25 2:47 PM
            Subversion JIRA

            Links Hierarchy

            		  Documentation

            Invalid license: EXPIRED

            Cancel

              People

              • Assignee:
                Shamim Ahmed
                Reporter:
                Shamim Ahmed
              • Votes:
                0 Vote for this issue
                Watchers:
                3 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 - 1 day, 1 hour, 30 minutes
                  1d 1h 30m

                    Drag and Drop