#!/bin/csh
#
# iplookerupper: takes lotus notes
# server access log and outputs a
# semicolon-delimited text file sorted by IP address.
#
# usage : ./iplookerupper LOGFILE
# outputs two files : dbout and dataout which you can
# import and combine in a spreadsheet program
#
# written by Dan Itsara '02 <ditsara@mit.edu>

echo "Hey, that's not a handle"
echo . > dbout
echo . > dataout

foreach i (`cut -c81-100 $1 | sort -u`)
        echo Doing $i

        set rephits = `grep $i $1 | wc -l`
        repeat $rephits echo $i > outcol1.neuro

# find dates
        grep $i $1 | cut -c36-46 > outcol2.neuro

# find times
        grep $i $1 | cut -c47-57 > outcol3.neuro

        echo `whois -h rs.arin.net $i | head -3` > ipstor.neuro
        repeat $rephits cat ipstor.neuro > outcol4.neuro

        paste -d ';' outcol1.neuro outcol2.neuro outcol3.neuro > outrow.neuro
        cat outrow.neuro >> dbout
        cat outcol4.neuro >> dataout
        rm *.neuro

        sleep 3
end

echo Process Complete