|
Home > Archive > IIS Server > September 2005 > Analyzing Web Logs from SQL Server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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
| |
| Dr Clue 2005-09-15, 6:05 pm |
| 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
--.
| |
| Steve Schofield 2005-09-16, 2:48 am |
| 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/...&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.googlegroups.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
>
| |
| Jeff Cochran 2005-09-16, 2:48 am |
| 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
| |
| Stephen Parker 2005-09-20, 7:49 am |
| Hi,
Try WhosOn - http://www.whoson.com
This is a live stats/log analyzer product that uses SQL Server as its
database back end. Loads of SQL based reports are included and you can
access the DB using any 3rd party tool.
Thanks
Steve
"Cloy" <cloy@tobola.com> wrote in message
news:1126815202.689884.250180@g43g2000cwa.googlegroups.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
>
|
|
|
|
|