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

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

//Anders