Dumps: Fun with pipes

Problem: Checking out who accessed some webapp. Log file format:

[21/Sep/2009:10:31:21 -0400] cbalan "GET /webapp/some_url HTTP/1.1" 200
[21/Sep/2009:10:31:21 -0400] robocop "GET /webapp/some_url HTTP/1.1" 200

[21/Sep/2009:10:31:21 -0400] cbalan "GET /webapp/some_url HTTP/1.1" 200

[21/Sep/2009:10:31:21 -0400] cbalan "GET /webapp/some_url HTTP/1.1" 200
[21/Sep/2009:10:31:21 -0400] bad_monkey "GET /webapp/some_url HTTP/1.1" 200

[21/Sep/2009:10:31:21 -0400] cbalan "GET /webapp/some_url HTTP/1.1" 200

[21/Sep/2009:10:31:21 -0400] webrat "GET /webapp/some_url HTTP/1.1" 200
[21/Sep/2009:10:31:21 -0400] webrat "GET /webapp/some_url HTTP/1.1" 200

[21/Sep/2009:10:31:21 -0400] cbalan "GET /webapp/some_url HTTP/1.1" 200

Solution:

#bash> cat /var/log/apache2/webapp_log | cut -f 3 -d ' ' | sort | uniq