The logparser tag has no wiki summary.
0
votes
3answers
44 views
How to optimize mysql insert using perl?
ive got log parser on perl and it uses mysql insert or update command on every line. Like:
Log line 1: 2012-12-01 12:12 [perld] Hello world #1
....
Log line N: 2012-12-01 12:NN [perld] Hello world #N
...
0
votes
1answer
69 views
Can Logparser query newer log file types on 2008
I am trying to research a problem and would like to use Logparser to remotely query one of the newer 2008 log types against many remote servers. I want to query the Setup log, not application, system, ...
1
vote
1answer
202 views
Merging Large IIS Logs
I am planning on using Webalizer to analyze and graph our IIS logs, but because we have a server farm Webalizer requires me to make sure that all of the logs are in chronological order (or else it ...
1
vote
2answers
90 views
How do I count successful Domain User Authentication (Log Ins) with LogParser
I need to be able to count only successful authentication attemtps for our IIS based Web Portal. All users come from the same IP Address. Is there something specific in the w3c logs to look for in ...
0
votes
1answer
88 views
looking for a pattern in iis files with logparser s
I am looking to extract from iis
when a certain user session indicated here by aspnetsessionid times out prior to 10 minutes session timeout I have set on this application.
I am trying to parse ...
0
votes
2answers
126 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 ...
1
vote
1answer
220 views
Logparser for Linux (syslog) logs?
I'm looking for something like logparser on Windows.
Requirements:
simple tool, not engine like octopusy or sth,
able to select on text in message part,
start search in log from checkpoint on ...
0
votes
1answer
74 views
Counting messages through sendmail
The back story here is that I would like to start using an SMTP service to start sending my email (currently sent though sendmail running locally on the server), but in order to get a good idea of ...
0
votes
1answer
165 views
Rsync log parser
What would be a good tool to parse rsync server daemon log files?
Thanks in advance
1
vote
1answer
132 views
search logs for events associated with Task Scheduler
I'm working with a Server08 box (Web Edition) where the Task Scheduler had run a set of unchanged housekeeping scripts for months. Over the last week, Scheduler has failed to start scripts twice.
...
0
votes
1answer
348 views
Reviewing IIS 6.0 Logs with LogParser 2.2 for FTP logins
I've been using the Striving Life website for his IIS FTP LogParser 2.2 queries. My only issue is that I can't seem to combine the two queries that bring back both successful login AND their account ...
1
vote
3answers
269 views
LogParser for Apache like Microsoft IIS LogParser
Is there a tool for Apache comparable to Microsoft's II LogParser?
2
votes
2answers
1k views
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.
...
1
vote
1answer
160 views
Why does a pdf file download result in varying bytes logged, all with sc-status 200
I have a mojoportal CMS installation on an IIS7 server where users are reporting problems downloading a pdf file. It always downloads fine for me and most others, either displaying in browser or in ...
2
votes
1answer
231 views
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 ...
0
votes
1answer
73 views
need help with logparser on iis logs
I am using logparser 2.2 and need a script that does two things:
finding urls that contain a value within referer
need to loop over 30 folders
logparser -rpt:-1 "select count(*)INTO feeds.txt from ...
1
vote
2answers
377 views
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 ...
2
votes
3answers
786 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 ...
0
votes
1answer
260 views
logparser Message with error codes
Is there anyway to get complete error message using LogParser?
When I run the following query:
logparser -i:EVT -o:NAT "SELECT TimeGenerated,EventID,Message from System WHERE EventTypeName='Error ...
0
votes
2answers
2k views
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, ...
0
votes
1answer
626 views
Getting Concurrent Session Metrics from IIS Raw Logs?
I have IIS 6 and 7 raw log files and the Log Parser tool version 2.2 and I want to find the peak/max concurrent sessions per day that are recorded on the logs for the last 30 days. Is there a quick ...
61
votes
8answers
13k views
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, ...
12
votes
10answers
7k views
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.
2
votes
2answers
604 views
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)
...
