The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
17 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 ...
0
votes
0answers
28 views

MS LogParser from a remote computer?

We have a couple of webservers. And have LogParser installed on them. I use remote desktop to log in on a server. Then i use "LogParser Studio" to work with reports and querys. The problem is that i ...
0
votes
1answer
51 views

IIS logparser - Count distinct from cs-uri-query?

I need to count how many DIFFERENT MACĀ“s that have accessed my IIS webserver and have a state value of 1. The "MAC" adress and the "state" value are in the actual query (cs-uri-query) So the log can ...
2
votes
1answer
43 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
59 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
82 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, ...
2
votes
1answer
253 views

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 ...
1
vote
1answer
193 views

Get the SessionID in IIS7 LogParser Query on Site Using SSL

Anyone know how to obtain the SessionID/ASPNET_SESSIONID using a LogParser query? FYI, the site I'm querying uses SSL. Currently, my query is SELECT * FROM 'C:\inetpub\logs\LogFiles\W3SVC6\*.log' ...
0
votes
1answer
318 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
361 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
1k 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
859 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
253 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
219 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
393 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
598 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
246 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
358 views

Rsync log parser

What would be a good tool to parse rsync server daemon log files? Thanks in advance
1
vote
1answer
261 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
781 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 ...
2
votes
3answers
775 views

LogParser for Apache like Microsoft IIS LogParser

Is there a tool for Apache comparable to Microsoft's II LogParser?
4
votes
2answers
2k 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
407 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
298 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
108 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 ...
2
votes
2answers
736 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
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 ...
1
vote
1answer
341 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
4k 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
1k 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 ...
84
votes
8answers
24k 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
7answers
25k views

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 ...
18
votes
11answers
19k 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
804 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) ...