Netowork Monitoring and Databases

Posted on 2006-04-21
Last Modified: 2010-03-18
I haev a need to monitor traffice on my network, to rpovide usage statistics, and monitor certain "heavy" users. Ihave been using winpcap and ethereal to monitor traffic, however this does not do all I want, as I have a need t monitor traffic for a week at a time, which means splitting files as etherreal cannot handle files this big.

What I would like to do is automaticly import all my capture data into a database, access or MYSQL, however the only way I can do this at the moment is to export capture files to CSV files adn then import into access. What I would like to know, is their either a way to log traffic straight to a csv file, for easy import, or another way to get data into a DB straight away, or another program to do this.

I have tried using SNORT to log to MYSQL, but as far as I can tell, I can only get it to write alerts, rather than all traffic, which I need to produce usage reports.
Question by:sam_cogan
    LVL 27

    Expert Comment

    SolarWinds Orion will do this and put the data in an SQL db.  However, it won't do packet level - meaning you can't tell what the traffic was, just how much it was.
    LVL 3

    Author Comment

    thanks, unfortuanetly I do need to know what the packets are, basicly I need all the info you get in etherreal, but put in a database.
    LVL 27

    Expert Comment

    LVL 3

    Author Comment

    I found an application called trafadmin which does this, for a reasonable price.

    Accepted Solution

    PAQed with points refunded (500)

    Community Support Moderator

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    Title # Comments Views Activity
    Reverse Proxy Server 6 59
    Offline files query 1 29
    Website content filtering at different level 5 44
    OWA and AppPool problem 20 86
    Nslookup is a command line driven utility supplied as part of most Windows operating systems that can reveal information related to domain names and the Internet Protocol (IP) addresses associated with them. In simple terms, it is a tool that can …
    We recently endured a series of broadcast storms that caused our ISP to shut us down for brief periods of time. After going through a multitude of tests, we determined that the issue was related to Intel NIC drivers on some new HP desktop computers …
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now