Reporting on Web usage of BorderManager Proxy Servers - for Linux
Novell Cool Solutions: Trench
Digg This -
Posted: 5 Feb 2003
Hey, Linux users. Here's a free tool to help you parse NBM proxy server logs into a PostgreSQL database.
It requires Linux, PostgreSQL, Apache, and Perl, and any current browser should work (Mozilla, IE, Konqueror, etc.).
Here's what it does:
Parses BorderManager proxy server logs into a PostgreSQL database. Creates top ten user and site reports. Allows for departmental reports on usage of the Internet via BME proxy server. You may customize your departments to include users which are found in the logs (requires authentication to the proxy). These reports can be extensive listing of every access made by a user for a period of time. You may also run reports on sites accessed by a department, or which department accessed what sites for a given time period, and the number of accesses by department (breaks down by User ID). You may also run reports on who has downloaded what and when via the proxy based on the file size threshold you set.
All defaults are customizable. The Log parsing and top ten reports are schedulable via Cron. This application is based in Perl and should run on any platform with minor environmental tweaking of the config file and scheduled script processing (uses some shell scripts).
Please provide feedback to firstname.lastname@example.org and feel free to reply with any enhancements to either the documentation or code. This is an Open Source initiative and should not be sold for profit (feel free to charge for installation).
Documentation is included in MS Word format in the ZIP file under /docs.
You can find it in our Free Tools area at http://www.novell.com/coolsolutions/tools/1582.html
Novell Cool Solutions (corporate web communities) are produced by WebWise Solutions. www.webwiseone.com