Select-Object with output from 2 cmdlets

Question

Suppose I have the following PowerShell script:

Get-WmiObject -Class Win32_Service | 
Select DisplayName,@{Name="PID";Expression={$_.ProcessID}} |
Get-Process |
Select Name,CPU

This will:

Line 1: Get all services on the local machine

Line 2: Create a new object with the DisplayName and PID.

Line 3: Call Get-Process for information about each of the services.

Line 4: Create a new object with the Process Name and CPU usage.

However, in Line 4 I want to also have the DisplayName that I obtained in Line 2 - is this possible?

Bill_Stewart · Accepted Answer · 2013-08-15 14:49:36Z

4

One way to do this is to output a custom object after collecting the properties you want. Example:

Get-WmiObject -Class Win32_Service | foreach-object {
  $displayName = $_.DisplayName
  $processID = $_.ProcessID
  $process = Get-Process -Id $processID
  new-object PSObject -property @{
    "DisplayName" = $displayName
    "Name" = $process.Name
    "CPU" = $process.CPU
  }
}

answered Aug 15, 2013 at 14:49

Bill_Stewart

24.9k5 gold badges55 silver badges70 bronze badges

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

Comments

dugas · Accepted Answer · 2013-08-15 15:45:55Z

2

A couple of other ways to achieve this:

Add a note property to the object returned by Get-Process:

Get-WmiObject -Class Win32_Service | 
Select DisplayName,@{Name="PID";Expression={$_.ProcessID}} |
% {
    $displayName = $_.DisplayName;
    $gp = Get-Process;
    $gp | Add-Member -type NoteProperty -name DisplayName -value $displayName;
    Write-Output $gp
} |
Select DisplayName, Name,CPU

Set a script scoped variable at one point in the pipeline, and use it at a later point in the pipeline:

Get-WmiObject -Class Win32_Service | 
Select @{n='DisplayName';e={($script:displayName =  $_.DisplayName)}},
       @{Name="PID";Expression={$_.ProcessID}} |
Get-Process |
Select @{n='DisplayName';e={$script:displayName}}, Name,CPU

edited Aug 15, 2013 at 15:45

answered Aug 15, 2013 at 15:27

dugas

12.6k3 gold badges48 silver badges54 bronze badges

1 Comment

RB. Over a year ago

+1 for the note property - I think it's more elegant when working with an object that already has a lot of properties you are interested in.

js2010 · Accepted Answer · 2018-02-06 18:49:58Z

0

Using a pipelinevariable:

Get-CimInstance -ClassName Win32_Service -PipelineVariable service | 
Select @{Name="PID";Expression={$_.ProcessID}} |
Get-Process |
Select Name,CPU,@{Name='DisplayName';Expression={$service.DisplayName}}

edited Feb 6, 2018 at 18:49

answered Feb 6, 2018 at 15:37

js2010

28.3k6 gold badges82 silver badges87 bronze badges

Collectives™ on Stack Overflow

Select-Object with output from 2 cmdlets

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related