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

17 Replies

  • Gabriel_V_13146's avatar
    Gabriel_V_13146
    Icon for Cirrus rankCirrus
    Nov 20, 2014

    you can use the tmsh script

    e.g. to export the whole LTM configuration you can use

    tmsh list ltm

    if you need only virtual servers, you can type

    tmsh list ltm virtual

    Gabriel

    • Gabriel_V_13146's avatar
      Gabriel_V_13146
      Icon for Cirrus rankCirrus
      Nov 20, 2014
      Still there's iControl API ( https://clouddocs.f5.com/api/icontrol-soap/HomePage.html ) if you're looking for an API. But I wouldn't expect a simple button export..
  • 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?

       

  • Venkatar's avatar
    Venkatar
    Icon for Nimbostratus rankNimbostratus
    Nov 05, 2017

    Thanks a lot Jay for the command. It is really great. Can you please add Node members IP and status.

     

  • Patric's avatar
    Patric
    Icon for Altostratus rankAltostratus
    Mar 07, 2018

    Is it possible to have this done with REST API call instead?

     

  • Ricky_77387's avatar
    Ricky_77387
    Icon for Nimbostratus rankNimbostratus
    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's avatar
      WildWeasel
      Icon for Cirrus rankCirrus
      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.

       

    • ruikoh2's avatar
      ruikoh2
      Icon for Nimbostratus rankNimbostratus
      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's avatar
      nurbinabr
      Icon for Nimbostratus rankNimbostratus
      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.

  • SivaYenduri's avatar
    SivaYenduri
    Icon for Cirrus rankCirrus
    Dec 19, 2019

    Hello Guys,

     

    I tried this command in v12.1,5 but didn't work. I replaced "awk" with "grep". It is executing the command without any error but not creating the output file. Can someone help?

     

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

    Display all 133 items? (y/n) y

    hostname(/Common)(tmos)#

     

  • 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

  • VGF5's avatar
    VGF5
    Icon for Cumulonimbus rankCumulonimbus
    May 17, 2020

    Hi, I tried above script in v13 but I didn't any file with .csv

     

    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