TheVMinator
Expert
Expert

Join VM info with external info

I need to take an existing spreadsheet with a list of VM names, merge information from vCenter with it, and create a new csv that I can open in Excel.

For example, my existing spreadsheet looks like this:

nameLocationOwner
Hostname1NYBob
hostname2LAJoe
hostname3DCBill

then, I have powercli script that does this:

get-vm | select name, numcpu, memoryGB

The "Name" field in my spreadsheet is equivalent to the "name" field in vCenter.  How can I create a csv that has the info both from vCenter and the spreadsheet for each VM?

Thanks!

Reply
0 Kudos