Depending on the release of awk it could be:
#!/usr/bin/gawk -f { if ( ($NF) in stats ) { stats[$NF] = stats[$NF]+1; } else { stats[$NF]=1; } } END { for ( var in stats) { print var " = " stats[var]; } }
I saved the script as netstat_c.
I have to filter my netstat output to match only my tcp sockets prior to pipe the output to the script.
On linux:
$ netstat -a | grep ^tcp | netstat_c LISTEN = 13 ESTABLISHED = 74 TIME_WAIT = 7
This is great to check my webserver connections when I do stress tests.