The logparser tag has no wiki summary.
0
votes
0answers
41 views
How to parse pflogsumm output and put into database, CSV or similar
I have set up pflogsumm to generate reports of mail server stats. pflogsumm analyzes the log and prints a nice human readable report. However, I would like to have the raw numbers into a CSV or ...
0
votes
0answers
32 views
Logparser to monitor suspicious mailbox access?
Is it possible, using Logparser or similar, to report on Exchange 2003/2010 mailbox access from users who are not the mailbox owner?
The access might come from an Outlook client or OWA so I presume ...
0
votes
3answers
95 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
243 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
307 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
128 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
109 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
167 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
261 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
91 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
186 views
Rsync log parser
What would be a good tool to parse rsync server daemon log files?
Thanks in advance
1
vote
1answer
151 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
394 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
297 views
LogParser for Apache like Microsoft IIS LogParser
Is there a tool for Apache comparable to Microsoft's II LogParser?
3
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
206 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
252 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
78 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
411 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
882 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
286 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
700 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 ...
62
votes
8answers
15k 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, ...
13
votes
10answers
9k 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
650 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)
...
