Thank you, I've seen LP 2.2, but was more hoping for something already solutioned for the purposes of identifying attempted threats rather than figuring out relevant LP queries and such on my own. Time crunch and all.
Main Topics
Browse All TopicsI've been scouring google for a decent IIS log analyzer that will help me monitor for simple hacking attempts.
Things like SQL Injection, or integer overloading, etc.
All of the log analyzers I have found are good for showing hits, visitors, etc - which is useful information, but nothing so far has been able to identify that there was an attempted apparent malicious attempt made on our website.
Can anyone recommend one? Commercial or free, doesn't matter.
Note, I'm NOT looking for a URL scanner, ISAPI filter, etc. for preventing these types of attacks - our code has been safeguarded - I'm merely interested in identifying ATTEMPTED threats so we can pass their IPs along to the appropriate authorities.
Right now this involves a manual scan of the logfile every day - which is rather tedious.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Two good log aggregation and correlation tools that may be of use to you
a) Splunk - It is a search engine for IT data. It's software that lets you search and analyze all the data your IT infrastructure generates from a single location in real time. There are community support firum that would be very useful. Also it is highly customisable to monitor and alert upon fraud and malicious event
http://www.splunk.com/prod
http://www.splunk.com/base
http://www.splunk.com/base
b) ModSecurity - An open source product that serves as a pretty good WAFsensors that handles the top 10 common OWASP threats (include those you mentioned). It has a ModSecurity Console that collects the log and alert data in real time from remote ModSecurity sensors. It has an initative called ModProfiler that aims to provide best-possible protection for web applications by analysing web application traffic passing by.
http://www.modsecurity.org
http://www.modsecurity.org
http://www.modsecurity.org
By the way, if you are alright with outsourcing, may be software as service will be advantageous so that you can focus on getting the webapp up and going. Also to focus and activate incident response promptly.
Look at
a) Armorize HackAlert" - It is a hosted Web malware monitoring and detection service. It immediately notifies subscribers if their website has been compromised and is initiating "drive-by-downloads" that target end-user computers. Automated scans identify malicious code and links injected into websites, while customizable real-time alerts detail the malware file type, source and target destination on the end-user PC.
http://www.armorize.com/in
b) Resolvo monitoring services - Provide remote monitoring service that scans for sensitive information leakage that originates from any of your public web sites. All you need to provide us is the list of hostnames to monitor.
http://www.resolvo.com/ser
I looked at Splunk - and stopped looking at it when I noticed that their executable (splunkd.exe) had made an unwanted and unwarranted connection to my domain controller.
ModSecurity appears to be an Apache thing, where we use IIS - I could be wrong on that and it might work on IIS - but in the few minutes that I had to look at the site it appeared to be for Apache.
The other two monitoring services are appreciated but out of scope for this project.
I've also looked at EventLogAnalyzer by Manage Engine (www.eventloganalyzer.com)
I may be faced with rolling my own parser, using LP2 or a custom .net app. I'm surprised (really surprised) that there aren't more commercial apps that perform this type of analysis.
May want to consider the below:
a) AWStats - It does support IIS log but may not be specific in detecting attack, though it highlights "Worms attacks (5 worm's families)"
> http://awstats.sourceforge
In the website, it made comparison with Sawmill Analytic (last column) that also stated "worm attack", may want to check that out as well.
> http://awstats.sourceforge
b) Nihuo Web Log Analyzer - No explicit mentioned of specific attack, just mention "Server Attack"
> http://www.loganalyzer.net
Rather few soln to extract "attack" straight from log unless using web firewall that do layer 7 inspection and trigger alarm on this attack
Have you tried OSSEC? You can install this host based intrusion detection system on your webserver. It contains signatures to verify IIS logs and detect common attacks by default:
http://www.ossec.net/
Business Accounts
Answer for Membership
by: jonathenPosted on 2009-10-07 at 06:41:57ID: 25515209
I use the free and powerful Log Parser 2.2 from Microsoft:
ownLoads/d etails.asp x? FamilyID =890cd06b- abf8-4c25- 91b2-f8d97 5cf8c07&di splaylang= en
indows/200 5/07/12/lo gparser.ht ml
http://www.microsoft.com/D
The following site explains how to use it:
http://oreilly.com/pub/a/w
It is a powerful log analyser although it can be a little tricky to setup correctly, but once you have it set up as you want it, it works a treat and provides more information than many of the commercial "fluffy" competitors out there.