How to augment expression into select-object in Powershell?

Question

I have the following code which prints out some properties of each SQL Server related service on a host:

[reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.SqlWmiManagement")|Out-Null;
$mc = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer localhost;
$mc.Services | % {$_|select-object Name,DisplayName,ServiceState}

I want to output the result with the HostName appended. I've tried this:

$hostName = hostname
$mc.Services | % {$_|select-object Name,DisplayName,ServiceState,@{Name="HostName";Expression={$hostname}}

But I just get >> displayed. Any ideas on how to accomplish what I want?

CB. · Accepted Answer · 2013-09-25 08:52:28Z

4

I believe you are missing a }:

$hostName = hostname
$mc.Services | % {$_|select-object Name,DisplayName,ServiceState,@{Name="HostName";Expression={$hostname}}}

And you can do it without the foreach-object:

$mc.Services | select-object Name,DisplayName,ServiceState,@{Name="HostName";Expression={$hostname}}

answered Sep 25, 2013 at 8:52

CB.

61.3k9 gold badges170 silver badges165 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mark Allison Over a year ago

Thanks for the additional comment on select-object

Collectives™ on Stack Overflow

How to augment expression into select-object in Powershell?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related