If you are looking a way to document membership of VMs in Security Groups and its IP addresses, you can reuse this PowerNSX scriptBayu Wibowo | vExpert NSX, VCIX6-DCV/NV, Cisco Champion, AWS-SAA
Author of VMware NSX Cookbook http://bit.ly/NSXCookbook
https://nz.linkedin.com/in/bayupw | twitter @bayupw
1 person found this helpful
You can do this with 1 line using PowerNSX
Get-NsxSecurityGroup -Name blah | Get-NsxSecurityGroupEffectiveIpAddress
This is a fair answer, but I find when using this pipeline I only get 4 results - so for instance I have a security group with 6 ipsets - any ideas how I can show all 6? I.e. a complete listing?
check out the nsx-powerops
The excel creation is better than the original one posted (it was amalgamated)
I wrote a function in powershell that uses an encryption key (saved in a locked down directory specific to the user running it) to decrypt encrypted usernames and passwords to pass into credential objects which make the neccesary connection calls to nsx/vmware - as I found the excel (which is great dont get me wrong) a little boring to wait to complete. so just schedule it an let it do it's thing.