LOGPARSER #6: Check daily bandwidth

This script checks for daily bandwidth. Great for spotting trends.

Select
To_String(To_timestamp(date, time), 'MM-dd') As Day,
Div(Sum(cs-bytes),1024) As Incoming(K),
Div(Sum(sc-bytes),1024) As Outgoing(K)
Into BandwidthByDay.gif
From
logs\iis\ex*.log
Group By
Day

image

You can also convert this into local time and check bytes sent by the server. We used this at my customer to check at what time a day we had the most traffic/datausage. We needed to create a IIS memory dump with as much data/traffic as possible but didn’t know the best time for it.

SELECT
QUANTIZE(TO_TIMESTAMP(date, time), 3600) AS Hour,
SUM(sc-bytes) AS TotalBytesSent
INTO BytesSentPerHour.gif
FROM
logs\iis\ex*.log
GROUP BY
Hour
ORDER BY
Hour

image

//Anders