I am too tired ..... I posted it and recheck it 2 minutes later and got it working. I hate whan that happens...but at least it's working! This code works so long as your database table matches all of the W3C log names. You can play around with that on the command line to get it correct. Then paste the...

I have struggled with LogParser and I am at a standstill. Here is a snippet of code that I am using. I know that I don;t have an DSN information Set ILogQuery = Server.CreateObject("MSUtil.LogQuery") Set IW3C = Server.CreateObject("MSUtil.LogQuery.w3cInputFormat") strQuery = "SELECT * FROM C:\Inetpub...

As there aren't many samples for this on the web, thought I'd throw out some code that I got working. The query gets hits by uri-stem, and I wanted the date & server name (computer name) fields as well: The database table is pretty simple in my case: CREATE TABLE [dbo].[TableName] ( [log_date] [datetime...