awk '{ print $1,substr($4,2,length($4)),$2,$7}' ws200/access_log-Sep-05-2007 ws201/access_log-Sep-05-2007 | sort | less

awk '{ print $1,substr($4,2,length($4)),$2,$7}' ws200/access_log-Sep-05-2007 ws201/access_log-Sep-05-2007 | less

grep -v 127.0.0.1 ws200/access_log-Sep-04-2007 ws201/access_log-Sep-04-2007 | grep -v hatest | grep -v .css | grep -v .jpg | grep -v .gif | grep -v .ico | grep -v .png | awk '{ print $1,substr($4,2,length($4)),$2,$7}' | less


awk '{ if (!( $7 ~ /.(css|jpg|gif|hatest|ico)/ || $1 == '127.0.0.1' || $2 == "localhost:802") ) { print $1,substr($4,2,length($4)),$2,$7;} }' ws200/access_log-Sep-05-2007 ws201/access_log-Sep-05-2007 | sort | less


## EXTERNAL UNIQUES
awk '{ if (!( $7 ~ /.(css|jpg|gif|hatest|ico)/ || $1 == '72.51.27.2' || $1 == '127.0.0.1' || $2 == "localhost:802") ) { print $1,substr($4,2,length($4)),$2,$7;} }' ws200/access_log-Sep-03-2007 ws201/access_log-Sep-03-2007 ws200/access_log-Sep-04-2007 ws201/access_log-Sep-04-2007 ws200/access_log-Sep-05-2007 ws201/access_log-Sep-05-2007 | uniq | wc

## EXTERNAL PNG's
wk '{ if ( $7 ~ /.png/ $1 != '72.51.27.2' ) { print $1,$7;} }' ws200/access_log-Sep-03-2007 ws201/access_log-Sep-03-2007 ws200/access_log-Sep-04-2007 ws201/access_log-Sep-04-2007 ws200/access_log-Sep-05-2007 ws201/access_log-Sep-05-2007 | uniq | wc