Select top 10 pages with log parser from iis logs

Question

Hi Could you please let me know query to select top 10 pages from every iis log files using logparser.

Thanks,

Answer 1

Get all the logs into a directory then run

logparser "SELECT cs-uri-stem, COUNT(*) as cnt FROM *.log GROUP BY cs-uri-stem ORDER BY cnt DESC" -i:IISW3C -o:CSV

(This assumes the logs are in W3C format).

Answer 2

Adding to Marks answer, here is how to limit the output to 10 records:

logparser "SELECT TOP 10 cs-uri-stem, COUNT(*) as cnt FROM *.log GROUP BY cs-uri-stem ORDER BY cnt DESC" -i:IISW3C -o:CSV

(This assumes the logs are in W3C format).