Automatic content export to CSV file

[TomKristenHanse]

I have the need to do an content export to CSV file of our environment every month (nodes, hosts & clusters), to keep track on usage.

Is there a way to do this automatically, eventually command line access from an Linux host? As for now I have to do this manually every

month via vSpere web client, which is a bit too much manually..

To information, I do not have administrator rights, but only operator access in our wmware environment.

[Alex_Romeo]

Hi,

you can follow this article which explains well how to proceed:

• Using PowerCLI to Export Virtual Machine Inventory to CSV - The ID10T Manual
• https://www.binbert.com/blog/2011/12/export-the-list-of-virtual-machines-to-a-csv-file/

Here it shows much more than what you need, but you can limit yourself to what you need.

ARomeo

P.S: “get-vm” and “Select-Object”

[TomKristenHanse]

ARomeo,

Thanks a lot for you guidance!

Do you know if there are an Unix/Linux alternative?

My scope is to set up an automated inventory dump from vmware to feed into a central inventory base..

/Tom Kristen

[KabirAli82]

I would recommend you Alan Renoufs vCheck;

http://www.virtu-al.net/vcheck-pluginsheaders/vcheck/

GitHub - alanrenouf/vCheck-vSphere: vCheck Daily Report for vSphere

Its not Unix/Linux based tho...

[sjesse]

Look at this, I recently only became aware of it as well, its not a csv but provideds a pretty comprehensive report of how things are setup

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

[sjesse]

You can install powercli in linux