Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [logparser]

47 questions
86
votes
8 answers

Recommended LogParser queries for IIS monitoring?

As Stack Overflow grows, we're starting to look closely at our IIS logs to identify problem HTTP clients -- things like rogue web spiders, users who have a large page set to refresh every second, poorly written one-off web scrapers, tricksy users…
Jeff Atwood
  • 12,994
  • 20
  • 74
  • 92
18
votes
11 answers

Any freeware IIS log analyzer?

It would be nice to use ASP.NET, but PHP is ok too, and should be hosted in IIS6. EDIT: the logs are from our intranet site.
alexandrul
  • 1,435
  • 2
  • 19
  • 25
13
votes
5 answers

What is a good SQUID Logs Analyzer?

Can anyone recommend me a good tool for analyzing squid logs ? I'm currently using SARG. Is there something better? I need to easily see what sites were visited/denied, when and by whom. There is a list of squid analyzers. Some of them seem to be…
Jindrich
  • 4,958
  • 8
  • 29
  • 42
5
votes
2 answers

Using LogParser to generate average response time graph

How can I get this graph: (from Speeding up StackExchange) It shows what percentage of web requests took longer than N seconds. I have IIS logs and LogParser installed but not sure how to proceed.
Pavel Chuchuva
  • 201
  • 2
  • 8
4
votes
3 answers

LogParser for Apache like Microsoft IIS LogParser

Is there a tool for Apache comparable to Microsoft's II LogParser?
jack
  • 167
  • 1
  • 7
3
votes
0 answers

I am looking for software that can parse emails and expect emails within a grace period

I manage a diverse set of backup systems, the only commonality is email notifications, There status being Failed, Success, Success with exceptions and unknown(where the email isn't sent). Case 1) Expect email from system3@example.net every day, at…
Jacob Evans
  • 7,636
  • 3
  • 25
  • 55
3
votes
2 answers

How to use logparser to query IIS log entries logged in the past N minutes?

The host is located in the EDT time zone. Event logs are logged using EDT. IIS logs are getting logged using UTC, and I'm not sure which logparser construct helps account for UTC. For example, Windows event logs, logged in local time, entries…
ApexRx
2
votes
2 answers

LogParser and Quantize: Add 0 for empty values

I use LogParser on my IIS Log to get a graph of accesses per hour: SELECT date,QUANTIZE(time,3600),COUNT(*) FROM ex*.log WHERE cs-uri-stem LIKE '%SomePage.aspx' GROUP BY date,QUANTIZE(time,3600) The problem: If there is no access to SomePage.aspx…
Michael Stum
  • 4,010
  • 4
  • 35
  • 48
2
votes
4 answers

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 with this kind of processing? I'm looking for…
dsldsl
  • 141
  • 1
  • 3
2
votes
1 answer

How to parse s3 logs?

I've been trying to parse AWS S3 logs following the documentation, but I've been running into some problems. Specifically, I keep running into new, rare log lines that break my regex. Every time this happens, I modify my regex to account for these…
Talia
  • 201
  • 1
  • 8
2
votes
1 answer

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 day number less than or equal to 12) So immediately…
Fidel
  • 363
  • 1
  • 4
  • 18
2
votes
1 answer

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 from C:\Logfiles\IIS_Log.csv" -i:CSV -o:SQL…
Sean Long
  • 435
  • 1
  • 6
  • 18
2
votes
1 answer

Log Parser IIS Users

I am trying to import iis log to mysql database but I am only getting part of the file. I am using this code: LogParser "SELECT * INTO iisLog FROM \\appdev1\c$\inetpub\logs\LogFiles\W3SVC1\u_ex130312.log" -i:W3C -o:SQL -server:app4 -database:iislogs…
user2158283
  • 23
  • 5
2
votes
1 answer

LogParser: Find all log rows where session cookie = the session cookie found in a row that had an error

Looking for examples of integrating LP into this workflow: A SQL server event indicates IIS tossed an error. SQL parses the body of the error message and generates an LP commandline that queries IIS logs to collect more information. An email is…
justSteve
  • 839
  • 1
  • 7
  • 19
2
votes
2 answers

LogParser query to grab only external IP addresses from IIS logs?

I'm working on a public website that is used by both external visitors and internal employees. I'm after the external visitor hits, but I can't think of a good way to filter out the internal IP ranges. Using LogParser, what is the best way to…
Josh
  • 245
  • 3
  • 8
1
2 3 4