A log of all ip addresses & ports

I have a single Server 2003 serving the internet with Exchange, IIS. I want
to maintain a log file of every single connection that makes it to this
machine from the internet. Every connection to HTTP, every SMTP, every POP3.
I'd like to log the IP address as well as the port, date and time.
Optionally, I would like to know how much bandwith was consumed by that
connection in total, with an overall report showing me total bandwith over a
period of time as well as by connection IP.

I need ALL of this data in either a database layout or excel layout, so I
can sort the numbers, search by IP address, etc.

I've tried Port Reporter. The log files are huge and contain a lot of
unecessary information. I've looked at Port Reporter Parser, but it only
allows me to open a single Port Reporter log file at a time.

Any ideas?

--
Reply to group. Thanks!

Windows gathers this info for you automatically, except for the bandwidth
part - you'll need third-party tool for that. Default log file location is
\Windows\system32\logfiles for the HTTP, SMTP, POP3 connections.

--
Todd J Heron, MCSE
Windows Server 2003/2000/NT; CCA
----------------------------------------------------------------------------
This posting is provided "as is" with no warranties and confers no rights


"AOrlando" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
I have a single Server 2003 serving the internet with Exchange, IIS. I want
to maintain a log file of every single connection that makes it to this
machine from the internet. Every connection to HTTP, every SMTP, every POP3.
I'd like to log the IP address as well as the port, date and time.
Optionally, I would like to know how much bandwith was consumed by that
connection in total, with an overall report showing me total bandwith over a
period of time as well as by connection IP.

I need ALL of this data in either a database layout or excel layout, so I
can sort the numbers, search by IP address, etc.

I've tried Port Reporter. The log files are huge and contain a lot of
unecessary information. I've looked at Port Reporter Parser, but it only
allows me to open a single Port Reporter log file at a time.

Any ideas?

--
Reply to group. Thanks!

Right, I know this. What I lack is a tool to take all of that information
and organize it into a sortable database or spreadsheet. So far all I have
found are log analyzers that will take a single input (IIS, whatever). I
want something that will take the information system wide to the same
system.



"Todd J Heron" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Windows gathers this info for you automatically, except for the bandwidth
> part - you'll need third-party tool for that. Default log file location
> is
> \Windows\system32\logfiles for the HTTP, SMTP, POP3 connections.
>
> --
> Todd J Heron, MCSE
> Windows Server 2003/2000/NT; CCA
> ----------------------------------------------------------------------------
> This posting is provided "as is" with no warranties and confers no rights
>
>
> "AOrlando" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> I have a single Server 2003 serving the internet with Exchange, IIS. I
> want
> to maintain a log file of every single connection that makes it to this
> machine from the internet. Every connection to HTTP, every SMTP, every
> POP3.
> I'd like to log the IP address as well as the port, date and time.
> Optionally, I would like to know how much bandwith was consumed by that
> connection in total, with an overall report showing me total bandwith over
> a
> period of time as well as by connection IP.
>
> I need ALL of this data in either a database layout or excel layout, so I
> can sort the numbers, search by IP address, etc.
>
> I've tried Port Reporter. The log files are huge and contain a lot of
> unecessary information. I've looked at Port Reporter Parser, but it only
> allows me to open a single Port Reporter log file at a time.
>
> Any ideas?
>
> --
> Reply to group. Thanks!
>
>

I would use the switch that the server is connected to. It will give you
everything your looking for.

"AOrlando" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have a single Server 2003 serving the internet with Exchange, IIS. I
want
> to maintain a log file of every single connection that makes it to this
> machine from the internet. Every connection to HTTP, every SMTP, every
POP3.
> I'd like to log the IP address as well as the port, date and time.
> Optionally, I would like to know how much bandwith was consumed by that
> connection in total, with an overall report showing me total bandwith over
a
> period of time as well as by connection IP.
>
> I need ALL of this data in either a database layout or excel layout, so I
> can sort the numbers, search by IP address, etc.
>
> I've tried Port Reporter. The log files are huge and contain a lot of
> unecessary information. I've looked at Port Reporter Parser, but it only
> allows me to open a single Port Reporter log file at a time.
>
> Any ideas?
>
> --
> Reply to group. Thanks!
>
>