求助，关于文本处理，按照这种要求，该写哪种shell语句啊？谢谢大家

zw86620032

有一个sample.log日志文件，里面内容如截图所示。
1、列出能成功访问网页的IP地址，不要重复。（应该就是状态码200的）
2、计算每个IP地址总共发出多少个GET请求，列出最多的5个
3、求出状态码不是200的总请求个数

日志部分内容在图片截图中，谢谢大家。文件数据如下：

93.193.91.75 - - [25/May/2014:15:26:51 +0200] "GET /static/img/hpi-claim_01.png HTTP/1.1" 200 3114 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0"
93.193.91.75 - - [25/May/2014:15:26:51 +0200] "GET /static/img/Logo.png HTTP/1.1" 200 7930 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0"
93.193.91.75 - - [25/May/2014:15:26:51 +0200] "GET /static/img/startseite_blau.png HTTP/1.1" 200 654957 "https://sample-server/static/css/extra.css" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0"
37.24.149.124 - - [25/May/2014:15:26:53 +0200] "GET /isec/accounts/ HTTP/1.1" 200 5338 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko"
37.24.149.124 - - [25/May/2014:15:26:53 +0200] "GET /isec/my_admin/jsi18n/ HTTP/1.1" 200 4553 "https://sample-server/isec/accounts/" "Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko"
37.201.226.131 - - [25/May/2014:15:26:53 +0200] "GET /isec/search/ HTTP/1.1" 200 5083 "https://sample-server/isec/checkMe/?browser=Chrome&ver=35.0.1916.114&sys=Windows%207&plugins=Java:1.7.0.55,Flash:13.0.0.214,VLC%20Player:2.1.3.0,Silverlight:5.1.30214.0" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
37.24.149.124 - - [25/May/2014:15:26:53 +0200] "GET /static/js/affected.js HTTP/1.1" 200 2452 "https://sample-server/isec/accounts/" "Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko"
37.201.226.131 - - [25/May/2014:15:26:53 +0200] "GET /isec/my_admin/jsi18n/ HTTP/1.1" 200 4394 "https://sample-server/isec/search/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
85.183.238.26 - - [25/May/2014:15:26:54 +0200] "GET / HTTP/1.1" 302 6988 "http://www.pcwelt.de/news/Gratis-Check_verraet__ob_Ihre_Daten_sicher_sind-Identity_Leak_Checker-8725246.html?r=563613162754286&lid=331276&pm_ln=11" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:54 +0200] "GET /isec/ HTTP/1.1" 200 5890 "http://www.pcwelt.de/news/Gratis-Check_verraet__ob_Ihre_Daten_sicher_sind-Identity_Leak_Checker-8725246.html?r=563613162754286&lid=331276&pm_ln=11" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:55 +0200] "GET /static/css/bootstrap.min.css HTTP/1.1" 200 12249 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:55 +0200] "GET /static/prettify/prettify.css HTTP/1.1" 200 852 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/css/extra.css HTTP/1.1" 200 3516 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/autocomplete_light/style.css HTTP/1.1" 200 1884 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/css/css.css HTTP/1.1" 200 956 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
37.201.226.131 - - [25/May/2014:15:26:56 +0200] "GET /isec/all/ HTTP/1.1" 200 5280 "https://sample-server/isec/search/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
37.201.226.131 - - [25/May/2014:15:26:56 +0200] "GET /isec/my_admin/jsi18n/ HTTP/1.1" 200 4394 "https://sample-server/isec/all/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/img/hpi-claim_01.png HTTP/1.1" 200 3114 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/img/Logo.png HTTP/1.1" 200 7930 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/img/hpiicon.ico HTTP/1.1" 200 1970 "-" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
37.201.226.131 - - [25/May/2014:15:26:58 +0200] "GET /isec/search/ HTTP/1.1" 200 4938 "https://sample-server/isec/all/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
37.201.226.131 - - [25/May/2014:15:26:59 +0200] "GET /isec/my_admin/jsi18n/ HTTP/1.1" 200 4394 "https://sample-server/isec/search/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/img/startseite_blau.png HTTP/1.1" 200 654957 "https://sample-server/static/css/extra.css" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:27:01 +0200] "GET /isec/ HTTP/1.1" 200 5890 "http://www.pcwelt.de/news/Gratis-Check_verraet__ob_Ihre_Daten_sicher_sind-Identity_Leak_Checker-8725246.html?r=563613162754286&lid=331276&pm_ln=11" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:27:02 +0200] "GET /static/prettify/prettify.js HTTP/1.1" 200 6564 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
46.223.101.196 - - [25/May/2014:15:27:02 +0200] "GET /isec/task_1/ HTTP/1.1" 200 10470 "-" "Mozilla/5.0 (Windows NT 6.3; WOW64; Trident/7.0; rv:11.0) like Gecko"
46.223.101.196 - - [25/May/2014:15:27:02 +0200] "GET /isec/my_admin/jsi18n/ HTTP/1.1" 200 4394 "https://www.sample-server/isec/task_1/" "Mozilla/5.0 (Windows NT 6.3; WOW64; Trident/7.0; rv:11.0) like Gecko"

moperyblue

文本数据能贴出来吗?

zw86620032

回复 2# moperyblue

93.193.91.75 - - [25/May/2014:15:26:51 +0200] "GET /static/img/hpi-claim_01.png HTTP/1.1" 200 3114 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0"
93.193.91.75 - - [25/May/2014:15:26:51 +0200] "GET /static/img/Logo.png HTTP/1.1" 200 7930 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0"
93.193.91.75 - - [25/May/2014:15:26:51 +0200] "GET /static/img/startseite_blau.png HTTP/1.1" 200 654957 "https://sample-server/static/css/extra.css" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0"
37.24.149.124 - - [25/May/2014:15:26:53 +0200] "GET /isec/accounts/ HTTP/1.1" 200 5338 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko"
37.24.149.124 - - [25/May/2014:15:26:53 +0200] "GET /isec/my_admin/jsi18n/ HTTP/1.1" 200 4553 "https://sample-server/isec/accounts/" "Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko"
37.201.226.131 - - [25/May/2014:15:26:53 +0200] "GET /isec/search/ HTTP/1.1" 200 5083 "https://sample-server/isec/checkMe/?browser=Chrome&ver=35.0.1916.114&sys=Windows%207&plugins=Java:1.7.0.55,Flash:13.0.0.214,VLC%20Player:2.1.3.0,Silverlight:5.1.30214.0" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
37.24.149.124 - - [25/May/2014:15:26:53 +0200] "GET /static/js/affected.js HTTP/1.1" 200 2452 "https://sample-server/isec/accounts/" "Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko"
37.201.226.131 - - [25/May/2014:15:26:53 +0200] "GET /isec/my_admin/jsi18n/ HTTP/1.1" 200 4394 "https://sample-server/isec/search/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
85.183.238.26 - - [25/May/2014:15:26:54 +0200] "GET / HTTP/1.1" 302 6988 "http://www.pcwelt.de/news/Gratis-Check_verraet__ob_Ihre_Daten_sicher_sind-Identity_Leak_Checker-8725246.html?r=563613162754286&lid=331276&pm_ln=11" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:54 +0200] "GET /isec/ HTTP/1.1" 200 5890 "http://www.pcwelt.de/news/Gratis-Check_verraet__ob_Ihre_Daten_sicher_sind-Identity_Leak_Checker-8725246.html?r=563613162754286&lid=331276&pm_ln=11" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:55 +0200] "GET /static/css/bootstrap.min.css HTTP/1.1" 200 12249 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:55 +0200] "GET /static/prettify/prettify.css HTTP/1.1" 200 852 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/css/extra.css HTTP/1.1" 200 3516 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/autocomplete_light/style.css HTTP/1.1" 200 1884 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/css/css.css HTTP/1.1" 200 956 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
37.201.226.131 - - [25/May/2014:15:26:56 +0200] "GET /isec/all/ HTTP/1.1" 200 5280 "https://sample-server/isec/search/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
37.201.226.131 - - [25/May/2014:15:26:56 +0200] "GET /isec/my_admin/jsi18n/ HTTP/1.1" 200 4394 "https://sample-server/isec/all/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/img/hpi-claim_01.png HTTP/1.1" 200 3114 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/img/Logo.png HTTP/1.1" 200 7930 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/img/hpiicon.ico HTTP/1.1" 200 1970 "-" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
37.201.226.131 - - [25/May/2014:15:26:58 +0200] "GET /isec/search/ HTTP/1.1" 200 4938 "https://sample-server/isec/all/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
37.201.226.131 - - [25/May/2014:15:26:59 +0200] "GET /isec/my_admin/jsi18n/ HTTP/1.1" 200 4394 "https://sample-server/isec/search/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/img/startseite_blau.png HTTP/1.1" 200 654957 "https://sample-server/static/css/extra.css" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:27:01 +0200] "GET /isec/ HTTP/1.1" 200 5890 "http://www.pcwelt.de/news/Gratis-Check_verraet__ob_Ihre_Daten_sicher_sind-Identity_Leak_Checker-8725246.html?r=563613162754286&lid=331276&pm_ln=11" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:27:02 +0200] "GET /static/prettify/prettify.js HTTP/1.1" 200 6564 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
46.223.101.196 - - [25/May/2014:15:27:02 +0200] "GET /isec/task_1/ HTTP/1.1" 200 10470 "-" "Mozilla/5.0 (Windows NT 6.3; WOW64; Trident/7.0; rv:11.0) like Gecko"
46.223.101.196 - - [25/May/2014:15:27:02 +0200] "GET /isec/my_admin/jsi18n/ HTTP/1.1" 200 4394 "https://www.sample-server/isec/task_1/" "Mozilla/5.0 (Windows NT 6.3; WOW64; Trident/7.0; rv:11.0) like Gecko"

这是文件数据，谢谢啦朋友

zw86620032

93.193.91.75 - - [25/May/2014:15:26:51 +0200] "GET /static/img/hpi-claim_01.png HTTP/1.1" 200 3114 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0"
93.193.91.75 - - [25/May/2014:15:26:51 +0200] "GET /static/img/Logo.png HTTP/1.1" 200 7930 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0"
93.193.91.75 - - [25/May/2014:15:26:51 +0200] "GET /static/img/startseite_blau.png HTTP/1.1" 200 654957 "https://sample-server/static/css/extra.css" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0"
37.24.149.124 - - [25/May/2014:15:26:53 +0200] "GET /isec/accounts/ HTTP/1.1" 200 5338 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko"
37.24.149.124 - - [25/May/2014:15:26:53 +0200] "GET /isec/my_admin/jsi18n/ HTTP/1.1" 200 4553 "https://sample-server/isec/accounts/" "Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko"
37.201.226.131 - - [25/May/2014:15:26:53 +0200] "GET /isec/search/ HTTP/1.1" 200 5083 "https://sample-server/isec/checkMe/?browser=Chrome&ver=35.0.1916.114&sys=Windows%207&plugins=Java:1.7.0.55,Flash:13.0.0.214,VLC%20Player:2.1.3.0,Silverlight:5.1.30214.0" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
37.24.149.124 - - [25/May/2014:15:26:53 +0200] "GET /static/js/affected.js HTTP/1.1" 200 2452 "https://sample-server/isec/accounts/" "Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko"
37.201.226.131 - - [25/May/2014:15:26:53 +0200] "GET /isec/my_admin/jsi18n/ HTTP/1.1" 200 4394 "https://sample-server/isec/search/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
85.183.238.26 - - [25/May/2014:15:26:54 +0200] "GET / HTTP/1.1" 302 6988 "http://www.pcwelt.de/news/Gratis-Check_verraet__ob_Ihre_Daten_sicher_sind-Identity_Leak_Checker-8725246.html?r=563613162754286&lid=331276&pm_ln=11" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:54 +0200] "GET /isec/ HTTP/1.1" 200 5890 "http://www.pcwelt.de/news/Gratis-Check_verraet__ob_Ihre_Daten_sicher_sind-Identity_Leak_Checker-8725246.html?r=563613162754286&lid=331276&pm_ln=11" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:55 +0200] "GET /static/css/bootstrap.min.css HTTP/1.1" 200 12249 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:55 +0200] "GET /static/prettify/prettify.css HTTP/1.1" 200 852 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/css/extra.css HTTP/1.1" 200 3516 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/autocomplete_light/style.css HTTP/1.1" 200 1884 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/css/css.css HTTP/1.1" 200 956 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
37.201.226.131 - - [25/May/2014:15:26:56 +0200] "GET /isec/all/ HTTP/1.1" 200 5280 "https://sample-server/isec/search/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
37.201.226.131 - - [25/May/2014:15:26:56 +0200] "GET /isec/my_admin/jsi18n/ HTTP/1.1" 200 4394 "https://sample-server/isec/all/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/img/hpi-claim_01.png HTTP/1.1" 200 3114 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/img/Logo.png HTTP/1.1" 200 7930 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/img/hpiicon.ico HTTP/1.1" 200 1970 "-" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
37.201.226.131 - - [25/May/2014:15:26:58 +0200] "GET /isec/search/ HTTP/1.1" 200 4938 "https://sample-server/isec/all/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
37.201.226.131 - - [25/May/2014:15:26:59 +0200] "GET /isec/my_admin/jsi18n/ HTTP/1.1" 200 4394 "https://sample-server/isec/search/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/img/startseite_blau.png HTTP/1.1" 200 654957 "https://sample-server/static/css/extra.css" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:27:01 +0200] "GET /isec/ HTTP/1.1" 200 5890 "http://www.pcwelt.de/news/Gratis-Check_verraet__ob_Ihre_Daten_sicher_sind-Identity_Leak_Checker-8725246.html?r=563613162754286&lid=331276&pm_ln=11" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:27:02 +0200] "GET /static/prettify/prettify.js HTTP/1.1" 200 6564 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
46.223.101.196 - - [25/May/2014:15:27:02 +0200] "GET /isec/task_1/ HTTP/1.1" 200 10470 "-" "Mozilla/5.0 (Windows NT 6.3; WOW64; Trident/7.0; rv:11.0) like Gecko"
46.223.101.196 - - [25/May/2014:15:27:02 +0200] "GET /isec/my_admin/jsi18n/ HTTP/1.1" 200 4394 "https://www.sample-server/isec/task_1/" "Mozilla/5.0 (Windows NT 6.3; WOW64; Trident/7.0; rv:11.0) like Gecko"

这是文件数据，谢谢啦诸位

zw86620032

93.193.91.75 - - [25/May/2014:15:26:51 +0200] "GET /static/img/hpi-claim_01.png HTTP/1.1" 200 3114 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0"
93.193.91.75 - - [25/May/2014:15:26:51 +0200] "GET /static/img/Logo.png HTTP/1.1" 200 7930 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0"
93.193.91.75 - - [25/May/2014:15:26:51 +0200] "GET /static/img/startseite_blau.png HTTP/1.1" 200 654957 "https://sample-server/static/css/extra.css" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0"
37.24.149.124 - - [25/May/2014:15:26:53 +0200] "GET /isec/accounts/ HTTP/1.1" 200 5338 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko"
37.24.149.124 - - [25/May/2014:15:26:53 +0200] "GET /isec/my_admin/jsi18n/ HTTP/1.1" 200 4553 "https://sample-server/isec/accounts/" "Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko"
37.201.226.131 - - [25/May/2014:15:26:53 +0200] "GET /isec/search/ HTTP/1.1" 200 5083 "https://sample-server/isec/checkMe/?browser=Chrome&ver=35.0.1916.114&sys=Windows%207&plugins=Java:1.7.0.55,Flash:13.0.0.214,VLC%20Player:2.1.3.0,Silverlight:5.1.30214.0" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
37.24.149.124 - - [25/May/2014:15:26:53 +0200] "GET /static/js/affected.js HTTP/1.1" 200 2452 "https://sample-server/isec/accounts/" "Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko"
37.201.226.131 - - [25/May/2014:15:26:53 +0200] "GET /isec/my_admin/jsi18n/ HTTP/1.1" 200 4394 "https://sample-server/isec/search/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
85.183.238.26 - - [25/May/2014:15:26:54 +0200] "GET / HTTP/1.1" 302 6988 "http://www.pcwelt.de/news/Gratis-Check_verraet__ob_Ihre_Daten_sicher_sind-Identity_Leak_Checker-8725246.html?r=563613162754286&lid=331276&pm_ln=11" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:54 +0200] "GET /isec/ HTTP/1.1" 200 5890 "http://www.pcwelt.de/news/Gratis-Check_verraet__ob_Ihre_Daten_sicher_sind-Identity_Leak_Checker-8725246.html?r=563613162754286&lid=331276&pm_ln=11" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:55 +0200] "GET /static/css/bootstrap.min.css HTTP/1.1" 200 12249 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:55 +0200] "GET /static/prettify/prettify.css HTTP/1.1" 200 852 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/css/extra.css HTTP/1.1" 200 3516 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/autocomplete_light/style.css HTTP/1.1" 200 1884 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/css/css.css HTTP/1.1" 200 956 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
37.201.226.131 - - [25/May/2014:15:26:56 +0200] "GET /isec/all/ HTTP/1.1" 200 5280 "https://sample-server/isec/search/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
37.201.226.131 - - [25/May/2014:15:26:56 +0200] "GET /isec/my_admin/jsi18n/ HTTP/1.1" 200 4394 "https://sample-server/isec/all/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/img/hpi-claim_01.png HTTP/1.1" 200 3114 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/img/Logo.png HTTP/1.1" 200 7930 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/img/hpiicon.ico HTTP/1.1" 200 1970 "-" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
37.201.226.131 - - [25/May/2014:15:26:58 +0200] "GET /isec/search/ HTTP/1.1" 200 4938 "https://sample-server/isec/all/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
37.201.226.131 - - [25/May/2014:15:26:59 +0200] "GET /isec/my_admin/jsi18n/ HTTP/1.1" 200 4394 "https://sample-server/isec/search/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.114 Safari/537.36"
85.183.238.26 - - [25/May/2014:15:26:56 +0200] "GET /static/img/startseite_blau.png HTTP/1.1" 200 654957 "https://sample-server/static/css/extra.css" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:27:01 +0200] "GET /isec/ HTTP/1.1" 200 5890 "http://www.pcwelt.de/news/Gratis-Check_verraet__ob_Ihre_Daten_sicher_sind-Identity_Leak_Checker-8725246.html?r=563613162754286&lid=331276&pm_ln=11" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
85.183.238.26 - - [25/May/2014:15:27:02 +0200] "GET /static/prettify/prettify.js HTTP/1.1" 200 6564 "https://sample-server/isec/" "Mozilla/5.0 (Windows NT 6.1; rv:29.0) Gecko/20100101 Firefox/29.0"
46.223.101.196 - - [25/May/2014:15:27:02 +0200] "GET /isec/task_1/ HTTP/1.1" 200 10470 "-" "Mozilla/5.0 (Windows NT 6.3; WOW64; Trident/7.0; rv:11.0) like Gecko"
46.223.101.196 - - [25/May/2014:15:27:02 +0200] "GET /isec/my_admin/jsi18n/ HTTP/1.1" 200 4394 "https://www.sample-server/isec/task_1/" "Mozilla/5.0 (Windows NT 6.3; WOW64; Trident/7.0; rv:11.0) like Gecko"

zw86620032

回复 2# moperyblue

哥们，我贴出来了，帮忙看看，谢谢

moperyblue

回复 6# zw86620032

1. #1.
   
2. awk '$9==200&&!b[$1]++{print$1}' file
   
3. 
   
4. #2.
   
5. awk '/"GET /{a[$1]++}END{for(i in a)print i,a[i]|"sort -k2nr|head -5|cut -f1"}' OFS=\\t file
   
6. 
   
7. #3.
   
8. awk '$9!=200{i++}END{print i}' file

复制代码

sunzhiguolu

1、列出能成功访问网页的IP地址，不要重复。（应该就是状态码200的）
2、计算每个IP地址总共发出多少个GET请求，列出最多的5个
3、求出状态码不是200的总请求个数

你的数据处理要求，如何理解? 三种结果?

cd_ly

需求一：
        [root@ /tmp/cdly]# awk '$9==200{a[$1]}END{for(i in a)print i}' file              
        37.201.226.131
        37.24.149.124
        93.193.91.75
        46.223.101.196
        85.183.238.26

需求二：       
        [root@ /tmp/cdly]# awk '$6~/GET/{a[$1]++}END{for(i in a)print a[i],i}' file|sort -nr|head -5
        13 85.183.238.26
        6 37.201.226.131
        3 93.193.91.75
        3 37.24.149.124
        2 46.223.101.196
需求三：
        [root@ /tmp/cdly]# awk '$9!=200{a++}END{print a}' file
        1

fh21_xuejinlian

1、awk '$9==200{!a[$1]++;}END{for(i in a)print i}'  file
2、awk  '$6=="\"GET"{count[$1]++}END{for(i in count)print count[i],i}' file
3awk '$9!="200"{count++;next}END{print count}'  file