Logparser 2.2
on 01.19.05, 03:52pm in software • comments (5)
Finally! I can finally mention that LogParser 2.2 is out the door. Congrats to Gabriele who did a fantastic job on it - I was fortunate to be able to play with these bits and offer feedback through it’s alpha/beta cycle, and I can say that the new features are downright awesome.
It’s new support for XML, NETMON capture files, chart outputs and custom COM plugin’s (yes you can write your own input format in C#) makes this a worthy upgrade.
For example, say you wanted to quickly display the latest entries from the MSDN blogs RSS feed:
logparser "SELECT title FROM http://blogs.msdn.com/MainFeed.aspx#/rss/channel/item" -i:XML -fMode:Tree
returns:
title
——————————————————————————–
Virtual Strategy Magazine
3 reasons to consider a career as a Microsoft SDET
Primer encuentro con EDRA.
Week Three: Still running as "Limited User"
Passed my first MCP exam in 10 years
SMS 2003 Documentation
or, how about something more interesting, like a chart of the post count for the most recent posts:
LogParser.exe "SELECT dc:creator AS Poster, COUNT(*) AS Posts INTO Chart.gif FROM http://blogs/MainFeed.aspx#/rss/channel/item GROUP BY Poster ORDER BY Posts DESC" -i:XML -charttype:bar3d -fMode:Tree
Creates a nice 3d bar graph. This rocks.




thomas woelfer (January 19, 2005 @ 5:21 pm)
Steve,
great! will play with this first thing tomorrow…
WM_THX
thomas woelfer
Coding Horror (August 24, 2005 @ 2:25 pm)
Microsoft LogParser
Ask yourself this question: what if everything could be queried with SQL? Microsoft’s LogParser does just that: it’s an application that lets you slice and dice a variety of log file types using a common SQL-like syntax. It’s an…
Coding Horror (August 24, 2005 @ 2:26 pm)
Microsoft LogParser
Ask yourself this question: what if everything could be queried with SQL? Microsoft’s LogParser does just that: it’s an application that lets you slice and dice a variety of log file types using a common SQL-like syntax. It’s an…
Paul Cooley (November 28, 2006 @ 7:43 am)
A FYI it appears the link below no longer contains your 3d bar graph.
http://smakofs.members.winisp.net/blog/chart.jpg
Steve (November 28, 2006 @ 8:17 pm)
Yup, my other blog closed 2 years ago.