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