GNU SQUID COMMON
Sawmill is a GNU Squid Common log analyzer (it also supports the 1004 other log formats listed to the left).
It can process log files
in GNU Squid Common format, and generate dynamic statistics from them,
analyzing and reporting events.
Sawmill can parse GNU Squid Common 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 Common log analysis on any platform, including Windows, Linux, FreeBSD, OpenBSD, Mac OS, Solaris, other UNIX, and others.
Sawmill stores the following non-numerical fields in its database for GNU Squid Common, 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|
| ||browsing host|| ||browsing_host|
| ||URL|| ||url|
| ||file type|| ||file_type|
| ||operation|| ||operation|
| ||worm|| ||worm|
| ||authenticated user|| ||authenticated_user|
| ||protocol|| ||protocol|
| ||server response|| ||server_response|
| ||cache response|| ||cache_response|
Sawmill stores the following numerical fields in its database for GNU Squid Common, aggregating them and including them as columns in most reports:
|Numerical Field|| ||Internal Name|
| ||hits|| ||hits|
| ||page views|| ||page_views|
| ||visitors|| ||visitors|
| ||size|| ||size|
See Sawmill Features to learn more about Sawmill's options for viewing, customizing, filtering, exporting and scheduling GNU Squid Common reports.
Sawmill also supports 1004 other log formats.