Log Parser Lizard GUI (free edition) - Lizard Labs

Using Lizard to parse PPS Planning logs.

1. Create a header file.

DateTime Event PPS Location User Details

Note that spaces delimit the file.

2.  Create a new Log Parser Lizard Group & Query for PPS.

3. Select Tab-separated and space-separated values

4. Enter Query

select top 100 *
from '\\Path_To_PPS_Server_Logs\trace log\server.log'
--where details like '%error%'
order by rownumber desc

5. In Query Properties:

iHeaderFile = <step 2 filename>
nFields = 6
iSeparator = ‘space’
FixedSep = true

Save and “Generate” (run) the query.

 

Log Parser Lizard GUI (free edition) - Lizard Labs

Log Parser Lizard GUI (free edition) - Lizard Labs

 

Click here to download Log Parser Lizard

Log Parser is a very powerful, free and 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 Microsoft Windows operating system, such as the event log, IIS log, the registry, the file system, and the Active Directory services.

Because the command-line interface is not very intuitive, I have created Log Parser Lizard, a GUI tool for managing queries, exporting results to Excel, charts, etc… In addition I have added input filters for RegEx and log4net input log formats (with support for regular expressions) and SQL server T-SQL queries. There are some helpful examples included in installation package to help you start using Log Parser Lizard (and it’s SQL like syntax) for a web log analyzer and system log analyzer.  

Log Parser Lizard GUI (free edition) - Lizard Labs

Jon Gallant's Blog : Most Popular Microsoft Blogs – January 09

Microsoft PerformancePoint Team Blog was #81.  I wonder how it’s looking this month…

The Microsoft blogs solution has a lot of great features, but an important feature that is missing is popularity metrics. I want to know what the community is most interested in and keep up on all things Microsoft. The “all posts” feed that comes OOB doesn’t do the trick. My team inherited the Microsoft blogs apps (http://blogs.msdn.com/, http://blogs.technet.com/) recently and we are in the process of looking at adding new features to support many views over the data. Until we have all the details fleshed out I will continue post the 100 most popular MSDN and TechNet blogs on a monthly basis…complete with Opml so you can subscribe to them all at once.

Jon Gallant's Blog : Most Popular Microsoft Blogs – January 09