• State Not Answered
  • Locked Locked
  • Replies 1 reply
  • Subscribers 15 subscribers
  • Views 327 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

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.

  • 0

    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

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.