LOGPARSER #1: Top 10 images by size sent

  • Article

This script is an easy way of checking if any of your pictures take up too much bandwidth on you site. Maybe you can resize them or change resolution? 

Select
Top 10
StrCat(Extract_Path(TO_Lowercase(cs-uri-stem)),'/') AS RequestedPath,
Extract_filename(To_Lowercase(cs-uri-stem)) As RequestedFile,
Count(*) AS Hits,
Max(time-taken) As MaxTime,
Avg(time-taken) As AvgTime,
Max(sc-bytes) As BytesSent
INTO TOP10ImagesBySize.txt
FROM
  logs\iis\ex*.log
WHERE
(Extract_Extension(To_Lowercase(cs-uri-stem)) IN ('gif';'jpg';'png'))
AND
(sc-status = 200)
GROUP BY
To_Lowercase(cs-uri-stem)
ORDER BY
BytesSent,
Hits,
MaxTime
DESC

//Anders