ProgrammingWindows

Using Log Parser Studio to Find Common 500 Errors

The following Log Parser Studio query will find common erroring URLs. You could adapt this to find common addresses for other status codes too.

SELECT TOP 20
   	cs-uri-stem, 
	COUNT(*) AS Total, 
	MAX(time-taken) AS MaxTime, 
	AVG(time-taken) AS AvgTime
FROM
	'[LOGFILEPATH]'
WHERE
    date > SUB(TO_LOCALTIME(SYSTEM_TIMESTAMP()), TIMESTAMP('0000-01-02 00:00', 'yyyy-MM-dd HH:mm'))
AND
    sc-status = '500'
GROUP BY cs-uri-stem
ORDER BY Total DESC