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 […]

Filling-In the Care Gap

We all care quite a lot for the people we are close to. We also care about the grand collection of humanity. But we only really care about humanity if we can fill in the gap between these two circles. When you rage somebody off of the road, or are rude to a stranger, or […]

Introduction to Aspects

Aspects are a mixture of management theory, software craftsmanship, communities of practice, apprenticeships, and the software foreman model. The essence of management is that it is based on fundamental assumptions about human behaviour. Douglas McGregor highlighted two of the most prominent assumptions back in the mid twentieth century and they still prevail today (Douglas McGregor, […]