Component Report for TCP Usage Count

martian_monster

Hello Everyone -

I have not done any reporting for awhile in Solarwinds so the gears are a bit rusty.  I am hoping someone can point me in the right direction. 

I setup a SAM monitor for TCP Port Usage Count for nodes because we have a few that keep running into Port Exhaustion issues.  I used the 'out of the box' Power Shell TCP Port monitor for this and was hoping to have it generate a report of TCP ports used for a specific node. 

Not sure if I can do this or not but wanted to ask to see if someone can point me in the right direction.

Thanks -Dave

SteveK

Here is what I use.

I ended up breaking it down so I got a total count, as well as the various states.  You may want to add an exclusion in for your primary server and/or sw database server as those can be pretty heavy on the port count.  This can be done by modifying the $HighUtilization variable.

This won't give you a list of every node and their usage, but it will tell you anything utilizing more than 200 (which can always be modified)

#Retrieve TCP Connections
    Try {
        $TCPConnections = Get-NetTCPConnection -ErrorAction Stop
    } Catch {
    Exit 1
    }

#Group Connections
            $HostSummary = $TCPConnections |  Group-Object -Property RemoteAddress | Select-Object Name,Count | Sort-Object -Property Count -Descending
#Determine High utilization IPs
    $HighUtilization = $HostSummary | Where-Object {($_.Count -gt 200) -and ($_.Name -notlike "*::*") -and ($_.Name -ne "0.0.0.0") -and ($_.Name -notlike "127.0.0.1")}
#Formats data for Message
    $UtilizationArray = [System.Collections.ArrayList]@()
    ForEach ($HighUtilizationHost in $HighUtilization) {
    $UtilizationArray.Add(("IP: $($HighUtilizationHost.Name),Count: $($HighUtilizationHost.Count)")) | Out-Null
    }

#Output
    #Total
        Write-Host "Statistic.Total:  $(($TCPConnections | Measure-Object).Count)"
        Write-Host "Message.Total:  Currently $(($TCPConnections | Measure-Object).Count) connections open"
    #High Utilzation
        Write-host "Statistic.HighUtilizationHosts: $(($HighUtilization | Measure-Object).Count)"
        Switch ([String]::IsNullOrEmpty($UtilizationArray)) {
            "TRUE" {#No systems tripped high utilization
                Write-Host "Message.HighUtilizationHosts: No systems exceeding 200 connections"
            }
            "FALSE" {#Systems exceeded threshold
                Write-Host "Message.HighUtilizationHosts: The following systems are showing high connenections $($UtilizationArray -join "-")"
            }
        }
    #States
        Write-Host "Statistic.ConnectionEstablished:  $(($TCPConnections | Where-Object {$_.State -eq "Established"} | Measure-Object).count)"
        Write-Host "Statistic.ConnectionTimeWait:  $(($TCPConnections | Where-Object {$_.State -eq "TimeWait"} | Measure-Object).count)"
        Write-Host "Statistic.ConnectionSynSent:  $(($TCPConnections | Where-Object {$_.State -eq "SynSent"} | Measure-Object).count)"
        Write-Host "Statistic.ConnectionBound:  $(($TCPConnections | Where-Object {$_.State -eq "Bound"} | Measure-Object).count)"
        Write-Host "Statistic.ConnectionClosed:  $(($TCPConnections | Where-Object {$_.State -eq "Closed"} | Measure-Object).count)"
        Write-Host "Statistic.ConnectionCloseWait:  $(($TCPConnections | Where-Object {$_.State -eq "CloseWait"} | Measure-Object).count)"
        Write-Host "Statistic.ConnectionClosing:  $(($TCPConnections | Where-Object {$_.State -eq "Closing"} | Measure-Object).count)"
        Write-Host "Statistic.ConnectionDeleteTCB:  $(($TCPConnections | Where-Object {$_.State -eq "DeleteTCB"} | Measure-Object).count)"
        Write-Host "Statistic.ConnectionFinWait:  $(($TCPConnections | Where-Object {$_.State -like "FinWait*"} | Measure-Object).count)"
        Write-Host "Statistic.ConnectionLastAck:  $(($TCPConnections | Where-Object {$_.State -eq "LastAck"} | Measure-Object).count)"
        Write-Host "Statistic.ConnectionListen:  $(($TCPConnections | Where-Object {$_.State -eq "Listen"} | Measure-Object).count)"
        Write-Host "Statistic.ConnectionSynReceived:  $(($TCPConnections | Where-Object {$_.State -eq "SynReceived"} | Measure-Object).count)"

#Exit Script
    Exit 0