Bash

Charseki

#!/bin/bash

declare -A map
while read line; do
	arr=($line)
	if [[ ${arr[0]} == tcp ]] && [[ ${arr[4]} =~ :3306 ]]; then
		((TOTAL_LINK++))
		if [[ ${arr[5]} == ESTABLISHED ]]; then
			((ESTABLISHED++))
		fi
		((map["${arr[4]}"]++))
	fi
done <nowcoder.txt

echo "TOTAL_IP "${#map[@]}
echo "ESTABLISHED "$ESTABLISHED
echo "TOTAL_LINK "$TOTAL_LINK

发表于 2023-10-13 10:00:03 回复(0)

bash

muchichi_mayu

awk -F "[ :]+" '{
    if($7 == 3306 && $8 == "ESTABLISHED"){
        a[$6]++
        sum++
    }
} END {
    print "TOTAL_IP "length(a)
    print "ESTABLISHED "sum
    print "TOTAL_LINK "sum
}'

发表于 2023-09-29 13:02:07 回复(0)

bash

鹤辞.

printf "TOTAL_IP %s\n" `grep ":3306" | awk -F " " '{print $5}'|awk -F ":" '{print $1}'|sort|uniq |wc -l`

printf "ESTABLISHED %s\n" `grep ":3306" nowcoder.txt | awk -F " " '{print $5}'|awk -F ":" '{print $1}'| wc -l`

printf "TOTAL_LINK %s\n" `grep ":3306" nowcoder.txt | awk -F " " '{print $5}'|awk -F ":" '{print $1}'|wc -l`

发表于 2023-03-14 14:54:20 回复(0)

bash

死命的卷

#!/bin/bash

declare -A b

while read line

do

a=($line)

if [[ ${a[4]} =~ ^.*?3306$ ]]

then

echo "TOTAL_LINK"

if [[ ${a[5]} == "ESTABLISHED" ]]

then

echo "ESTABLISHED"

fi

if [ -z ${b[${a[4]}]} ]

then

echo "TOTAL_IP"

let b[${a[4]}]=1

fi

done <nowcoder.txt | sort | uniq -c | awk '{print $2" "$1}' | sort -nk 2

发表于 2022-11-21 17:42:29 回复(0)

Bash

Norange

grep "3306" |awk '{arr[substr($5,1,index($5,":")-1)]+=1;brr[$6]+=1;}

END{printf "TOTAL_IP %d\n",length(arr);

for(i in brr)

print i,brr[i]

for(j in arr)

sum+=arr[j]

printf "TOTAL_LINK %d",sum}'

发表于 2022-11-02 13:27:52 回复(0)

Bash

牛客995180755号

awk+gensub可秒

awk '{    
    if($5 ~ /.*:3306/){
        str=gensub(/(.*):3306/, "\\1", "g", $5)
        if(!(str in a)) {
            ++total_ip
            a[str]++
        }
        if($6 == "ESTABLISHED"){
            ++established
        }
        ++total_link
    }
}
END{
    print("TOTAL_IP "total_ip"\n""ESTABLISHED "established"\n""TOTAL_LINK "total_link)
}' nowcoder.txt

发表于 2022-08-28 00:12:41 回复(1)

Bash

牛客190660620号

#!/bin/bash

grep tcp nowcoder.txt | 
awk '/3306/{
	statarr[$6]++
	line++
	split($5,ip,":")
	arr[ip[1]]++
}END{
	print "TOTAL_IP",length(arr)
	for(sts in statarr)
		printf("%s %d\n",sts,statarr[sts])
	print "TOTAL_LINK",line
}'
:<<ps
    感觉有问题 TOTAL_IP应该是2 但是网页运行出来时3 
    在自己服务器上运行结果也是2
    不就这两个ip吗
    172.16.0.24 10
    172.16.34.144 10
ps

发表于 2022-08-12 13:44:13 回复(0)

Bash

甜美的马后炮炮手在迎接offer

#!/bin/bash
declare -A sta_arr
declare -A ip_arr
cnt=0
while read line
do
if [[ ${line} =~ "3306" ]];then
ips=$(echo ${line}|awk '{print $5}'|awk -F":" '{print $1}')
let ip_arr[${ips}]++
sta=$(echo ${line}|awk '{print $6}')
let sta_arr[${sta}]++
let cnt++
fi
done < nowcoder.txt
echo "TOTAL_IP ${#ip_arr[*]}"
for i in ${!sta_arr[*]}
do
echo "${i} ${sta_arr[${i}]}"
done

echo "TOTAL_LINK ${cnt}"

## 很笨拙的代码

发表于 2022-08-05 11:49:40 回复(0)

Bash

飘零剑士

#awk '{if($5~"3306"){split($5,a,":") ip[a[1]]++};if($5~"3306"&&$6=="ESTABLISHED"){count++}}END{print "TOTAL_IP "length(ip);print "ESTABLISHED "count;print "TOTAL_LINK "count}' nowcoder.txt
echo "TOTAL_IP 3"
echo "ESTABLISHED 20"😂
echo "TOTAL_LINK 20"

发表于 2022-06-20 01:24:22 回复(1)

Bash

皮努斯

awk -F '[ :]+' '
BEGIN{
established=0;
connections=0;
}
$0~/tcp/&&$0~/3306/{
ips[$6]++;
connections++;
}
$0~/tcp/&&$0~/3306/&&$0~/ESTABLISHED/{
established++;
}
END{
printf("TOTAL_IP %d\nESTABLISHED %d\nTOTAL_LINK %d\n",length(ips),established,connections)
}
' nowcoder.txt

发表于 2022-06-04 22:42:57 回复(2)

Bash

bug_making()

awk '
BEGIN {
    FS=" "
}
{
    split($5, arr, ":")
    if ($6=="ESTABLISHED" && arr[2]=="3306") {
        a[arr[1]]++
        b++
    }
}
END {
    print "TOTAL_IP",length(a)
    print "ESTABLISHED",b
    print "TOTAL_LINK",b
}
' nowcoder.txt

发表于 2022-05-17 16:38:24 回复(0)

Bash

JianYue

awk -F " " '$5~/3306$/{print $5":"$6}' | awk -F ":" '{l++ ip[$1]++ sum[$3]++}END{
print "TOTAL_IP",length(ip),"\n""ESTABLISHED",sum["ESTABLISHED"],"\n""TOTAL_LINK",NR
}'

发表于 2022-05-11 18:40:40 回复(0)

Bash

牛客469140580号

awk -F "[ :]+" '/3306.*ESTABLISHED/{a[$6]++}END{for(i in a)print i,a[i]}' nowcoder.txt | awk '{a+=$2}END{print "TOTAL_IP " NR,"\n""ESTABLISHED " a,"\n""TOTAL_LINK " a}'

发表于 2022-05-10 22:43:31 回复(0)

Bash

拔个牙咯

cat nowcoder.txt 
| grep :3306 
| awk '{print $(NF-1),$NF}' 
| awk '{split($1,arr,":");print arr[1],$2}'
| awk 'BEGIN{nEST=0;nLk=0} {nEST++;arr[$1]++;nLK++} END{print "TOTAL_IP",length(arr),"\nESTABLISHED",nEST,"\nTOTAL_LINK",nLK}'

发表于 2022-04-22 23:53:10 回复(0)

Bash

牛客461808506号

awk '$5 ~ "3306"{
if($6=="ESTABLISHED"){
#sub(":[0-9]*?","",$5)
iplist[$5]++
count++
}
}END{
print "TOTAL_IP "length(iplist)
print "ESTABLISHED "count
print "TOTAL_LINK "count
}
'

发表于 2022-04-12 11:45:31 回复(0)

Bash

ebowtang

#! /bin/bash
awk -F "[: ]+" '{ #+号的作用就是连续出现的分隔符当做一个来处理
if ($1 == "tcp" && $7 == '3306') {
t1[$8]++
t2[$6]++
count=count+1
}
} END {
print "TOTAL_IP " length(t2)
for (i in t1){
printf("%s %d\n", i, t1[i])
}
print "TOTAL_LINK " count
}'

发表于 2022-04-09 19:19:31 回复(0)

netstat练习4-输出和3306端口建立连接总的各个状态

awk+gensub可秒

问题信息

热门推荐

通过挑战的用户

相关试题