as is not uncommon, my ISP uses load balanced web servers, which can make log file analysis a bit of a pain. i prefer to use WebTrends, whose fascist licensing policy would mean purchasing the most expensive edition plus extra licenses for each load balanced server whose log files i want to report on. i dont think so.
enter the excellent Log Parser 2 which is also part of the IIS-6 SDK. it’s a simple command line util that can parse, query and convert web log files using SQL syntax, and it can also consolidate multiple server logs into a file that webtrends will happily consume without insisting on extra cash.
logparser "SELECT * FROM d:logs*.log TO d:logsall.log ORDER BY date, time ASC" -i:IISW3C -o:W3C
this takes all my current extended IIS logs, consolidates the entries in date time order (otherwise webtrends can become petulant) and produces a single log file in W3C format. sweet. as an aside in a previous post i’d estimated that the site should view as intended in over 96% over broswers. interestingly, based on site stats, the actual figure exceeds 99%.
