Need Help with Report

[lledarby]

I'm trying to create a report that shows Name, Powerstate and ToolsVersion.  I've tried the following syntax but i get a blank record for PowerState:

Get-VM | Get-View | Select-Object Name, @{N="PowerState"; E={$_.PowerState}}, @{N="ToolsVersion"; E={$_.config.tools.toolsVersion}}

Any assistance would be appreciated

[LucD · Accepted solution]

Try it like this

Get-VM  |
Select-Object Name, @{N="PowerState"; E={$_.PowerState}}, @{N="ToolsVersion"; E={$_.Extensiondata.config.tools.toolsVersion}}

Or even simpler, like this

Get-VM  |
Select-Object Name, PowerState, @{N="ToolsVersion"; E={$_.Extensiondata.config.tools.toolsVersion}}

[RvdNieuwendijk]

You can also do it like this for optimal performance:

Get-View -ViewType VirtualMachine -Filter @{"Config.Template"="False"} -Property Name,RunTime.PowerState,Config.Tools.toolsVersion | `
Select-Object Name, @{N="PowerState"; E={$_.RunTime.PowerState}}, @{N="ToolsVersion"; E={$_.Config.Tools.toolsVersion}}

Regards, Robert

[lledarby]

Thanks!  This worked fast as well!

[lledarby]

Thank you so much!