How to use PowerShell Select-String to filter output based on multiple conditions?

Question

PowerShell

After all, PowerShell has Select-String, an analogue of grep from linux, but I can’t figure out its syntax in any way, how to use several conditions in it.
So I need to see what network connections are open with the "NETSTAT -ano -p TCP" command, but at the same time display only lines that include "ESTABLISHED" and exclude lines with "127.0.0.1:1433" and "10.10.10.5:80"

Answer 1

You can make multiple calls to Select-String in succession:

NETSTAT -ano -p TCP | Select-String 'established' | Select-String -NotMatch '127.0.0.1:1433','10.10.10.5:80'

Answer 2

using regex:

NETSTAT -ano -p TCP  | Select-String -pattern '^(?!.*?127\.0\.0\.1:1433\s|.*?10\.10\.10\.5:80\s).*ESTABLISHED'

Answer 3

You can write the information from this command first into a regular Array string,
$Info = NETSTAT -ano -p TCP
then convert it into a powershell object

$Info = $Info [3..$Info.count] | ConvertFrom-String | select p2,p3,p4,p5

after which you can already very conveniently manipulate the data as you want it. For example

$result = $Info  | Where-Object {$_.P5 -eq "ESTABLISHED" -and $_.P4 -eq "127.0.0.1:1433"}