Need help with Powershell script to query for # of "Established Connections" on monitored servers

Hello,

My apologies, I am struggling with this one, I am not experienced with Powershell scripting, and I can't find another way to obtain a count of "Established Connections" a monitored server has. The end goal is to have a time chart with this count over a period of time.

So I found a basic Poweshell command that performs a Get-NetTCPConnection, but I'm not sure what all should be modified to add the Server name that I need to point this script too.

Get-NetTCPConnection | Where-Object { $_.RemotePort -eq '1433' -and $_.State -eq 'ESTABLISHED' }).count

Also, I don't want to filter on a specific Port, I need the full count of established connections.

Second question is where would I place the credentials at in this command? Sorry again that I am way behind in my Powershell knowledge.

Could anyone please help me out on how I can achieve this?

Thank you very much,

Tom

Find more posts tagged with

sam

powershell script monitor

powershell script

powershell scripting

PowerShell

Accepted answers

All comments

cnorborg

I thought SAM did this? I don't have it anymore, anyone know?

mesverrum

You should be able to just remove the remoteport stuff from the where. This command runs as the current user on the system, so you don't pass it credentials anywhere. You do need to pay attention to the SAM setting for powershell scripts where it asks if you want to do local or remote execution, because local mode would mean it runs that command on your polling engine, which is probably not what you want. Remote means SW will open a session to the server using the cred you set (this is outside the script) and it will execute whatever is in the script as that user.