VMname, Power status and Guest OS

[Gaprofitt17]

How would I add Power status on this, and specify I only want powered on VM's in the report?

Get-VM | Sort | Get-View -Property @("Name", "Config.GuestFullName", "Guest.GuestFullName") | Select -Property Name, @{N="Configured OS";E={$_.Config.GuestFullName}},  @{N="Running OS";E={$_.Guest.GuestFullName}} | Export-CSV

[LucD · Accepted solution]

Try something like this

$sView = @{

    ViewType = 'VirtualMachine'

    Property = 'Name','Config.GuestFullName','Guest.GuestFullName','Runtime.PowerState'

    Filter = @{'Runtime.PowerState'='poweredOn'}

}

Get-View @sView |

Select -Property Name,

    @{N='PowerState';E={$_.Runtime.PowerState}},

    @{N="Configured OS";E={$_.Config.GuestFullName}},

    @{N="Running OS";E={$_.Guest.GuestFullName}} |

Export-CSV -Path .\report.csv -NoTypeInformation -UseCulture

[Gaprofitt17]

Thanks LucD.. Much appreciated!