Reporting and Documentation on Current VMware environment

[VMwareGuy121211]

Looking for the best way to export settings of each VM in my Vsphere.

I already know how to Export the info using the export button on the webclient but that doesnt give me all the info I am looking for.

In case of a major problem,  I would like to have a reference document to look back at how all my VMs were setup.

Currently we manually update a spread sheet that has all of the Vmware settings. 

I would like to be able to export the current configuration of each VM into an excel spread sheet of some other form that is easily readable if needed.

Such as all of the VMware settings under the VM Hardware tab.  Like CPU, Memory, Hard Disk1, Hard Disk2, (where is shows what datastore they are using) What Network adapter they have and what VLans they are connected to.  Is there an easy way to export this information?  I have looked at RVtools but that doesnt give me this information and if it does, it is very convoluted.

Any VSphere experts out there, Please help.  Here is a picture of the area I am looking to export for each VM.

[Deso1ator]

Check out RVTools.

https://www.robware.net/rvtools/

[VMwareGuy121211]

I have used RVtools,  It doesnt really give me info that I would use to rebuild the VM.  It gives me much of the same info as exporting the data from VSphere.

[sjesse]

Take a look at

GitHub - tpcarman/As-Built-Report: A collection of PowerShell scripts to generate as built reports o...

there is a vsphere version that gets almost everything I believe.

[VMwareGuy121211]

So I tried RVtools again and used excel to create pivot tables and slicers.  This enabled me to quickly find the information I need if I were to need to rebuild a VM.

The problem is I will have to run this periodically in order to get the latest info and then recreate the pivot tables and slicers everytime.  Do you know if you run the RVtools and save over the same file if it would then update the tables?

[scott28tt]

I'm thinking PowerCLI and pipe the results to a CSV