Forum Discussion

Nimbostratus

Nov 20, 2014

export F5 ltm virtual servers and pool members to excel or csv

I have been hunting for something to help with doing this as I'm not a great with programming. Is there any scripts or api that can be easily used to gain this info?

Nimbostratus

Jul 12, 2018

Hi all,

tmsh list ltm virtual {pool destination} | awk '/virtual/{printf "%s,",$3}/destination/{printf "%s,",$2}/pool/{printf "%s,",$2; system("tmsh list ltm "$0" {members} | awk '\''/:/{gsub(/ /, \"\", $0);gsub(/{/, \",\", $0);printf $s,$1}'\''");printf "\n"}' > virtuals.csv

Jay code is perfect! It able to export the virtual server and pool for destination. Can the code be modified to allow for virtual server outbound using snat pool?

I have virtual servers used to perform the address translation, and due to an early bug with the LTM, we had to create VS for inbound NAT and outbound NAT, thus we were hoping to generate the view all the in and out bound NAT configurations done.

WildWeasel
Cirrus
Mar 27, 2019
works really good if you were smart and didn't use Partitions. Ug!

Trying to make this awesome script work with Partitions.
- Manikuntald
  Nimbostratus
  May 29, 2019
  Hi WildWeasel,
  
  Are you able to prepare script with partitions.
  
  thanks,
  Samares
ruikoh2
Nimbostratus
Jul 30, 2019
This code is perfect if you have pools on all your virtual servers. Is there a way to tweak this in such a way that it would go next line when it doesn't see a pool for the virtual server?
nurbinabr
Nimbostratus
Feb 05, 2020
Apologize for my lack of knowledge, where should I excecute this command, on the CLI of an SSH session? I am pretty new in the technology.