PowerShell: Return $PSItem/$_ Looked up Within a ForEach-Object Script Block

Question

I've been working on this problem in my personal time for days now...

I need to add a column to the results (Example issue. The code below will eventually error out. [I was just using -Include to test on a single row. My real-world problem uses a different cmdlet, but the same premise).

How do I get what the query was ran for to show up in the resulting table?

 ForEach-Object {Get-Service $_.name -DependentServices}

What I need it to look like.

Status	Name	DisplayName	Parent Name
Stopped	workfolderssvc	Work Folders	WSearch
Stopped	WMPNetworkSvc	Windows Media Player Network Sharin...	WSearch
Stopped	AarSvc_51453	Agent Activation Runtime_51453	AudioEndpointBuilder
Stopped	AarSvc	Agent Activation Runtime	AudioEndpointBuilder
Running	Audiosrv	Windows Audio	AudioEndpointBuilder

What the query returns: Status, Name, DisplayName

What I need the query to return: Status, Name, DisplayName, Parent Name

I've tried $row, making a new array by piping through to Select-Object within my Script block, and wrapping $_ in [ $_ ], " $_ ", or "[$_]".

| Select-Object Status, Name, DisplayName,  [PSCustomObject]@{Name="Parent Name";Expression={$_.name}}

I'm using Powershell 5.1.

Thank you.

Sage Pourpre · Accepted Answer · 2022-03-07 04:12:51Z

0

Assuming that by "Parent name", you mean that you want the services that the current service depends upon to be running, then you would do it the following way.

ServicesDependedOn is an array, so it might output more than one result.

Get-Service -DependentServices | Select-Object Status, Name, DisplayName,  @{Name="Parent Name";Expression={$_.ServicesDependedOn}} | Sort Name

You were nearly there, but the calculated property take a hashtable, not a PSCustomObject. Also, if you use $_.Name as the expression, you will just repeat the Name value you already selected so you need to target the expression you want as a value instead.

References

ServiceController class

About Calculated properties (PS 5.1)

answered Mar 7, 2022 at 4:12

Sage Pourpre

10.4k3 gold badges30 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

PowerShell: Return $PSItem/$_ Looked up Within a ForEach-Object Script Block

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related