PowerCLI script to get all VMs on specific datastores

PowerCLI script to get all VMs on specific datastores

Connect-VIServer vcenterserver

$report=@()

$ds = Get-Content C:\Temp\dslist.txt

foreach($d in $ds)

{

    $row = "" | select DatastoreName,Version,VMList

    $row.DatastoreName=$d.Name

    $row.Version=$d.FileSystemVersion

    $row.VMList= (Get-Datastore $d | Get-VM) -join ','

    $report += $row

}

$report | Sort DatastoreName | Export-Csv C:\Temp\GetVMonDS.csv -NoTypeInformation

Disconnect-VIServer vcenterserver -Confirm:$false