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
Web Log Importer
If you are using Web Log Importer, you can get the same information using the following query:
SELECT TOP 20 cs_uri_stem, COUNT(1) AS Total, MAX([time_taken]) AS MaxTime, AVG([time_taken]) AS AvgTime FROM LogEntry WHERE [date] = '2020-03-10' AND [sc_status] >= 500 GROUP BY [cs_uri_stem] ORDER BY COUNT(1) DESC