Log Parser Studio

If you have ever used Log Parse (go try it if you haven’t) then you know it is a really powerful for obtaining valuable information from IIS, Exchange and other logs. Essentially you use SQL-like queries to query one or more logs and return data and even charts. These sql scripts can be  run from the command line or saved as files. The only thing missing is a GUI to front-end Log Parser and a library of scripts. Enter “Log Parser Studio”!

Log Parser Studio gives you the following features:

• Store all queries in one location with informative descriptions
• Edit and create new queries and then save them for later
• Search for queries
• Import and export from the library
• Execute queries
• Create and run batches of queries (which will run multi-threaded)
• Scheduling of queries to run unattended (automation)
• Supports various keyboard short-cuts.

Supported Input Types

Full support for W3SVC/IIS, CSV, HTTP Error and basic support for all built-in Log Parser 2.2 input formats. In addition, some custom written LPS formats such as Microsoft Exchange specific formats that are not available with the default Log Parser 2.2 install.

Query Library

Edit and results screen

 

Go get LPS now! (needs Log Parser also.)

SMTP Service not logging in Win2008

Had an issue where SMTP on a Win2008 box was not logging to files, even though i had turned on logging in the SMTP properties. It seems that there is a dependency for logging to also have the ODBC logging module enabled when you add the IIS roles to the server. Without this, logging to files will NOT work.

Something to be mindful of.

 

http://social.technet.microsoft.com/Forums/en/winservergen/thread/7a6d2b5f-4232-425a-bb2a-bcb7423f6e32

Use Beyond compare as your diff / merge tool in TFS 2010

Follow these instructions to configure. (is definitely worth it!)

Diff

1. In Visual Studio Choose Options from the Tools menu.
2. Expand Source Control in the treeview.
3. Click Visual Studio Team Foundation Server in the treeview.
4. Click the Configure User Tools button.
5. Click the Add button.
6. Enter ".*" in the Extension edit.
7. Choose Compare in the Operation combobox.
8. Enter the path to BComp.exe in the Command edit.
9. In the Arguments edit, use:
   %1 %2 /title1=%6 /title2=%7

2-way Merge (v3 Pro)

1. Follow steps 1-6 above.
2. Choose Merge in the Operation combobox.
3. Enter the path to BComp.exe in the Command edit.
4. In the Arguments edit, use:
   %1 %2 /savetarget=%4 /title1=%6 /title2=%7