Script to pull settings from VM's

[vmscox]

I am curious if anyone has made a script that would produce a report with all the settings for all the VM's in a cluster/host, etc.  I would need every setting (datastore (full path) VM hardware version, CPU, memory, etc.) needed to recreate a new VM but point it back to the original VM's disks).  I would prefer the report to be in CSV format.  Is there anything like this out there?

Thank you for any help.

Sean

[vin01]

YYou can try this one..

Complete VM information

‌

[vmscox]

Looks good so far, how do I get this into a CSV?

[MCioe]

Look up export-csv

from Microsoft Tech Net:

Using the Export-Csv Cmdlet 

[vmscox]

I'm familiar with the command but given how this script is written and displays the output I'm not sure where to add it to get all the data or even if I could use it in this script.

[vin01]

‌save the script in .ps1 format..try as below

for example vminfo.ps1

execute like this

vminfo.ps1 |export-csv -path 'c:\vminformat.csv' -notypeinformation -noclobber

[75109]

Why not use rvtools. It will pull that plus all kinds of other useful information. It will come out in excel or csv and it's free.

You can run it as a scheduled task and have it email you.

robware.net

[MCioe]

You could also look at how to export a hash table to export-csv. There are some solutions out there.

Hashtable export-csv format output - PowerShell.com – PowerShell Scripts, Tips, Forums, and Resource...