How to use Where-Object in .NET PowerShell Automation?

Question

I have this pipeline, which works in a PowerShell console:

Get-NetIPConfiguration | Where-Object { $_.IPv4DefaultGateway -ne $null -and $_.NetAdapter.Status -ne 'Disconnected' }

However, when I attempt it in .NET using System.Management.Automation it fails with this exception:

System.Management.Automation.CommandNotFoundException
  HResult=0x80131501
  Message=The term 'Where-Object { $_.IPv4DefaultGateway -ne $null -and $_.NetAdapter.Status -ne 'Disconnected' }' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
  Source=System.Management.Automation
  StackTrace:
   at System.Management.Automation.Runspaces.PipelineBase.Invoke(IEnumerable input)
   at System.Management.Automation.Runspaces.Pipeline.Invoke()
   at Duplexer.PowerShell.Engine.ExecutePipeline(PSCommand Command) in D:\Dev\Projects\Duplexer\Duplexer\Code\PowerShell\Engine.vb:line 80
   at Duplexer.Main.GetSettings() in D:\Dev\Projects\Duplexer\Duplexer\Main.vb:line 84
   at Duplexer.Tests.PowerShellTests.Can_Get_NIC_Settings() in D:\Dev\Projects\Duplexer\Duplexer.Tests\PowerShellTests.vb:line 6

Here's my .NET code:

Public Sub GetSettings()
  Dim oPipeline As PSCommand
  Dim oResult As Collection(Of PSObject)

  oPipeline = New PSCommand
  oPipeline.
    AddCommand(PowerShell.Commands.GetNetIPConfiguration).
    AddCommand(PowerShell.Commands.WhereObject & " { $_.IPv4DefaultGateway -ne $null -and $_.NetAdapter.Status -ne 'Disconnected' }")

  Using oPowerShell As New PowerShell.Engine
    oPowerShell.ImportModules(PowerShell.Modules.NetAdapter, PowerShell.Modules.NetTCPIP)
    oResult = oPowerShell.ExecutePipeline(oPipeline)
  End Using
End Sub

How do I configure this PowerShell command for use in .NET Automation?

Mathias R. Jessen · Accepted Answer · 2021-08-10 08:39:06Z

2

You need to provide the parameter argument (the scriptblock following Where-Object) separately. Change this line:

AddCommand(PowerShell.Commands.WhereObject & " { $_.IPv4DefaultGateway -ne $null -and $_.NetAdapter.Status -ne 'Disconnected' }")

to:

AddCommand(PowerShell.Commands.WhereObject).
AddArgument(ScriptBlock.Create("$_.IPv4DefaultGateway -ne $null -and $_.NetAdapter.Status -ne 'Disconnected'"))

answered Aug 10, 2021 at 8:39

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

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

2 Comments

InteXX Over a year ago

Works perfectly, thank you. Are you aware of any official documentation on .NET PowerShell Automation? I looked, but apparently I wasn't looking in the right place.

InteXX Over a year ago

Oops, never mind. I just found it: learn.microsoft.com/en-us/dotnet/api/…

Collectives™ on Stack Overflow

How to use Where-Object in .NET PowerShell Automation?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related