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

            Permalink
            Marwan Kanaan logged work - 16/Sep/25 12:00 AM
            • Time Spent:
              5 hours
               

              finished the view

            Permalink
            Marwan Kanaan logged work - 22/Sep/25 12:00 AM
            • Time Spent:
              1 hour
               

              fix the view

            Permalink
            Marwan Kanaan logged work - 09/Oct/25 12:00 AM
            • Time Spent:
              1 hour
               

              changes made on the view

            Permalink
            Marwan Kanaan logged work - 15/Oct/25 12:00 AM
            • Time Spent:
              1 hour
               

              another request is done

            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