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
Dec 17, 2016

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?