List ESX HostName and datastores

[AGFlora]

HI

Does anyone have a script to list the host name and all datstores that the host is using?

[TheVMinator]

get-vmhost | get-datastore

[TheVMinator]

or you could add:

get-vmhost -name esxihostname | get-datastore

[AGFlora]

how could i import a list of host names and export the output to a csv file?

Thanks

[TheVMinator]

import-csv -path c:\filepath\filename.csv | %{get-vmhost -name $_.name} | get-datastore | export-csv -path "c:\somepath\somefilename.csv" -notypeinformation -useculture

[AGFlora]

I'm getting the following error:

"Get-VMHost : Cannot validate argument on parameter 'Name'. The argument is null

or empty. Supply an argument that is not null or empty and then try the comman

d again.

At Test\ESX\Get-ESX-DS.ps1:17 char:42

+ import-csv hosts.csv | %{get-vmhost -name <<<<  $_.name} | get-datastore | ex

port-csv ESX-Datastore.csv -notypeinformation -useculture

    + CategoryInfo          : InvalidData: (:) [Get-VMHost], ParameterBindingV

   alidationException

    + FullyQualifiedErrorId : ParameterArgumentValidationError,VMware.VimAutom

ation.ViCore.Cmdlets.Commands.

GetVMHost"

[TheVMinator]

I think this has to do with how your Csv is formatted. In the first row of your Csv try putting the word name so it knows that this column should be associated with the $._name statement.

I.e.:

"Name"

"Esxihost1"

"Esxihost2"

[AGFlora]

That was it. Everything works except the host name is not being populated in the csv output file.

[TheVMinator]

It seems like you want to list each ESXi host, and then all of the datastores that are attached to that host.  Here is another approach that does that:

import-csv -path c:\filepath\filename.csv | %{get-vmhost -name $_.name}

| select @{N="Name";E={$.name + ","}},@{N="Datastores";E={get-datastore -relatedobject $_ | %{$_.name + "," }}} | export-csv c:\datastores.csv -notypeinformation -useculture