题解 | #查看和3306端口建立的连接#
netstat练习2-查看和3306端口建立的连接
https://www.nowcoder.com/practice/534b95941ffb495b9ba57fbfc3cd723a
1. grep查找，awk分割两次，排序，计数，排序，打印
grep '3306.*ESTABLISHED' nowcoder.txt | awk '{print $5}' | awk -F ':' '{print $1}' | sort | uniq -c | sort -nr | awk '{print $1, $2}'
2. grep查找，awk分割，sed将:3306替换为空，排序，计数，排序，打印
grep '3306.*ESTABLISHED' nowcoder.txt | awk '{print $5}' | sed 's/:3306//g' | sort | uniq -c | sort -nr | awk '{print $1, $2}'
3. awk查找，分割两次，排序，计数，排序，打印
awk '/3306.*ESTABLISHED/ {print $5}' nowcoder.txt | awk -F ':' '{print $1}' | sort | uniq -c | sort -nr | awk '{print $1, $2}'
4. awk查找，分割，sed将:3306替换为空，排序，计数，排序，打印
awk '/3306.*ESTABLISHED/ {print $5}' nowcoder.txt | sed 's/:3306//g' | sort | uniq -c | sort -nr | awk '{print $1, $2}'
5. awk查找，substr子串，排序，计数，排序，打印
awk '/3306.*ESTABLISHED/ {print substr($5, 0, length($5) - 5)}' nowcoder.txt | sort | uniq -c | sort -nr | awk '{print $1, $2}'
北京云智软通信息技术有限公司西安分公司一面13人在聊