Cheers for the reply, but can it really be corrupt log files? I mean with a FROM of "FROM C:\LogParser\109\ex99*.log" it should only be looking at logfiles that have names that begin with ex99, there are none of these in the specific folder in question which is why it's strange it's bringing back results...

I would suspect corrupt log files. You could try a quick test like this to start with: "logparser -i:IISW3C -e 1000 "SELECT DISTINCT LogFilename FROM C:\LogParser\109\ex99*.log" And then if that looks correct, you could try adding the LogFilename and LogRow fields to your normal output and see where...

Hi. I've been writing a few scripts to consolidate IIS logfiles from some sites running on a webfarm in to single IIS files that are to be migrated to a single server setup. I'm doing this in a few steps as I had performance problems and crashes if I tried to process a few years of data in one go Step...

I don't think this is something you could easily do straight from LP. If you can't re-import the data, you probably need to look at using a different tool to update the table. As I just mentioned to someone else, an ETL tool like Kettle (http://kettle.pentaho.org) might help.

I've been doing more reading but still cannot find if there is a way to do this. Is this possible?

Hello, I have been using a SELECT * statement before to put all the IIS log info into a SQL table and it works fine. I want to add 1 extra column to the SQL table though (a primary key). It wont let me use the select * statement anymore because the fields do not match. I even tried specifying the fields...

have a sample log entry from your smtp log that you can match against? SELECT TOP 20 QUANTIZE(time, 3600) AS SERVER(Hour), Count(*) as Hits FROM \\server\*.log TO c:\output.txt WHERE TO_LOWERCASE(cs-uri-stem) LIKE 'sample unauth log entry' GROUP BY SERVER(Hour) ORDER BY SERVER(Hour) ASC

I'm trying to run logparser to check for unauth smtp access on one of my bridgehead servers. we are decomminssioning this server and i want to be proactive about making sure no one's app breaks and that they are still not pointing to this server. i want to do this by running logparser against the smtp...

hi, i need to parse a large amount of IIS log files into an access database - i am currently using the output SQL to access using a shell script from my VB app but on a large amount of log data (in my case current around 650MB) it is taking forever - has anyone got any alternative suggestions? thanks...

I'm new to the sharepoint process. I have downloaded the log parser. Followed the DEP config setup but I can't get the process to parse the IIS log files. I don't see any additional instructions. What i'm I missing?