Forum Discussion

keenon_49862's avatar
keenon_49862
Icon for Nimbostratus rankNimbostratus
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?  
deployment
devops
iApps
iControl
management
TMSH
Jay_41673's avatar
Jay_41673
Icon for Nimbostratus rankNimbostratus

v11.6 one liner, no button :)

 

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

 

ulpe_279563's avatar
ulpe_279563
Icon for Nimbostratus rankNimbostratus
Mar 20, 2017

Thanks for this! The command works really well, apart from an error message and some VSes missing from export: "The requested Pool (/Common/none) was not found."

 

Also, would it be possible to add an iRule column to the .csv output?