Bite my bytes

What I learn by day I blog at night - A blog from Microsoft Consultant working from Ljubljana, Slovenia

  Home :: Contact :: Syndication  
  999 Posts :: 7691 Comments :: 235 Trackbacks


Most popular posts
in last 360 days


My Projects



Copyright © by David Vidmar
Contact me!
LinkedIn Profile

LogParser 2.2 is out. If you are any kind of admin and you haven't tried this tool, your are really missing out!

Log parser is a powerful, versatile tool that provides universal query access to text-based data such as log files, XML files and CSV files, as well as key data sources on the Windows® operating system such as the Event Log, the Registry, the file system, and Active Directory®. You tell Log Parser what information you need and how you want it processed. The results of your query can be custom-formatted in text based output, or they can be persisted to more specialty targets like SQL, SYSLOG, or a chart.

It looks like there is a lot of work going on with this tools since there are really a lot of new features and other improvements in 2.2. Also, there is a growing community of fans.

I didn't yet master the tool but this is the first LogParser query that I wrote:

  SELECT REVERSEDNS(c-ip) AS Client, c-ip, COUNT(*) AS Requests
FROM ex05*.log 
WHERE Index_OF(cs(User-Agent), 'Mozilla') < 0 AND
cs-uri-stem = '/weblog/rss.aspx'
GROUP BY c-ip, cs(User-Agent)

It will return a list of IPs and addresses with the number of request for a RSS feed in 2005.

And that's what we all wan't to know, right? Who the hell is reading my blog!?

Posted on Thursday, January 20, 2005 9:14 AM | Filed under: Software System |
Comments have been closed on this topic.