Limit awk results to html requests

Question

I'm using awk to analyze some access log files. I'm currently using the following:

awk '($9 ~ /404/)' access_log | awk '{print $9,$7}' | sort | uniq -c | sort > 404.txt

Which returns all of the 404s in my access log with number of appearances. However, it returns absolutely everything—but I'm only interested in html pages.

How can I modify this to only return values for requests that end in .html?

You could just add a `grep` to the command? – jornane Jul 29 '15 at 16:45 — jornane, Jul 29 '15 at 16:45

score 1 · Accepted Answer · answered Jul 30 '15 at 23:30

1

You can add another regex :

awk '$7 ~ /\.html/ && $9 ~ /404/ {print $9,$7}' access_log | sort | uniq -c | sort > 404.txt

answered Jul 30 '15 at 23:30

Sylvain Firmery

331
1
4

Limit awk results to html requests

1 Answers1