Forum Discussion

Macaron's avatar
Macaron
Icon for Nimbostratus rankNimbostratus
Apr 23, 2021

tmsh command to filter VIP with "current connection" count

Hi Everyone,

I am trying to make a list of VIP in our inventory having "current connection". I currently doing it manually through GUI by navigating to VIP statistics and looking for VIPs having current connections. This is very time consuming.

 

I was wondering if there is a tmsh one line command that i can use for this purpose which will return all VIP having current connections?

 

 

Thanks in advance.

 

application delivery
BIG-IP
iControl
  • Rob_Stonham's avatar
    Rob_Stonham
    Apr 23, 2021

    Does this work for you?

    It shows a list of all virtual servers with a current client side connection count of greater than 0.

    tmsh -q -c "cd / ; show /ltm virtual recursive field-fmt" | grep "ltm\ virtual\|clientside.cur-conns" | awk '/clientside.cur-conns\ [1-9]/ { print $2, a}{a=$3}'

    or if you want all virtual servers ordered by number of current connections

    tmsh -q -c "cd / ; show /ltm virtual recursive field-fmt" | grep "ltm\ virtual\|clientside.cur-conns" | awk '/clientside.cur-conns/ { print $2, a}{a=$3}' | sort -n

    If you really want the IP address, you can replace "virtual" with "virtual-address" in the commands above to get the VIP instead of the virtual server name displayed

    Rob

  • Rob_Stonham's avatar
    Rob_Stonham
    Icon for Cirrus rankCirrus
    Apr 23, 2021

    Does this work for you?

    It shows a list of all virtual servers with a current client side connection count of greater than 0.

    tmsh -q -c "cd / ; show /ltm virtual recursive field-fmt" | grep "ltm\ virtual\|clientside.cur-conns" | awk '/clientside.cur-conns\ [1-9]/ { print $2, a}{a=$3}'

    or if you want all virtual servers ordered by number of current connections

    tmsh -q -c "cd / ; show /ltm virtual recursive field-fmt" | grep "ltm\ virtual\|clientside.cur-conns" | awk '/clientside.cur-conns/ { print $2, a}{a=$3}' | sort -n

    If you really want the IP address, you can replace "virtual" with "virtual-address" in the commands above to get the VIP instead of the virtual server name displayed

    Rob

    • Macaron's avatar
      Macaron
      Icon for Nimbostratus rankNimbostratus
      Apr 23, 2021

      Thank you so much. It worked as expected. Also, I am trying to build these filters my self would you be to able give me a head start?