Log Parser IIS

Example - Pulls IIS logs for Ben.WHittaker

SELECT TO_LOCALTIME(QUANTIZE(TO_TIMESTAMP(date, time),3600)) AS ESTTIME, cs(User-Agent), cs-username, COUNT(*) AS LOOKUP_Frequency, c-ip

FROM I:\IISLOGS\ex*.log, I:\IISLOGS\ex*.log,I:\IISLOGS\ex*.log

where ( cs-username like '%Ben.WHittaker%')

GROUP BY ESTTIME ,cs(User-Agent),cs-username,c-ip

ORDER BY ESTTIME ASC