0
votes
0answers
84 views

Logparser - Getting average response time from microseconds

I have one month's worth of web server log files in the following format: #Fields: date time cs-uri-stem cs-uri-query c-ip cs(Referer) sc-status sc-bytes time-taken 2014-03-12 17:34:02 ...
2
votes
1answer
54 views

log parser doesn't interpret dates correctly

When I query our IIS logs, I get a value of '30/12/1899' in the date column. select * from 'C:\IIS 2013 Logs\*.log' However for some rows, it does have a valid date. (Coincidently rows that have a ...
2
votes
1answer
75 views

What does -fixcolnames do in log parser 2.2?

I'm using Logparser 2.2 to try to bring a .csv filled with Performance Counter information into a SQL database, and I'm using the following command line command: logparser "Select * into IISCounters ...
0
votes
1answer
98 views

TO_TIMESTAMP(date, time) missing seconds?

When I run log parser using the code below I get the data and time field together as expected but it is missing the seconds. How do you get it to also list the seconds? The two fields look like, ...
1
vote
2answers
469 views

How do I ensure no duplicates when using LogParser to load IIS logs into SQL Server every fifteen minutes?

I would like to set up a scheduled task to run every fifteen minutes on a work web server that will run LogParser on today's IIS log file and insert it into a SQL Server database table. How would I ...
2
votes
3answers
1k views

Akamai log processing

I'm digging through Akamai logs, downloading excel sheets, and then manually joining them so that I can do sorting of data to find top videos and referrers. Are there any tools you know of to help ...