View source for Export virtual machine name, folder, datastore and notes

This script will give you the virtual machine name, folder, datastore and notes as below and dump it to myreport.csv in c:\temp:

<pre>
Get-VM |
Select Name,
@{N="Datastore";E={[string]::Join(',',(Get-Datastore -Id $_.DatastoreIdList | Select -ExpandProperty Name))}},
@{N="Folder";E={$_.Folder.Name}},
@{N='Notes';E={$_.Notes.Replace("`n",'/')}} | export-csv c:\temp\myreport.csv
</pre>

Example output:
<pre style="color: silver; background: black; width: 800px">

Name            Datastore                           Folder                     Notes
----            ---------                           ------                     -----
Server01        iscsi_datastore01                   Domain controllers         Domain controler
Server02        fc_datastore01                      Misc servers               FTP Server
Server03        fc_datastore01                      UK servers                 Doc share

</pre>

[[Category:vmware]]
[[Category:vsphere]]
[[Category:esxi]]
[[Category:vcenter]]
[[Category:vcsa]]
[[Category:nfs]]
[[Category:scripts]]
‎<comments />