I'm trying to find LONG UserAgent strings with LogParser.exe in my IIS logs. This example searches for entries with the string 'poo' in them. LogParser.exe -i:IISW3C "SELECT COUNT(cs(User-Agent)) AS Client FROM *.log WHERE cs(User-Agent) LIKE '%poo%'" I'm trying to say "How many entries have a User-Agent that is longer than 'x'". ...
Hi, I'm looking for a simple IIS Log Viewer that can open large (e.g. 100 meg) IIS Log files and give me simple filtering and searching tools. (IIS = Microsoft Internet Information Server, obviously) (OK, I know I could use Notepad, but I'd like something that can help me filter out the bits I'm not interested in) ...
What are you favorite LogParser 2.2 Scripts to run against IIS logs and Event logs? I am putting a list of scripts together to run against our production environment to proactively look for issues and to help when isolating performance problems. Do you have a certain list of LogParser 2.2 scripts that you use? ...
I just started using Log Parser Lizard to examine my IIS and Event logs. What UI tool do you use on top of LogParser 2.2 to view your log files on production? ...
Is it safe to run LogParser against our live production IIS log file? Currently, I have been copying it over to another location and then running LogParser 2.2 against the log file. Instead, I would really like to run it against the live data so that I can see changes to it immediately, however, I am a little concerned that it might ca...
So basically we have lots of SharePoint usage log files generated by our SharePoint 2007 site and we would like to make sense of them. For that we're thinking of reading the log files and dumping into a database with the appropriate columns and all. Now I was going to make an SSIS package to read all the text files and extract the data w...
Using logparser you can pass on parameters to the query you'd like to run such as: logparser file:query.sql?logs=somewhere\*.log -o:Sql -server:databaseserver -database:database -createtable:ON -i:IISW3C -iCheckPoint:somewhere\query.lpc -transactionRowCount:200 Now I want to pass a second parameter to the sql query but it doesn...
Hello there I am suddenly resposible for debugging/finding out what is wrong with an asp.net application that crashed its ApplicationPool some days ago. The 5 errors within 5 minutes failsafe we had set took it down. The problem is that it was still served pages and thus returned a 503 for just some visitors. We have inadequate logging ...
I'm importing IIS logfiles into a SQL database but for some reason not every entry makes it into the database. For instance if the logfile has 1,000,000 entries logparser does say that it processed 1,000,000 entries but if I do a SELECT COUNT(*) in the database I don't have 1,000,000 rows of data. Has anyone seen this issue before ? ...
I have IIS log with extra field 'foo'. #Fields: foo date s-sitename ... foo1 2009-02-15 W3SVC1 ... foo2 2009-02-15 W3SVC1 ... As result all LogParser queries are broken: logparser -i:IISW3C "SELECT c-ip, s-ip FROM my.log" Statistics: ----------- Elements processed: 0 Elements output: 0 Execution time: 0.00 seconds Is it p...
Hi Guys, Im trying to run some logparser commands from powershell but Im having issues with passing the arguments across correctly, heres the excert from my script; d:\scripting\smtplogs\logparser\logparser.exe "SELECT TOP 50 Receiver, COUNT() INTO %TMPOutput%\TopReceiversNDRALL.gif FROM %TempDir%\PostAll.log WHERE Sender LIKE '<>' AND...
Hi Guys, This is a weird one, Im using logparser to work through some log files and present some output. The input to logparser is being created by some powershell scripts that Ive written to replace the existing batch files. Heres a sample of the original input files; 10.197.71.26 AU 03172009 23:59:59 21 116490096 As you can see ...
LogParser isn't open source and I need this functionality for an open source project I'm working on. I'd like to write a library that allows me to query huge (mostly IIS) log files, preferably with Linq. Do you have any links that could help me? How does a program like LogParser work so fast? How does it handle memory limitations? ...
Is it possible to use early binding with LogParser.dll on VB6/VBA? When I try to set a reference to it, it just disappears with no error. ...
Hello, I've developed a WinForms app that I've that shows the bandwidth a single IIS site using LogParser. This worked quite well. I've now written the exact same thing in ASP.net, but then the following exception is thrown: Cannot find any file matching "C:\inetpub\logs\LogFiles\W3SVC4\ex*.log" The exception makes sence, since all ou...
I'm writing a small program in Ruby to parse a hand history log from a poker site. The log is split over several lines and looks a bit like this: Table 123456 NL Hold'em $1/$2 5 Players Seat 3 is the button Seat 1: randomGuy112 $152.56 Seat 2: randomGirl99 $200 Seat 3: PokerPro $357.12 Seat 4: FishCake556 $57.19 Seat 6: MooMoo $188.98 D...
Is there a new or different product that people are using? Are there no new features people can think of? Is it not being used by many people? Or, has Microsoft just decided not to invest any more resources into it? I am trying to assess whether this is still a good enough tool to use, even though it appears it is no longer being suppo...
I am using the Microsoft Log Parser in a Windows Service. The program works in a regular web page but when I put the code in a windows service it does not work. I put Breakponts in the windows service but when I run the code the program does not stop at the breakpoint. So through out my troubleshooting I have narrowed the problem down t...
004 2008-11-23 02:18:49 0 %%827|1.1.1593.0|{9CB31878-8FED-45F4-B45F-AF8A3EC94F7A}|||||WIN|108510|S-1-5-21-1229272821-838170752-1417001333-21676|Unknown||0|44|http://go.microsoft.com/fwlink/?linkid=74409|service%3AW32Times;file%3AC:\WINDOWS\system32\w32times.exe|0|%%807|||||||Not Yet Classified|Not Yet Classified|| I have the ab...
I'm trying to count the number of hits for a particular URL on our web site by parsing our IIS logs using Log Parser 2.2. Everything seems to be working fine, except that its handling of timestamps is greatly confusing me. The IIS logs have all of the timestamps expressed in UTC time. Therefore, in my application, I convert the server's...