Has anyone used the Log Parser 2.0 Tool from Microsoft?

[Jesus4u]

Here is the link.

http://www.microsoft.com/windows2000/downloads/tools/logparser/default.asp

How in the world do you use it? I know how to register the dll etc.. But to execute the queries and such from VB?

Thanks Exams Passed: 70-152, 70-175, 70-176, 70-100

 

[BillColq]

Yes, it's pretty cool. For instance, if I want to run a survey app and then parse the log files for who has completed it, I run at CMD:
C:\Program Files\Log Parser>logparser -i:NCSA -o:NAT "select UserName FROM c:\winnt\system32\logfiles\w3svc1\nc030324.log WHERE Request LIKE '%ThankYou%'"

The ThankYou.aspx page is the final survey completion page. Logparser.exe returns:

UserName
----------------
NYSDSSALB\GG0652
NYSDSSALB\GG0652
NYSDSSALB\GG0652
NYSDSSALB\8099ZZ
NYSDSSALB\8099ZZ
NYSDSSALB\8099ZZ
NYSDSSALB\8099ZZ
NYSDSSALB\8099ZZ

So it is useful for data mining. And you can use it for many other log files.