3 Replies Latest reply on Aug 22, 2014 9:00 AM by katieb

    F5 Report

    jtimes

      Here is the thought:  a listing of all Load Balancers with VIP, and Virtual Server members

       

      Expected results:

      nodename (of loadbalancer)

          VIP1 (aka Pool)

                  IP    Port    Enabled State    Availability_State

                  IP    Port     Enabled State    Availability_State

                  IP    Port    Enabled State    Availability_State

                  IP    Port     Enabled State    Availability_State

          VIP2 (aka Pool)

                  IP    Port    Enabled State    Availability_State

                  IP    Port     Enabled State    Availability_State

                  IP    Port     Enabled State    Availability_State

       

      etc...

       

      Adv SQL for the Report

       

      SELECT distinct  <--- I keep switching between DISTINCT and TOP x with varying results

      Nodes.NodeID as NODEID,<---Hidden field (within Report Writer)

      Nodes.Caption AS Loadbalancer,

      F5_Pools.Name AS Pool_Name,

      F5_VirtualServers.IP AS Member_IP,

      F5_VirtualServers.Port AS Member_Port,

      F5_VirtualServers.EnabledState AS Member_State,

      F5_VirtualServers.AvailabilityState AS Member_Availiblity_State

       

      FROM

      Nodes

      INNER JOIN F5_Pools ON Nodes.NodeID = F5_Pools.NodeID

      INNER JOIN F5_VirtualServers ON F5_Pools.Name = F5_VirtualServers.Name

      ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

       

      Anyone have any suggestions?

        • Re: F5 Report
          cgregors

          You've gotten closer than I ever got.

           

          I think the advantage you had was you could convince whoever manages the F5 devices is to line up the F5_Pools.name field with the F5_VirtualServers.Name field.

           

          Unfortunately this doesn't work for me as the conventions adopted by the F5 Admins results in something like this:

           

          F5_Pools.Name = /RD3/Lpsentry2010_443_pool

          F5_VirtualServers.Name = /RD3/Lpsentry2010_https_virtual

           

          which means the last join doesn't return anything.

           

          I noticed that there is a relation gaps between the VirtualServer / Pool / Node tables. I include a tabletop analysis.

           

          ScreenClip.png

           

          NOTE: Orion Virtual Server names = F5_VirtualServers with any path stripped off the front.

           

          • eg: F5_VirtualServers .Name = /RD3/Pool_checker_vlan701 , displayname = Pool_checker_vlan701

           

          sucks to be us.

           

          Chris

          • Re: F5 Report
            cgregors

            Additional note:

             

            My SQL query:

            select

                F5D.NodeID,

                N.caption,

                F5VS.Name F5VirtualServer,

                F5VS.IP F5Vip,

                Port F5VipPort,

                F5P.Name F5Pool,

                F5P.EnabledState PoolEnabled

            from

                nodes N,

                F5_Device F5D,

                F5_Pools F5P,

                F5_VirtualServers F5VS

            where

                N.nodeid = F5D.NodeID and

                F5P.NodeID = F5D.NodeID and

                F5VS.NodeID = F5D.NodeID

             

            returns 87,000 rows

             

            and when I change the where clause to this:

             

            where

                N.nodeid = F5D.NodeID and

                F5P.NodeID = F5D.NodeID and

                F5VS.NodeID = F5D.NodeID and

                F5VS.Name = F5P.Name

             

            I get 0 rows.

            • Re: F5 Report
              katieb

              Hey jtimes

               

              Would you be interested in joining us for The Big Fun F5 Brainstorm