How to read IIS log files to get the hit count and distinct users information?

Hi All,
I am trying to read IIS log file to find out the hit count of the
application and also to find the user base (number of different users
who access our application).
Log files are created on a daily basis.
I am using DTS package to import IIS log files into the database but I
am finding difficulty in analyzing the data. My objective is to get the
users information and hit count on a daily basis so that I can then
consolidate it to find the hit count for the w/month and users who
accessed it during that period.
Thanks,
NareshNaresh,
Can you post the destination table DDL+sample rows+desired output?
Thanks
Jerry
"Naresh" <thatsnaresh@.gmail.com> wrote in message
news:1130169058.111355.64750@.g43g2000cwa.googlegroups.com...
> Hi All,
> I am trying to read IIS log file to find out the hit count of the
> application and also to find the user base (number of different users
> who access our application).
> Log files are created on a daily basis.
> I am using DTS package to import IIS log files into the database but I
> am finding difficulty in analyzing the data. My objective is to get the
> users information and hit count on a daily basis so that I can then
> consolidate it to find the hit count for the w/month and users who
> accessed it during that period.
> Thanks,
> Naresh
>|||
Hi Jerry,
I imported the IIS log file, Sql server automatically creates the table
during the import process.
Following is the extract from IIS log file
#Software: Microsoft Internet Information Services 6.0
#Version: 1.0
#Date: 2005-10-24 07:00:26
#Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query
s-port cs-username c-ip cs(User-Agent) cs(Referer) cs-host sc-status
sc-win32-status sc-bytes cs-bytes time-taken
It contains the columns information that is being logged.
Just curious to know whether each entry in IIS log file a HIT to the
application? i.e., can I treat the number of rows in the log file as the
hit count of the application?
As already requested I also wanted to find out different users who had
accessed the application?
Thanks much in advance.
Regards,
Naresh
*** Sent via Developersdex http://www.examnotes.net ***

how to question

hey all,
Name, Inv(y/n), Desc
--
Cust1, null, Desc1
Cust1, null, Desc2
Cust1, Y, Desc1
Cust2, null, Desc1
Cust2, Y, Desc2
How would i select distinct customer names and get all the fields in my
result at the same time?
i know about select distinct name from table
but that only gives my 1 column and i need all the fields to show up.
thanks,
ariAri
The DISTINCT clause applies to ALL columns in the column list of the SELECT
statment. Based on the data you supplied, what are you expecting for the
resultset?
HTH
Jerry
"ari" <ari@.discussions.microsoft.com> wrote in message
news:0FEB617D-F1D3-4B11-A099-B375DB03D4A0@.microsoft.com...
> hey all,
> Name, Inv(y/n), Desc
> --
> Cust1, null, Desc1
> Cust1, null, Desc2
> Cust1, Y, Desc1
> Cust2, null, Desc1
> Cust2, Y, Desc2
> How would i select distinct customer names and get all the fields in my
> result at the same time?
> i know about select distinct name from table
> but that only gives my 1 column and i need all the fields to show up.
> thanks,
> ari|||ok i understand now. Thank you.
"Jerry Spivey" wrote:

> Ari
> The DISTINCT clause applies to ALL columns in the column list of the SELEC
T
> statment. Based on the data you supplied, what are you expecting for the
> resultset?
> HTH
> Jerry
> "ari" <ari@.discussions.microsoft.com> wrote in message
> news:0FEB617D-F1D3-4B11-A099-B375DB03D4A0@.microsoft.com...
>
>