LOGPARSER #1: Top 10 images by size sent


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

Skip to main content