- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
| name | Location | Owner |
|---|---|---|
| Hostname1 | NY | Bob |
| hostname2 | LA | Joe |
| hostname3 | DC | Bill |
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!