[CLUE-Tech] GPL FTP analysis program?

Jeff Cann j.cann at isuma.org
Tue Aug 12 13:54:26 MDT 2003


Greetings.

Can anyone recommend a versatile FTP log analysis program?  I am not looking 
for standard traffic / size analysis (like you get with webalizer).  I want 
to scan logs and aggregate data based on the user.  Here are some examples of 
questions I need to answer:

 a) List the date/time/size of the last file downloaded by a given user.
 b) List all downloaded files for a given user for month X.
 c) For a list of files uploaded, list the user, date and time when they were
     downloaded.

I already have a perl script to parse FTP logs, but it's not flexible in how 
it can roll up statistics for a use.

It's not difficult to change the script to answer the next (business) 
question.  But, everytime there's a new question, I write more code (not very 
good code, I might add).  The script started as a quick hack and now people 
(at work) are coming to me for more analysis.  Ideally, I should have put 
parsed data into a database and then it would be a snap to answer novel 
business questions by writing SQL queries.

So, I'm looking for something polished that does not have to be changed at the 
code level.  So far, I have only found commercial software.  I'm looking for 
GPL equivalents.  Suggestions?

Thanks!
Jeff



More information about the clue-tech mailing list