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.



5 Comments

    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.


Sorry, the comment form is closed at this time.