BorderReporter 2.1

Novell Cool Solutions: Cool Tool

Digg This - Slashdot This

In Brief

BorderManager log analyzer.

Vitals

Posted:	15 Mar 2004
File Size:	1MB
License:	Free
Download:	/coolsolutions/tools/downloads/border_reporter.zip
Publisher:	James May

Disclaimer

Please read the note from our friends in legal before using this file.

Details

A Java-based GUI tool for analyzing BorderManager common log files.

Use BorderReporter to:

• Import common log files into MySQL.
• Generate daily and monthly stats.
• Save stats as HTML files.
• Perform custom queries (Use forms or SQL).
• Save query results as an XLS spreadsheet.
• Click a URL to open in a browser.

Requires: Java(tm) runtime environment (JRE) and access to MySQL server

Permission is granted to distribute and modify the code; however, modified versions cannot be distributed under the same name.

Version 2.1 Enhancements

• Get stats about file sizes by user & domain.
• The format of HTML stats has been improved.
• You can run queries and stats on multiple logs at once.
• You can order query results ascending or descending.
• Border Recorder has a bug fix so that it will roll over monthly statsat the beginning of a new month.
• Border Recorder now can determine when a log has been closed byBorderManager. You no longer have to specify your log interval.

Novell Cool Solutions (corporate web communities) are produced by WebWise Solutions. www.webwiseone.com

Reader Comments

• Most useful indeed. The BorderRecorder stays loaded on the server, does it have some kind of automatic cycle? It would be nice to know some details beyond the installation docs. When does it do the monthly collection or when does it process if it stays loaded on the server?
• Looks nice but how is it configured? There is no mention of configuring a database within the mysql server, so either the user account needs DB create rights (i've tried root but still no luck) or a specifically named db needs to be created first but there is no mention of this. Reply: The app creates the db automatically. You do need an account with permission to create. I am happy to help via email. James
• I can't get the borderrecorder component to work, it can't find my log files. Otherwise it seems very useful! Reply: Border Recorder has been reworked and updated. You may email me for assistance configuring Border Reporter. Thanks, James
• Great tool! I am thrilled to be able to search by user or url. This will save me a lot of time. Thank you!
• Very Powerful Tool. Way COOL!
• This update resolves a cross platform issue in regards to case sensitive handling of the db & tables so it works properly between any mix of NW, Win or *NIX now. Also better error handling with more meaningful error messages. Well done James.
• Wonderful Tool. Setup was easy. I used to use grep tools to search for data in BM logs. This is a great app!
• Awesome tool! Any chance I can get the option to select different databases to read from or import/append to?
• Not enough help available to get this running.
• This is an excellent tool, however, there are two annoying bugs. The properites file gets corrupted everytime the server is restarted and the field sizes are reporting being too small. This maybe becuase MYSQL 5 is being used. You can manually fix this using MYSQL Administrator.