I use LogParser on my IIS Log to get a graph of accesses per hour:
SELECT date,QUANTIZE(time,3600),COUNT(*) FROM ex*.log WHERE cs-uri-stem LIKE '%SomePage.aspx' GROUP BY date,QUANTIZE(time,3600)
The problem: If there is no access to SomePage.aspx during an hour, that row is simply missing from the output. I just wonder, can I tell LogParser to insert a row for each hour, even if COUNT(*) is 0?
Basically I wound need something that tells logparser to use MIN(date) and MAX(date) as "boundaries" and "expect" one line per hour. The display is currently just into a text file and then into Excel to create a graph (hits per hour on SomePage.aspx) so to get a proper linear graph, I need an entry for each hour, even it it's 0, and if I can get it directly from LogParser that would be great.