1 Reply Latest reply on Jan 24, 2017 11:20 AM by ctlswadmin

    F5 usage report

    jfanter-stlcc

      I have been asked to create a report which graphs the number of connections per virtual server (VS) on the F5.  I am looking for a single line per VS, not a line for each pool member.  I have more than 10 VS so the graph that shows the top 10 connections will not work for me.

        • Re: F5 usage report
          ctlswadmin

          Give this a try, let me know if it works:

           

          Select NodesData.Caption,COUNT (F5_LTM_PoolMember.OrionStatus) AS 'Active Connections'

          From F5_LTM_PoolMember

          INNER JOIN NodesData

          ON F5_LTM_PoolMember.NodeID = NodesData.NodeID

          Where F5_LTM_PoolMember.OrionStatus = '1'

          Group by NodesData.Caption,F5_LTM_PoolMember.OrionStatus