Robert McMurray : LogParser

Using LogParser with FTP 7.x Sessions

Robert McMurray's Blog [MSFT] — Fri, 12 Jun 2009 02:15:00 GMT

One of the great features that we added to our W3Clogging enhancements in FTP 7.0 and FTP 7.5 is the ability to track unique sessions, which are represented by GUIDs in a field that is named x-session . Because of this addition, you can do some interesting things with LogParser when analyzing your FTP logs. The purpose of today's blog is to show a couple of the scripts that I use to analyze some of the session-based information that I'm interested in from time to time. Using LogParser to Count FTP Sessions Since the new FTP service tracks unique sessions, it is now possible to generate reports that show the number of unique FTP sessions you served by day. The following batch file accomplishes this in two parts: first it creates a temporary tab...(read more)

Data Mining UrlScan 3.0 Logs using LogParser 2.2

Robert McMurray's Blog [MSFT] — Wed, 10 Sep 2008 20:04:00 GMT

We released a new version of UrlScan recently, and one of the great new features in this version is log files that conform to the W3C Extended Log File Format . What this means to administrators is that they can now parse their UrlScan activity using almost any common log utilities, including Microsoft's LogParser 2.2 utility. For anyone that hasn't heard of LogParser, this is a freeware utility from Microsoft that allows you to write SQL-style queries to extract useful information. Eventually I'd like for the following information to show up on the http://learn.iis.net/ web site, but for now I'd like everyone to at least have access to the information. Getting Started Downloading and Installing UrlScan and LogParser The download locations for...(read more)