Are there any decent, simple log analyzers for WinGate?

[stevehiner]

I've tried ProxyInpector, I've tried Sawmill, I've tried ReportMagic - none of them seem to be able to generate the report I need. It's possible that they're just way to complicated and I don't have time (really my client doesn't have the money) to figure out how to bend them to my will. I've already spent way more time trying to get them to work that I want to - I expected to spend a fair bit of time on it but it's getting out of hand now.

All I really need is a report that shows the IP address of the user's computer and all the web sites that user visited broken down by the hour of the day. I'm not just tracking abuse, I want to make sure we know if that abuse happened during business hours.

I couldn't figure out how to get Sawmill to show me specific web sites visited by a user.

ProxyInspector would break it down by hour of the day but it would only show me aggregate data for all users, not for a specific internal IP address. It would show me data for an individual internal IP but would only show ALL the sites they visited that day with no idication of what time they browsed there.

I'm not using the proxy client application, just the proxy settings in IE so users are identified only by the computer they're on.

Last night I imported over 400,000 request records into Access 2003 to do the processing myself but once I add the Traffic records it's going to take a LONG time for Access to summarize the data. I'd be happy to buy a log analyzer if I could verify that it is able to generate the report I need.

Any advice? It seems like my reporting needs are very much like what any manager would want - why don't the current log analyzers make it easy to get that data?

By the way, WinGate itself works great! I'm quite pleased with it so far I just wish it had built-in log analysis.

[ImmediateAction]

Internet Access Monitor: http://www.internetaccessmonitor.com/

Found this browsing for WinGate utils via google. I downloaded but aint used yet. If ya try it, tell us how ya go.

[stevehiner]

After posting that message I found Internet Access Monitor. It seem to be pretty decent but the reports aren't terribly customizable. It has a nice double-click-drill-down feature in the reporting that makes it pretty reasonable to get at the data I want. Unfortunately it means a fair bit of work for me to generate the reports for the client every day - I'd have to:
Open the reporting screen
Fill the report
Double click a user
Double click an hour of the day
Send a report
Back up to the last report
Double click the next hour
Send a report
Back up to the last report
<repeat 22 more times>
Back up one level
<repeat 5 times, once for each user>

It'd get pretty boring for me and pretty expensive for the client. For just looking at the data it's not a half-bad program though.

Right now I'm writing a database app to generate the reports I want.