Anders Lundström 'TODO: Write something clever here
LOGPARSER #23: Get OS version from users hitting your site
This script check OS version on users hitting yours site. You’ll first need a way to extract unique...
Date: 10/21/2009
Windows 7: Testing Visual Basic 6.0 on Windows XP Mode
Installed Virtual PC for Windows 7 and Windows XP Mode (from here) and though I give it a try using...
Date: 10/21/2009
LOGPARSER #22: Domains referring traffic to your site
SELECT EXTRACT_TOKEN(cs(Referer), 2, '/') AS Domain, COUNT(*) AS [Requests] INTO...
Date: 10/21/2009
LOGPARSER #21: Get bytes per extension
This script will give you the amount of bytes sent by each file type, for example pictures, ASPX...
Date: 10/21/2009
LOGPARSER #20: Check Browser types split between your unique users
My previous post (#2) gave you browser types, hits and post (#19) gave you additional information...
Date: 10/20/2009
LOGPARSER #19: Browser types with most hits/used
My #2 post gave you just browser types and hits, this script will give you you almost the same data...
Date: 10/20/2009
LOGPARSER #18: Top 10 pages with most hits
Will give you your top pages with most hits and some additional data. If your top 10 pages with most...
Date: 10/20/2009
LOGPARSER #17: Get your broken links
This script will give you site/page refers to your content though your content has moved. SELECT...
Date: 10/20/2009
LOGPARSER #16: Remove those Compilation Debug=True from your prod server
One thing I notice on several of my customers is that it really doesn’t matter how waterproof...
Date: 10/19/2009
LOGPARSER #15: Check traffic from IP addresses
Customer of mine used a hardware load balancer to distribute traffic between their frontend web...
Date: 10/14/2009
LOGPARSER #14: TOP 20 pages with specific HTTP return code
Digging into each ASPX page returning a specific error code. We used this script at a customer to...
Date: 10/14/2009
LOGPARSER #13: Page types with large bytes sent
This is a great script for checking what page types are causing bytes sent SELECT ...
Date: 10/14/2009
LOGPARSER #12: Troubleshoot who is causing your 500 errors?
This script is very interesting tracking down specific users causing errors in your IIS environment....
Date: 10/14/2009
LOGPARSER #11: Megabytes sent per HTTP status code
This script checks amount of bytes sent for different pages and different sc-status. SELECT...
Date: 10/14/2009
LOGPARSER #10: Check your substatus codes
If you find out that you have a large number of sc-status codes, e.g. 401, it could be an idea to...
Date: 10/14/2009
LOGPARSER #9: Check your Win32 errors trends
This script will get you any win32 errors within you IIS logs. SELECT ...
Date: 10/14/2009
Logparser #8: Know your Error trends
This is a script I used at one customer to help the site developers know if any of the recent...
Date: 10/14/2009
LOGPARSER #7: Average time taken per user
Why is this interesting? One of the site developers at one of my customers approached me and said...
Date: 10/14/2009
LOGPARSER #6: Check daily bandwidth
This script checks for daily bandwidth. Great for spotting trends. Select ...
Date: 10/14/2009
LOGPARSER #5: Top 10 slowest ASPX pages
Top 10 pages with the longest time-taken SELECT TOP 10 cs-uri-stem, max(time-taken) as MaxTime,...
Date: 10/14/2009
LOGPARSER #4: Top 10 largest ASPX pages
Script for checking your largest pages. Maybe you can reduce the size of these pages? Good to know...
Date: 10/14/2009
LOGPARSER #3: Unique users per day
This is a combination of two scripts you need to use to get the unique number of users each day....
Date: 10/14/2009
LOGPARSER #2: Know what browsers your users have
This script will give you all the browser types hitting your site, order by most used. SELECT...
Date: 10/14/2009
LOGPARSER #1: Top 10 images by size sent
This script is an easy way of checking if any of your pictures take up too much bandwidth on you...
Date: 10/14/2009
LOGPARSER #0: Get started with logparser
I’ve used Logparser on several occasions at my customers and it’s always fun to show just how much...
Date: 10/14/2009
Roll your own IE8 Prisjakt Accelerator in 2 minutes!
I often find myself browsing the internet for best prices on technical products like computer parts,...
Date: 10/12/2009