GNU SQUID EVENT
Sawmill is a GNU Squid Event log analyzer (it also supports the 980 other log formats listed to the left).
It can process log files
in GNU Squid Event format, and generate dynamic statistics from them,
analyzing and reporting events.
Sawmill can parse GNU Squid Event logs, import them into a MySQL, Microsoft SQL Server, or Oracle database (or its own built-in database),
aggregate them, and generate dynamically filtered reports, all through a web interface.
Sawmill can perform GNU Squid Event log analysis on any platform, including Window, Linux, FreeBSD, OpenBSD, Mac OS, Solaris, other UNIX, and others.
Sawmill stores the following non-numerical fields in its database for GNU Squid Event, generates reports for each field, and allows dynamic filtering on any combination of these fields:
|Field|| ||Internal Name|
| ||date/time|| ||date_time|
| ||day of week|| ||day_of_week|
| ||hour of day|| ||hour_of_day|
| ||source IP|| ||source_ip|
| ||cache result|| ||cache_result|
| ||URL|| ||url|
| ||file type|| ||file_type|
| ||worm|| ||worm|
| ||proxy route|| ||proxy_route|
| ||proxy server|| ||proxy_server|
| ||response type|| ||response_type|
Sawmill stores the following numerical fields in its database for GNU Squid Event, aggregating them and including them as columns in most reports:
|Numerical Field|| ||Internal Name|
| ||hits|| ||hits|
| ||visitors|| ||visitors|
| ||size|| ||size|
See Sawmill Features to learn more about Sawmill's options for viewing, customizing, filtering, exporting and scheduling GNU Squid Event reports.
Sawmill also supports 980 other log formats.