All pastes #765583 Raw Edit

Anonymous

public text v1 · immutable
·published 2007-11-08 04:41 UTC
rendered paste body
#!/bin/awk
BEGIN{printf "%s\t\t%s\t%s\n", "USER", "LOGINS", "TIME"}
#{print $0}
{
        if (match($0,"/[0-9]\+[0-9]/")!=1) {
                split($10, day, "+")
                dy=substr(day[1],2,1)
                #print dy;
                minutes+=dy*1440
                #print min
        }
}
{
        if (match($0,/"[0-9][0-9]:[0-9][0-9]\)"/)!=1) {
                split($10, time, ":")
                min=substr(time[2],0,2)
                hr=substr(time[1],2,2)
                minutes+=min+(hr*60)
                #print min,hr
                #print min
        }
}

{array[$1]++;}
{time[$1]=minutes;}
{
         #print time[$1]
         minutes=0
}
END{
        for (i in array) {

                D=int((time[i]/1440));
                time[i]-=(1440*D);
                H=int((time[i]/60));
                time[i]-=(60*H);
                M=int((time[i]/60));
                time[i]-=(60*M);

                printf "%-10s\t%-10s\t%-10s\n", i, array[i], time[i];
        }
}