List all powered on VMs and Host that it is running on

[hugop]

As subject.

Thanks!

Hugo

[LucD]

Something like this ?

Get-VM | where {$_.PowerState –eq "Poweredon"} | %{write-host $_.name $_.host.name}

[hugop]

How can I pipe it to csv file?

[LucD]

Something like.

$report = @()
Get-VM | where {$_.PowerState –eq "Poweredon"} | %{
  $row = "" | select VMname, HostName
  $row.VMName = $_.Name
  $row.HostName = $_.host.Name
  $report += $row
}
$report | Export-Csv "C:\report.csv" -noTypeInformation

[hugop]

error with @() Get-vm

PS C:\Program Files\VMware\Infrastructure\VIToolkitForWindows> $report = @() Get

-VM | where {$_.PowerState -eq "Poweredon"} | %{ $row = "" | select VMname, Host

Name $row.VMName = $_.Name $row.HostName = $_.host.Name $report += $row } $repor

t | Export-Csv "C:\report.csv" -noTypeInformation

Unexpected token 'Get-VM' in expression or statement.

At line:1 char:21

+ $report = @() Get-VM <<<< | where {$_.PowerState -eq "Poweredon"} | %{ $row

= "" | select VMname, HostName $row.VMName = $_.Name $row.HostName = $_.host.Na

me $report += $row } $report | Export-Csv "C:\report.csv" -noTypeInformation

PS C:\Program Files\VMware\Infrastructure\VIToolkitForWindows>

[LucD · Accepted solution]

The @#!&* forum SW dropped the new-lines (again).

Try the attached script.

[hugopeeters]

I was a bit surprized to see myself asking this question.

Turns out I have a "doppelganger". Hello Hugo!

Check out my website for more example scripts: www.peetersonline.nl

Hugo Peeters

[hugopeeters]

I was a bit surprized to see myself asking this question.

Turns out I have a "doppelganger". Hello Hugo!

Check out my website for more example scripts: www.peetersonline.nl

Hugo Peeters

[hugop]

"Any resemblance to actual persons, living or dead, is purely coincidental"

Yup, just started playing around with the VI Toolkit.