What is the best method providing stats and log in info for my website?

Website info:
150 users
Using IIS with Windows Authentication
ColdFusion for database connectivity

What is the best way to provide website stats for:
Who is logging in and how often
What part of the site is being used most
For the anonymous part - what parts of the website are being used most - IP locations - how often
DJPr0Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dan McFaddenSystems EngineerCommented:
Make sure you've enabled logging in IIS.

At the server level, modify the logging configuration so that all W3C fields are being written to the logs, rotate them daily with 1 log per website.  This configuration will be pushed down to all site on the server, unless specifically overridden at the website level.

Then you can any one of several HTTP log analyzation tools available to pull out the reports that you are looking for.

To analyze HTTP logs, I use LogParser which is from Microsoft (free to download) I use Log Parser Studio as a GUI to the executable (LogParser is a command line tool which uses SQL like syntax to extract data from files).

If you are looking for something more packaged, like Google Analytics, I would recommend Piwik.

Link:  http://piwik.org/

All you have to then do is following Piwik's instructions on integrating your site with Piwik.  You would then have real-time reporting of HTTP activity on your site(s).

Dan
0
DJPr0Author Commented:
How does LogParser run automatically for updated reports?

What is the best way to view the report on your website?
0
Dan McFaddenSystems EngineerCommented:
Log Parser is a command line tool, you would have to configure a scheduled task to run Log Parser.

So you would have to do the following:

1. determine what info is  needed from your http logs
2. create an html template to store the data
3. create the query for #1
4. create a schedule task to run the report every day

Dan
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DJPr0Author Commented:
Thanks Dan!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ColdFusion Language

From novice to tech pro — start learning today.