This script check OS version on users hitting yours site. You’ll first need a way to extract unique users. If you use Windows Authentication you can use cs-username to get unique users. SELECT     DISTINCT cs-username,    ...

Installed Virtual PC for Windows 7 and Windows XP Mode (from here ) and though I give it a try using Integration Features with Visual Basic 6.0. After VPC and XP Mode was installed you’ll get two new menu items and one folder for integrated apps If you...

SELECT    EXTRACT_TOKEN (cs(Referer), 2, '/') AS Domain,   COUNT(*) AS [Requests] INTO    ReferringDomains.txt FROM      logs\iis\ ex*. log GROUP BY    Domain ORDER BY    Requests DESC //Anders

This script will give you the amount of bytes sent by each file type, for example pictures, ASPX pages etc. Great if you need to work with size/performance. SELECT        EXTRACT_EXTENSION( cs-uri-stem ) AS Extension,    ...

My previous post (#2) gave you browser types, hits and post (#19) gave you additional information like hits and percentage of hits between browsers. This script will give you more details as it looks at browser type for each unique user and give you the...

My #2 post gave you just browser types and hits, this script will give you you almost the same data but with percentage. Great for security checks etc. SELECT   TO_INT(MUL(100.0,PROPCOUNT(*))) AS Percent,    COUNT(*) AS Hits,   cs...

Will give you your top pages with most hits and some additional data. If your top 10 pages with most hits are the same as your top slow pages and/or largest you might want to do something about it. Select    TOP 10    STRCAT(EXTRACT_PATH...

This script will give you site/page refers to your content though your content has moved. SELECT     DISTINCT cs(Referer) as Referer,     cs-uri-stem as Url INTO     ReferBrokenLinks.txt FROM    ...

One thing I notice on several of my customers is that it really doesn’t matter how waterproof process you have for deploying web applications, and web.config files in particular. You’ll always end up with at least one web app somewhere with Compilation...

Customer of mine used a hardware load balancer to distribute traffic between their frontend web servers. This script that I put together gave them a chance to check whether traffic was distributed evenly between servers (K’s, Hits), if average wait time...

Digging into each ASPX page returning a specific error code. We used this script at a customer to get the pages with most 401 errors and also checked pages with most hits. You’ probably find these to be almost the same list. If you have Windows Authentication...

This is a great script for checking what page types are causing bytes sent SELECT     EXTRACT_EXTENSION(cs-uri-stem) AS PageType,     SUM(sc-bytes) as TotalBytesSent,     TO_INT(MUL(PROPSUM(sc-bytes), 100.0...

This script is very interesting tracking down specific users causing errors in your IIS environment. Could be a physical person or a tool configured to run under a domain account. One of my customers had a tool for checking site availability and it was...

This script checks amount of bytes sent for different pages and different sc-status. SELECT     EXTRACT_EXTENSION(cs-uri-stem) AS PageType,     SUM(sc-bytes) as TotalBytesSent,     TO_INT(MUL(PROPSUM(sc-bytes...

If you find out that you have a large number of sc-status codes, e.g. 401, it could be an idea to check the sc-substatus codes. SELECT     sc-status,     sc-substatus,     Count(*) AS Total    ...

This script will get you any win32 errors within you IIS logs. SELECT     sc-win32-status as ErrorNumber,     WIN32_ERROR_DESCRIPTION(sc-win32-status) as ErrorDesc,     Count(*) AS Total    ...

This is a script I used at one customer to help the site developers know if any of the recent deployed updates had any affect on the site errors. SELECT   TO_STRING(To_timestamp(date, time), 'MMdd') AS Day,   SUM(c200) AS 200s,   SUM(c206...

Why is this interesting? One of the site developers at one of my customers approached me and said that “Hey, you know we have a couple of internal users who complain about our website performance. They say its always slow and takes forever for pages to...

This script checks for daily bandwidth. Great for spotting trends. Select      To_String(To_timestamp(date, time), 'MM-dd') As Day,      Div(Sum(cs-bytes),1024) As Incoming(K),      Div(Sum(sc...

Top 10 pages with the longest time-taken SELECT TOP 10 cs-uri-stem, max(time-taken) as MaxTime, avg(time-taken) as AvgTime INTO toptimetaken.txt FROM logs\iis\ex*.log WHERE extract_extension(to_lowercase(cs-uri-stem)) = 'aspx' GROUP BY cs-uri-stem ORDER...

Script for checking your largest pages. Maybe you can reduce the size of these pages? Good to know before a performance test etc Select Top 10 StrCat(Extract_Path(TO_Lowercase(cs-uri-stem)),'/') AS RequestedPath, Extract_filename(To_Lowercase(cs-uri-stem...

This is a combination of two scripts you need to use to get the unique number of users each day. This is for Logparser 2.2 and earlier if i remember correct. Maybe later version will give you this in another way. I’ve seen a variety of samples out there...

This script will give you all the browser types hitting your site, order by most used. SELECT distinct cs(User-Agent), count(*) as hits INTO useragentsalltypes.txt FROM logs\iis\ex*.log GROUP BY cs(user-agent) ORDER BY hits DESC //Anders

This script is an easy way of checking if any of your pictures take up too much bandwidth on you site. Maybe you can resize them or change resolution?  Select   Top 10   StrCat(Extract_Path(TO_Lowercase(cs-uri-stem)),'/') AS  ...

I’ve used Logparser on several occasions at my customers and it’s always fun to show just how much valuable info you can dig out by this free tool. Many developers have notused Logparser and don't know its capabilities and I also often discover that developers...