counting words

FOBoy · #1 (**permalink**) 09-24-2009

if i have a long list of data, with every line beginning with an ip-address, like this:

62.165.8.187 - - [24/Oct/2002:23:13:42 +0200] "GET /bestandnaam.html HTTP/1.1" 200 5848 "http://www.domeinnaam.nl/bestandnaam.html" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)"

how do i count which ip-adresses are mentioned the most?

i don't know which ip-adresses to search so i can't give an input how many times a specific word is mentioned, i just want to know which are mentioned the most.

zaxxon · #2 (**permalink**) 09-24-2009

An example how it could be done:

Code:

$> cat infile
11.4.1.31
10.10.10.1
10.123.1.5
10.10.10.1
10.123.1.5
11.4.1.31
10.10.10.1
11.43.1.30
9.30.111.7
11.43.1.30
11.4.1.31
9.30.111.7
11.4.1.31
11.4.1.31
10.123.1.5
$> awk '{_[$1]+=1} END{for(a in _){print a,_[a]}}' infile| sort -t" " -k2,2r
11.4.1.31 5
10.10.10.1 3
10.123.1.5 3
11.43.1.30 2
9.30.111.7 2

chakrapani · #3 (**permalink**) 09-24-2009

Check with this one

Code:

awk '{ print $1 }' | sort | uniq -c  /path/to/logfile.log

methyl · #4 (**permalink**) 09-24-2009

chakrapani probably meant:

Code:

# Top 10 occurances of IP address
awk '{print $1}'  /path/to/logfile.log | sort | uniq -c | sort -n -r | head -10

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Counting characters, words, spaces, punctuations, etc.	ajay41aj	High Level Programming	4	03-06-2009 01:02 PM
Counting with Awk	saint2006	Shell Programming and Scripting	4	02-03-2009 05:10 PM
counting words then amending to a file	iago	UNIX for Dummies Questions & Answers	1	09-10-2007 08:32 PM
Counting words in a file	r0mulus	Shell Programming and Scripting	1	10-24-2002 09:32 AM
Counting LOC in C	amatsaka	High Level Programming	1	06-04-2002 03:18 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by