Shell Programming and Scripting

Sure you can. Either by variable substitution inside awk code or by assigning the sell variable to a awk variable with the -v switch.
The GNU Awk User's Guide

Instead of looping through your log files and executing the awk code block on every loop, why don't you input all these files into awk like:

Code:

awk 'awk code block' file1 file2 file3

This would enable you to use the awk FILENAME variable to print the file name in front of the results.

Code:

awk '{total[FILENAME" "$10] += 1} END{for (i in total) print "HTTP/1.1 "i, total[i]}' file1 file2 file3

Thanks, I'll go have a look at the user's guide.

Thanks you so very much ripat. I came right.

for t in 00 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23; do echo "Day_hour: $t"; cat /var/SP/log/apache/cre/access.log_20090302_$t | nawk -v a=$t '{total[$10] += 1} END{for (i in total) print a" HTTP/1.1 "i, total[i]}';done
std out--->
Day_hour: 00
00 HTTP/1.1 304 1457
00 HTTP/1.1 404 504
00 HTTP/1.1 500 18
00 HTTP/1.1 503 46
00 HTTP/1.1 200 30510
00 HTTP/1.1 302 167
Day_hour: 01
01 HTTP/1.1 304 701
01 HTTP/1.1 404 227
01 HTTP/1.1 500 8
01 HTTP/1.1 503 11
01 HTTP/1.1 200 17281
01 HTTP/1.1 302 98

As much fun as it is to see this work on a server, I am trying to figure out how to get his working in a ssh command.

ssh readonly@100.100.100.1 'for t in 00 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23; do echo "Day_hour: $t"; cat /var/SP/log/apache/cre/access.log_20090302_$t | nawk -v a=$t '{total[$10] += 1} END{for (i in total) print a" HTTP/1.1 "i, total[i]}';done'

These scripts of mine works fine:
ssh readonly@$ServerIP 'YEAR=xx;DAY=xx;MONTH=xx;LMONTH=xx;for i in 00 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 \
16 17 18 19 20 21 22 23; do cat /var/SP/log/cre/access.log_$YEAR$MONTH$DAY*_$i | grep -c "HTTP/1.1\" \"500";done'

but somehow I need to pass the whole "nawk..." string to ssh, anyone have any ideas?
I keep getting
bash: syntax error near unexpected token `(i'

If you don't want to do the infamous "escape dance", put your command in a file and do

Code:

ssh usr@host < command_file

Also, avoid the useless use of cat:

Code:

cat file_name | awk 'awk_code_block'

Try

Code:

awk 'awk_code_block' file_name

Useless use of cat
http://partmaps.org/era/unix/award.html

I wish I could put it in a file... but I'm too lazy to do that....
but I did get rid of the cat though... and tada! some fancy escape work:

Servername=cre02 ; ServerIP=10.113.98.17;ssh readonly@$ServerIP 'for t in 00 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23; do echo "Day_hour: $t"; nawk -v a=$t '\''{total[$10] += 1} END{for (i in total) print a,i, total[i]}'\'' /var/SP/log/apache/cre/access.log_20090302_$t;done'

What the poor single quotes did to deserve this treatment... I dunno

Thanks again ripat!!

you can use the -v argument

Code:

nawk -v str="01" '{total[$10] += 1} END{for (i in total) print str " HTTP/1.1 "i, total[i]}'

sorry. too late with the reply