Anders Lundström 'TODO: Write something clever here

  • Article

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...

Author: Anderslu 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...

Author: Anderslu Date: 10/21/2009

LOGPARSER #22: Domains referring traffic to your site

SELECT    EXTRACT_TOKEN(cs(Referer), 2, '/') AS Domain,   COUNT(*) AS [Requests] INTO...

Author: Anderslu 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...

Author: Anderslu 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...

Author: Anderslu 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...

Author: Anderslu 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...

Author: Anderslu Date: 10/20/2009

This script will give you site/page refers to your content though your content has moved. SELECT...

Author: Anderslu 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...

Author: Anderslu 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...

Author: Anderslu 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...

Author: Anderslu 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    ...

Author: Anderslu 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....

Author: Anderslu 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...

Author: Anderslu 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...

Author: Anderslu Date: 10/14/2009

This script will get you any win32 errors within you IIS logs. SELECT    ...

Author: Anderslu Date: 10/14/2009

This is a script I used at one customer to help the site developers know if any of the recent...

Author: Anderslu 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...

Author: Anderslu Date: 10/14/2009

LOGPARSER #6: Check daily bandwidth

This script checks for daily bandwidth. Great for spotting trends. Select     ...

Author: Anderslu 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,...

Author: Anderslu 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...

Author: Anderslu 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....

Author: Anderslu 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...

Author: Anderslu 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...

Author: Anderslu 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...

Author: Anderslu 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,...

Author: Anderslu Date: 10/12/2009