Hi I need to parse logfile from server, but notice that no Date Field are configure -------------- #Software: Microsoft Internet Information Services 6.0 #Version: 1.0 #Date: 2008-01-06 00:01:02 #Fields: time cs-method cs-uri-stem cs-uri-query cs-username c-ip cs-version cs(User-Agent) cs(Cookie) cs...

Well this query did not work: SELECT* FROM c:\logs\april2007\*.* WHERE cs(uri-agent) NOT IN(SELECT botname FROM badbots.csv)" i:IISW3C o:W3C The second select is being executed as having the input format specification IISW3C.

Hope this is useful to an apprentice like myself: After some trial and error I have a working version of the second query using multiplexing. The first query simply filters out rows containing a certain string from an aggregate of IISW3C input sources and outputs to a single w3c output format file named...

I raised the question below to google groups and received an answer (also below). I'm new to SQL, Logparser, scripting with autoit, and IIS so please excuse my ignorance. I'm having trouble with syntax despite having looked at the documentation. I need to figure our how to write the two queries suggested...

Write out the outputs of the first query to a text file using executeBatch then run the second query against that one.

in qwery- select 1 as id, ... from iisw3c_file and set id in your real sql table as int, identity - yes id's in your real sql table will be 1,2,3,4,5,6,...

hi, can i do this using the LP COM API let's say, in VB.NET? thanks

Hi, Am i glad to find this forum... I trying to get this syntax correct and when ever i try to access the source file from a \\Share or a c:\ paths i keep getting an error of: The system cannot find the path specified. ***Here is my query****** "SELECT DISTINCT cs(Cookie) FROM C:\Documents and Settings...

Phil, It has been since v2.0 that I did a lot with LogParser. I *do* remember that there were some logfiles on our intra-net server that for whatever reason, were completely munged. At that time, the fix I resorted to was to list the IN_ROW_NUMBER of the output and then built a two part query to take...

I'm a rookie (obviously) with LogParser but was hoping to use this tool to capture a when users have logged in (date and time) to a specific site grouped by user name. The site is a Sharepoint site so there is domain\username information available but I'm hoping to be able to capture when users visit...