awk基础-做次数统计

次数统计

如下文件内容：

portmapper
portmapper
portmapper
portmapper
portmapper
portmapper
status
status
mountd
mountd
mountd
mountd
mountd
mountd
nfs
nfs
nfs_acl
nfs
nfs
nfs_acl
nlockmgr
nlockmgr
nlockmgr
nlockmgr
nlockmgr

用awk统计每行数据出现的次数：

awk '{a[$0]++}END{for(i in a){print a[i],i}}' a.txt

输出结果：

4 nfs
2 status
5 nlockmgr
6 portmapper
2 nfs_acl
6 mountd

统计TCP连接状态数量

$ netstat -tnap
Proto Recv-Q Send-Q Local Address   Foreign Address  State       PID/Program name
tcp        0      0 0.0.0.0:22      0.0.0.0:*        LISTEN      1139/sshd
tcp        0      0 127.0.0.1:25    0.0.0.0:*        LISTEN      2285/master
tcp        0     96 192.168.2.17:22 192.168.2.1:2468 ESTABLISHED 87463/sshd: root@pt
tcp        0      0 192.168.2017:22 192.168.201:5821 ESTABLISHED 89359/sshd: root@no
tcp6       0      0 :::3306         :::*             LISTEN      2289/mysqld
tcp6       0      0 :::22           :::*             LISTEN      1139/sshd
tcp6       0      0 ::1:25          :::*             LISTEN      2285/master

统计得到的结果：

5: LISTEN
2: ESTABLISHED

netstat -tnap |\
awk '
  /^tcp/{arr[$6]++}
  END{
    for(state in arr){
      print arr[state] ": " state
    }
  }
'

一行式：

netstat -tna | awk '/^tcp/{a[$6]++}END{for(s in a){print a[s] ": " s}}'
netstat -tna | grep 'tcp' | awk '{print $6}' | sort | uniq -c