PowerShell established TCP connections

PowerShell commands:

Get-NetTCPConnection -State Established

Get-NetTCPConnection -State Established | Where {$_.RemoteAddress -ne "127.0.0.1"} | Select -Uniq -Property LocalAddress,RemoteAddress,RemotePort,@{expression={(Get-Process -Id $_.OwningProcess).Name}}

Get-NetTCPConnection -State Established | Where {$_.RemoteAddress -ne "127.0.0.1"} | Select -Uniq -Property LocalAddress,RemoteAddress,RemotePort,@{expression={(Get-Process -Id $_.OwningProcess).Name}}|ft -Autosize -HideT

Create item:

system.run["{$PS_TCPCONN}"]

Create a macro {$PS_TCPCONN} with value:

PowerShell "Get-NetTCPConnection -State Established | Where {$_.RemoteAddress -ne '127.0.0.1'} | Select -Uniq -Property LocalAddress,RemoteAddress,RemotePort,@{expression={(Get-Process -Id $_.OwningProcess).Name}}|ft -Autosize -HideT"