Generate Report from different LOG-Files
From: Michael Ruck (m.ruck@itnovum.de)
Date: 11/28/02
- Next message: Joseph V. Morris: "Re: All rules = No rules?"
- Previous message: Cap: "Re: A Royal Name"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Michael Ruck" <m.ruck@itnovum.de> Date: Thu, 28 Nov 2002 15:48:43 +0100
Hi @all!
I have a really special problem and I hope one of you can help me very
quickly.
I have do search for or develop a tool, that can generate one report out of
different kinds of LOG-files.
hese kind of LOG-files are:
MS Exchange SMTP-log or sendmail log
squid log
nacctd log
IIS NCSA log
The tool I'm searching for has to analyse these log-files and generate one
report out of it, if possible in HTML or PDF.
A few words, why I need such a tool:
We operate here at the location a computing centre for our parent
company. At this computing centre further subsidiaries are attached.
In order to make now an exact account over the developed traffic, we
need the analysis of these different log files, because the account has to
be
for each company, arranged according to user and service (Web, email,
VPN etc..).
The different log files are in addition also still on different
servers distributed. Everyone the log file types specified above is on
another server.
The different information, which service which user used and how much
traffic it produced thereby, are also only in the different log files
to find.
My target is it now to summarize all these data either in only one
report or in a database (esp. MySQL).
Now does one of you know a tool, which can complete this work for me? Or
does one of you have an idea, how one can implement relatively simply such a
tool? Perhaps one of you wrote already a similar Tool and can help me.
Or is it possible to install one sniffing-tool on the firewall, which logs
all the information I need (user (or internal host) -> service (web, email,
vpn) -> bytes send/recieved). At the moment the nacctd is running on our
firewall to report the vpn-traffic, but it is not possible to report the
other services, because only the internal host of our squid is showing in
these log-files.
Maybe I can modify the squid to send the users host to the firewall. In the
nacctd-log the ports of the connection is logged and so I can see, what
service is used.
Please help me, it is really important. Post your answer here in the
Newsgroup or send me a mail.
Thanks for all your help.
Michael Ruck
- Next message: Joseph V. Morris: "Re: All rules = No rules?"
- Previous message: Cap: "Re: A Royal Name"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|