How can I export NSX Load Balancer config info?

[vmmed1]

I've been tasked with creating an spreadsheet of each of my 90 or so vservers/pools/app profiles.

It's pretty slow going opening each vServer and noting the info in a spreadsheet then grabbing

more details from the app profile section. Is there any way to just export this info out of NSX?

[bayupw · Accepted solution]

Hi Michael,

You can try to use REST API

or PowerNSX

[vmmed1]

Thank you. Is there any way the rest call can be done from a browser? I'm not familiar with

making restful api calls nor nsx shell. For the NSX shell do I first load Windows Power Shell

and then somehow add in additional commands?

[bayupw]

For REST API call, you can use REST API clients such as Postman, Firefox REST client or other REST client.

You can also use curl, python or VMware vRealize Orchestrator.

For more info on using NSX REST API see this guide: Automation Leveraging NSX REST API Guide

For PowerNSX, yes you would need Windows PowerShell and VMware PowerCLI

If you like to read a book, there is a good book/guide on using PowerNSX here: Automating NSX for vSphere with PowerNSX​

[vmmed1]

Thanks again.

[bayupw]

Hi Michael, I just read other post/reply from 2cool2touch and I think this method is much better for your case.

Try the NSX-PowerOps tool.

One of the function of the tool is to document load balancing information as shown below:

Below is a sample output 5_NSX-Edge-LB-2017-11-13-13-12.xlsx - Google Drive​ that document each LB detail configuration such as VIP name, VIP address, Pool Name, Pool Member, etc