十五年测试老手,长期负责WEB\APP 项目测试,目前主要负责团队管理工作。

统计APACHE ACCESS.LOG IP访问记录

上一篇 / 下一篇  2010-07-20 10:54:22 / 个人分类:其它

统计APACHE ACCESS.LOG IP访问记录
可以根据自己的需要,统计很多,每个IP访问多少个页面等等!

xcopy 哥哥的!

cat access.log-20090904 |awk '{print $3}'|sort|uniq -c|sort -rn|wc -l
51Testing软件测试网 gyk/V` X:O/k8o

详解:下面是一个例子:51Testing软件测试网;h(e GD(_

51Testing软件测试网!j ~B)z1Wbjj

cat 是读取这个文件。

7T8j*q,{?m3t051Testing软件测试网b`"HP4KkR

1147753394.079 2 220.139.141.61 TCP_DENIED/403 1354 CONNECT 222.124.24.93:25 - NONE/- text/html51Testing软件测试网6v2rxpN`b2p$Z0W
1147753395.652 0 61.228.130.169 TCP_DENIED/403 1352 CONNECT 203.84.195.1:25 - NONE/- text/html51Testing软件测试网 C _t H dP4qe0V)o
1147753395.754 0 61.228.135.187 TCP_DENIED/403 1350 CONNECT 203.86.1.30:25 - NONE/- text/html
,O.j5I P4x5_;P01147753398.042 3 61.228.131.15 TCP_DENIED/403 1354 CONNECT 81.169.162.54:25 - NONE/- text/html
0]UW2h2Gcb~zOM2X0
r'}\9]P4|wg0
op$GiW6Y0s051Testing软件测试网Fwi,Nl

51Testing软件测试网k BnA_,?4l$nS

awk '{print $3}' 是了日志的第三个字段

!f mfeR051Testing软件测试网2L@D F2I!@v } Y

220.139.141.6151Testing软件测试网 Ric!M&[Z Y
61.228.130.16951Testing软件测试网x:j8U-^%N.E)^p E-r
61.228.135.187
#MM n nrtU:D&w}061.228.131.15
%j s%[q o,k@rJ Z-M051Testing软件测试网&WW;Gr'i \ k X5M

p1r^/cM#T%k0

irBcIk)H,jd+u0[root@localhost~]# cat access.log | awk '{print $3}'51Testing软件测试网U9|Jo/@"H
220.139.141.6151Testing软件测试网5h[wt!G
61.228.130.169
i@e4L u+O061.228.135.187
5huQ2|o tFE _-k&Q061.228.131.1551Testing软件测试网Y:?Nv9P{7v
61.228.130.18751Testing软件测试网zy#rG:s
61.228.134.106
"F tyt&ZL [061.228.134.106
z4Tjg3ND,n*H061.228.134.106
?sRMx-Y&{6p061.228.134.106
+B [uH%m2MHU"`#Y061.228.134.9951Testing软件测试网4lkB,Y+xV
61.228.130.18751Testing软件测试网 l5m'mU5v,J0o!]
220.139.141.6151Testing软件测试网 bB;n;Q oZR H
61.228.130.16951Testing软件测试网6D]*pe5?2l:Yp
61.228.135.18751Testing软件测试网V)k ]{/O]N
61.228.131.1551Testing软件测试网~}{/|/_ i+L
61.228.130.187
f/Rp0O.O v4V?061.228.134.10651Testing软件测试网DEbkP0fZ$S
61.228.134.106
d!?B3]!|iLWt061.228.134.106
;BY#qPT Lg4A061.228.134.106
Z(Vf']3h P061.228.134.99
]+S*T-F2s]061.228.130.18751Testing软件测试网5[5]J+i$S3uK,Z
220.139.141.61
;l/VdwFg061.228.130.16951Testing软件测试网 u3a6|!m#G6p
61.228.135.187
)K:nL%zrQV({2d061.228.131.15
2D~r|&Y$G061.228.130.18751Testing软件测试网@x+X5k8_]._G1C"uJ
61.228.134.10651Testing软件测试网#S+Y'u/Mk#d
61.228.134.106
-DM%SS%e It'mj061.228.134.106
h0]*}X#n/Lu061.228.134.10651Testing软件测试网d K.[3H9O#S
61.228.134.9951Testing软件测试网:s-i5g2s7xY5i
220.139.141.6151Testing软件测试网 m;u1bS$T
61.228.130.16951Testing软件测试网7x P0P8sx|we4J }.U
61.228.135.18751Testing软件测试网[mrqiq6Ejn-];Z
61.228.131.1551Testing软件测试网:Ak` N![:~
61.228.130.187
k"Z3{R)d&qb{061.228.134.106
/c{eNh [%P1c061.228.134.106
F$uF/pL8h{%]4m:Q061.228.134.106
?&{p!cI{ h%Af061.228.134.106
]3B vBSY,t061.228.134.9951Testing软件测试网s?g4^*W ^$[%R"q MM
61.228.130.18751Testing软件测试网 R o-RMp9L8D
220.139.141.6151Testing软件测试网hcBq'_%}lzD
61.228.130.16951Testing软件测试网2v\c s:P x
61.228.135.187
's@ AV8qH_061.228.131.1551Testing软件测试网Ru.E;t.v2~n
61.228.130.18751Testing软件测试网s]W9~MJ$u
61.228.134.10651Testing软件测试网'qW/X6S-^%m%E
61.228.134.10651Testing软件测试网-C:m1sypa#R
61.228.134.106
.VrO&R(S0xR&OY2s1z#L061.228.134.106
(Agi9]8S.XI6W&H061.228.134.99
jJu5OO1ZsX061.228.130.18751Testing软件测试网3g#^\nY*j
220.139.141.61
L.I&g_N#C&Mi?061.228.130.16951Testing软件测试网 i`6ZM)O[nv
61.228.135.18751Testing软件测试网%mp6@ j"q m&E*`+u
61.228.131.1551Testing软件测试网t&x SVV
61.228.130.187
b]6du ['`8SCS _ I061.228.134.106
'Jbq*F }d;r061.228.134.10651Testing软件测试网fG1A S\ ]iqP
61.228.134.106
;Y:~%FL~q G061.228.134.10651Testing软件测试网7h0@+U\AI$b
61.228.134.9951Testing软件测试网/h`R yU hh
61.228.130.187

-X_5X f"`"Z$i'X!R0

J0vSv:D Y0sort是排序,51Testing软件测试网J9S]W+q

%KJz ba{0[root@localhost~]# cat access.log | awk '{print $3}'|sort
_ A&Y+}"DH8D0220.139.141.6151Testing软件测试网Hy|'~4s,T.YA*mK
220.139.141.6151Testing软件测试网1\a_V/F*}
220.139.141.6151Testing软件测试网(n)y/i,k1J y8[$X\
220.139.141.6151Testing软件测试网vf1{WfQ2{|4^u
220.139.141.6151Testing软件测试网3~i;^,U)A8SB;M
220.139.141.61
'ABb O.U061.228.130.169
Z5z'L^ ~ eoy}061.228.130.169
b&XNs1_&Y061.228.130.169
_ XH8`9QT'?*R _061.228.130.169
DSxu~x6iDy061.228.130.16951Testing软件测试网]Al-L c,}a
61.228.130.169
E*cTm8| i5C061.228.130.18751Testing软件测试网7S!qz/B(b} @d
61.228.130.18751Testing软件测试网9X1e} a"C
61.228.130.18751Testing软件测试网9DgX'Yi8Ou
61.228.130.187
;o"sI/`7b9W3s2g$V061.228.130.187
hy7O5B%E6|8l,C^061.228.130.187
(k-g,s B,~7i`9u3o061.228.130.18751Testing软件测试网F:N;Q%r-N`
61.228.130.18751Testing软件测试网 O|2o@;X.WX Nw I&v
61.228.130.18751Testing软件测试网5ekG_$l-T`k
61.228.130.18751Testing软件测试网ow!l6\^c!Vm/U
61.228.130.187
,tK9LH3g8uD061.228.130.18751Testing软件测试网Tt%r7R*w*s eg
61.228.131.1551Testing软件测试网l _h.I e,n
61.228.131.15
U4F*h2j|.n061.228.131.1551Testing软件测试网 H M(j*C/p
61.228.131.15
I"G&A6@7u@061.228.131.15
FDQK7P$l9eNr5y061.228.131.1551Testing软件测试网(q+]${%hO;V ~*T#C)S
61.228.134.10651Testing软件测试网)?cKBr&q Y6@#j
61.228.134.106
_"[X)C,c6w$k~061.228.134.106
CxfZJG*Vp6|/U9X061.228.134.106
t e-d1qH|0B:Pm7a061.228.134.10651Testing软件测试网4l3f s,R `3P f!F7B.boj
61.228.134.106
cHUc1s$x'Pc ]%L1t8i061.228.134.10651Testing软件测试网7^3DPeK|g(X/z
61.228.134.106
+Vk}4dI;Ry1OA9Qh061.228.134.106
E(xK-n v\3T061.228.134.10651Testing软件测试网Ib*t oU]
61.228.134.10651Testing软件测试网4F$s4Vk+I ?m
61.228.134.106
kn e Vl |R G C061.228.134.106
0u5B1wO ^Kd|WAW061.228.134.106
b%}&DO"Gled061.228.134.10651Testing软件测试网&b-C%@5m o4al
61.228.134.106
I| r!?1pYE0e1^061.228.134.106
(_hDrfX\!U2}061.228.134.106
q4sz-y;vV;j)?061.228.134.10651Testing软件测试网$h,qp;uAP
61.228.134.106
4\-l(o/l6g5A;YNj061.228.134.10651Testing软件测试网3J/v @(U&Xv,Q
61.228.134.10651Testing软件测试网 S}9@/qnK
61.228.134.10651Testing软件测试网^.ix,W R?#n/e
61.228.134.106
Yc$^A&r6L9C061.228.134.99
*pW9X`8w061.228.134.9951Testing软件测试网`X7[-?L
61.228.134.9951Testing软件测试网ny1N%Q6| j'z
61.228.134.99
"]gU\)E2F061.228.134.99
`-`#q ]n e+S061.228.134.99
:Sc"Pb5ESH4R061.228.135.18751Testing软件测试网6YO,U {N8Zvr
61.228.135.18751Testing软件测试网j:E;wl^@*\9|,N r*z7v
61.228.135.18751Testing软件测试网1u K6[9?-GZ1t@K
61.228.135.187
e[Z Cd5v txW061.228.135.18751Testing软件测试网4j0x M\ TPW ED
61.228.135.18751Testing软件测试网b6l\8W2pQ5h$c5t

jO1Lfc1t'd/U0uniq -c    打印每一重复行出现的次数。51Testing软件测试网ZM^P7[&WX)`e by4U

0t QmQ){|0[root@localhost~]# cat access.log | awk '{print $3}'|sort|uniq -c
]xF ya6y0      6 220.139.141.6151Testing软件测试网%U Xq |u
      6 61.228.130.169
/c+I w,jUk-@3L0     12 61.228.130.187
Wp\N oF0      6 61.228.131.15
0n1|0D ~;h0     24 61.228.134.10651Testing软件测试网1k3[|GA4G7v
      6 61.228.134.99
0UKc uay4{B pD0      6 61.228.135.18751Testing软件测试网vZ8|YOI/L-Wf4E

J UI/~ q3H,}Q+L0sort -rn    对排序求逆,n为域号,使用此域号开始分类。

e'f5F By[ Y.Y0

A\z2{6Pe6B;a#?R2q W3zM0[root@localhost~]# cat access.log | awk '{print $3}'|sort|uniq -c|sort -rn
)zz*DDg"W*nVJ.N0     24 61.228.134.10651Testing软件测试网5XD4W rh*n
     12 61.228.130.187
Ec g]1g"XQe0      6 61.228.135.18751Testing软件测试网DT B \o4H
      6 61.228.134.99
.W ]j3h7S[ q0      6 61.228.131.1551Testing软件测试网$F#m.I*Q}-o`'y C
      6 61.228.130.16951Testing软件测试网h NnN-Fo e2lk
      6 220.139.141.61
5U6Iy O{/eU3h:g0wc -l 统计行数的51Testing软件测试网-u#j,yLMYP"Be-P

%Q*lT!A!f:g NBm0[root@localhost~]# cat access.log | awk '{print $3}'|sort|uniq -c|sort -rn|wc -l51Testing软件测试网4?nt0~"g+j _lt
751Testing软件测试网|sH$oTea4{


TAG: Apache apache

 

评分:0

我来说两句

Open Toolbar