Snort mailing list archives
Re: Snort reports
From: Kevin Johnson <kjohnson () secureideas net>
Date: Wed, 15 Feb 2006 20:54:33 -0500
On Feb 15, 2006, at 1:19 PM, Pablo Sanchez wrote:
Hi guys,I know that almost everybody uses ACID, BASE and so on to check the snort logs and alerts. But I'm needing to develop my own interface for the snort database. So I'd like to know if someone has already made some reports using the database.I'm searching for SQL statements to make my own reports.Example: Top 15 alerts, Top 15 services, Top 15 IP address attacked, and so on...I'm also taking a look at the database schema. ( http:// www.andrew.cmu.edu/user/rdanyliw/snort/snortdb/snortdb_schema.html ).Best regards, Pablo
Hi-I am glad to hear that so many people use BASE.<grin> May I ask why you need to create your own interface? If it is a feature that needs to be added, it would probably be easier to just work with us to implement it?
If you still need to write your own, I would set up BASE and run it with the sql trace turned on. That way it will log every query that is run including the dynamic ones.
Hope that helps, Kevin --------------------- BASE Project Lead http://sourceforge.net/projects/secureideas http://base.secureideas.net The next step in IDS analysis!
Current thread:
- Snort reports Pablo Sanchez (Feb 15)
- Re: Snort reports Kevin Johnson (Feb 15)
- Re[2]: Snort reports Mathieu CHATEAU (Feb 18)
- Re: Re[2]: Snort reports Kevin Johnson (Feb 18)
- Re[4]: Snort reports Mathieu CHATEAU (Feb 19)
- Re[2]: Snort reports Mathieu CHATEAU (Feb 18)
- Re: Snort reports Kevin Johnson (Feb 15)
- <Possible follow-ups>
- RE: Snort reports Hartman, Shane (Feb 15)