Sawmill is a Kerio Connect log analyzer (it also supports the 1021 other log formats listed to the left).
It can process log files
in Kerio Connect format, and generate dynamic statistics from them,
analyzing and reporting events.
Sawmill can parse Kerio Connect 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 Kerio Connect 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 Kerio Connect, 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|
| ||type|| ||type|
| ||subtype|| ||subtype|
| ||sender|| ||sender|
| ||recipient|| ||recipient|
| ||sender host|| ||sender_host|
| ||subject|| ||subject|
| ||location|| ||location|
| ||Authentication Method|| ||authentication_method|
| ||user|| ||user|
| ||blacklist|| ||blacklist|
| ||spam score|| ||spam_score|
| ||spam threshold|| ||spam_threshold|
| ||spam subject|| ||spam_subject|
| ||queue ID|| ||queue_id|
| ||SSL|| ||ssl|
| ||service|| ||service|
Sawmill stores the following numerical fields in its database for Kerio Connect, aggregating them and including them as columns in most reports:
|Numerical Field|| ||Internal Name|
| ||messages queued|| ||messages_queued|
| ||messages delivered|| ||messages_delivered|
| ||messages delayed|| ||messages_delayed|
| ||messages relayed|| ||messages_relayed|
| ||messages failed|| ||messages_failed|
| ||messages spam filtered|| ||messages_spam_filtered|
| ||bytes queued|| ||bytes_queued|
| ||bytes delivered|| ||bytes_delivered|
| ||bytes delayed|| ||bytes_delayed|
| ||bytes relayed|| ||bytes_relayed|
| ||bytes failed|| ||bytes_failed|
| ||bytes spam filtered|| ||bytes_spam_filtered|
| ||security events|| ||security_events|
See Sawmill Features to learn more about Sawmill's options for viewing, customizing, filtering, exporting and scheduling Kerio Connect reports.
Sawmill also supports 1021 other log formats.