Find top 10 requests using Log Parser.

I've been using Logparser and posting some common used Queries. 

SELECT TOP 10 cs-uri-stem, COUNT(*)FROM "REPLACE_WITH_PATH_TO_LOGFILES_IIS_formats_logs_exYYMMDD.log"
GROUP BY cs-uri-stem
ORDER BY COUNT(*) DESC

 

Published Thursday, December 14, 2006 2:55 PM by steve schofield
Filed under:

Comments

# re: Find top 10 requests using Log Parser.

Tuesday, August 28, 2007 3:33 AM by Davi Souza

Hello, how can i parse windows media service logs??

I want to know how many listener are connected at one transmition....

# re: Find top 10 requests using Log Parser.

Tuesday, August 28, 2007 1:06 PM by steve schofield

Please post these on logparser.com forums.