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

Search

Most popular posts
in last 360 days

Categories

My Projects

Archives

Stuff


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.