1 Reply Latest reply on Mar 13, 2018 10:17 AM by bdufresne

    BGP Availability Report

    metaldian

      Hello Everyone,,

       

      i have BGP status displayed like this :

      Can anyone please help make BGP availability report based on "Protocol Orion Status" ?

      I don't have sql knowledge.

       

      Thank You

        • Re: BGP Availability Report
          bdufresne

          I did some digging into the DB, and don't see a way to identify availability other than since the last flap.  There are some route flapping statistics, but I don't think NPM intended to record the routing availability.  Here is the SQL version of basically what you have.

           

          SELECT  

               nd.Caption,

               nd.IP_Address DeviceIP,

               rn.AutonomousSystem,

               rn.NeighborIP,

               rp.DisplayName AS RoutingProtocol,

               rpsm.DisplayName AS ProtocolStatus,

               rn.Lastchange

          FROM NPM_RoutingNeighbor AS rn

               LEFT JOIN NodesData AS nd

                 ON rn.NodeID=nd.NodeID

               LEFT JOIN NPM_RoutingProtocolStateMapping AS rpsm

                 ON rn.ProtocolID=rpsm.ProtocolID

                   AND rn.ProtocolStatus=rpsm.ProtocolStatus

               LEFT JOIN NPM_RoutingProtocol AS rp

                 ON rn.ProtocolID=rp.ProtocolID

           

          If you were to retain the changes on another DB, you might be able to start looking at availability.