Log Parser queries to find 400 and 500 http status codes

  • September 9, 2007
  • James Skemp
Note: This article was written using Log Parser 2.2. Therefore, while it may work for a different version, it may not. In a previous article, I discussed how to use Log Parser to find 404 errors in IIS log files. This time, I've made it a little broader, by giving some queries to find all 400 codes, and all 500 codes, through log files. There may be a better way to find these codes (instead of my IN statement), but a standard LIKE doesn't seem to work.

Read More

Is it really that simple - redirecting a single file on IIS

  • September 2, 2007
  • James Skemp
For various reasons, I've been working towards migrating from an Apache server to an IIS one for my sites. For Gavin's site, I couldn't get away with it, but I don't have any problem making things more difficult for myself :D However, this means that old URLs may not be working as they should. My experience with IIS is a working knowledge of it, and therefore I know what I need to know, picking up what I can.

Read More

Find 404 errors using Log Parser

  • August 4, 2007
  • James Skemp
Note: This article was written using Log Parser 2.2. Therefore, while it may work for a different version, it may not. The following code will generate a listing of calls that generated a 404 error. logparser "SELECT cs-uri-stem, cs-uri-query, date, sc-status, cs(Referer) INTO 404report.txt FROM ex*.log WHERE sc-status = 404 ORDER BY date, cs-uri-stem, cs-uri-query" This assumes that you've currently got a command line open in the folder containing your IIS logs, and that you are logging the above information, as well as that logparser is setup in your PATH line.

Read More

Is it past time for Microsoft to open IIS?

  • September 23, 2006
  • James Skemp
There's a reason PHP and Apache are so popular on the Web. It's the same reason that most beginner's, especially those that have no formal training, start with these technologies. In a word, both technologies are not only open source, but free to use. With the right guide, a user can be up and running with Apache and PHP in a couple of hours. Unfortunately, Microsoft's IIS (Internet Information Services) is something that few home-grown Web users have the honour of using.

Read More