awk grouping report 1

[stfaprc]

I have an awk line of:
awk '{if ($6 == "allow") print $1,$2,$3,$13,$15,$14,$6,$17,$18,$19,$20,$21}' firebox

$3=protocol, $17=ip address target
I would like to be able to get awk produce a report that would group on field #3, giving me a count of how many times it appeared in firebox for each ip address.
For instance:
smtp 10.10.10.10 5 times
smtp 10.10.10.30 9 times
ssh 10.10.10.50 1 times

Is this do-able with awk?

 

[vgersh99]

{ arr[$3 OFS $17]++ }
END {
  for (i in arr)
    printf("%s %d times\n", i, arr[i])
}

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[stfaprc]

Hello Vlad,
where do i put the code you sent?
does it need to in a file and awk run with the -F option ?

thanks.

 

[vgersh99]

nawk [red]-f[/red] myAWKscript.awk firebox

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+