Extract TOP 10 - '500 errors' from IISLogs using Logparser

SELECT TOP 10 cs-uri-stem, sc-status, count(*) INTO filename_top10_500.csv FROM \\ServerName\PathToWWWlogs\w3svcSITEID\exYYMMDD.log where sc-status=500 group by cs-uri-stem,sc-status order by count(*) DESC"
Published Thursday, December 14, 2006 3:07 PM by steve schofield
Filed under:

Comments

No Comments