Analyzing Web Logs from SQL Server

I just started working for an organization that runs IIS, which
deposits the logs into a SQL Server.

Can anyone recommend a web log analyzer that will pull data from SQL
Server?

Thanks, in advance! Cloy

Cloy wrote:
> I just started working for an organization that runs IIS, which
> deposits the logs into a SQL Server.
>
> Can anyone recommend a web log analyzer that will pull data from SQL
> Server?
>
> Thanks, in advance! Cloy

Maybe it would be easier to have SQL generate a report that
looks like a typical server logfile , then you can be back to
having your choice of analizer software.

Just a thought. :)


--
--.
--=<> Dr. Clue (A.K.A. Ian A. Storms) <>=-- C++,HTML, CSS,Javascript
--=<> http://resume.drclue.net <>=-- AJAX, SOAP, XML, HTTP
--=<> http://www.drclue.net <>=-- SERVLETS,TCP/IP, SQL
--.

Couple of ways, you could use Log Parser to extract and put into SQL server
or This Report Pack includes the following reports:

http://www.microsoft.com/downloads/d...displaylang=en
A set of 12 reports that work with a sample database of information
extracted from Microsoft Internet Information Services (IIS) log files. The
Microsoft SQL Server Report Pack for Internet Information Services (IIS) is
a set of 12 Microsoft SQL Server 2000 Reporting Services reports that works
with a sample database of information extracted from Microsoft Internet
Information Services (IIS) log files. This database can be populated with
your own data using the Log Parser included with the IIS 6.0 Resource Kit.
You can use also the sample reports as templates for designing new reports.


Steve Schofield
steve@deviq.com

Microsoft MVP - ASP.NET

"Cloy" <cloy@tobola.com> wrote in message
news:1126815202.689884.250180@g43g2000cwa.googlegr oups.com...
>I just started working for an organization that runs IIS, which
> deposits the logs into a SQL Server.
>
> Can anyone recommend a web log analyzer that will pull data from SQL
> Server?
>
> Thanks, in advance! Cloy
>

On 15 Sep 2005 13:13:22 -0700, "Cloy" <cloy@tobola.com> wrote:

>I just started working for an organization that runs IIS, which
>deposits the logs into a SQL Server.
>
>Can anyone recommend a web log analyzer that will pull data from SQL
>Server?

The reason you would log to SQL Server is to use SQL Server for the
reporting. Crystal Reports is the obvious choice here.

Jeff