For more information regarding the security incident at F5, the actions we are taking to address it, and our ongoing efforts to protect our customers, click here.

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
Ahmed_Mostafa_K's avatar
Ahmed_Mostafa_K
Icon for Nimbostratus rankNimbostratus
Apr 21, 2020

Hi all

 

I update the following script (Script to create csv file have VS name, VS IP, Pool name, Pool Members name => until they using iApps to create the VS and I think also will work with partition), could you please send your feedback.

 

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