« Previous Next »

• 08-27-2009, 2:30 PM

  jhpope Joined on 08-27-2009, 2:21 PM Posts 2

  Trouble with iCheckpoint IISW3C to SQL Reply Contact I am using Logparser to parse IIS logs into SQL. I am trying to use iCheckpoint to avoid duplicate entries. The query works, but when I run the query again, the SQL table doubles and the same entries are added. So it seems it is not picking up from where it left off. I'm just using test logs so nothing is being added to them so I assume no entries should be added to the table.  Here is my query LogParser "SELECT TO_TIMESTAMP(date, time) AS date, SUBSTR(cs-uri-query, 8) AS csuriquery, cs(Referer) INTO TestTable FROM C:\TestLogs\u_ex*.log WHERE cs-uri-stem = '/Index.Aspx' AND cs-method <> 'POST' AND cs(User-Agent) NOT IN (SELECT cs(User-Agent) FROM C:\TestLogs\bots.list)" -i:IISW3C -iCheckPoint:C:\TestLogs\checkPoint.lpc -o:SQL -server:testServer -database:TestDB  Thanks

• 08-27-2009, 3:50 PM

  In reply to

  joelangley Joined on 07-20-2008, 6:37 PM Posts 180	Re: Trouble with iCheckpoint IISW3C to SQL Reply Contact I assume the checkpoint file is created right? Also, no security issues with reading the file once it is created? Just want to be sure. Check out my blog for other cool tips and tricks: http://joelangley.blogspot.com/

• 08-27-2009, 4:11 PM

  In reply to

  jhpope Joined on 08-27-2009, 2:21 PM Posts 2

  Re: Trouble with iCheckpoint IISW3C to SQL Reply Contact Yes the check point file is created. I think the problem might be in my trying to filter out bots. I created an IISW3C formatted file and put cs(User-Agent) entries of known bots in there. I had to make it IISW3C formatted or it would give an input error. I think logparser might be looking at this file as "input" and trying to checkpoint it. Does that make sense?