ProgrammingWindows

Using Log Parser Studio to Find Guilty IP Addresses

Posted Steve Fenton

If you are getting hammered by a robot, you’ll probably want to find out the IP Address of the robot to see if it is a friendly one, or just someone playing with Kali Linux in a far off land.

The following Log Parser Studio query will get you a list of your top offenders:

SELECT
    c-ip,
    count(c-ip) as requestcount
FROM '[LOGFILEPATH]'
WHERE date = '2016-03-29' 
GROUP BY c-ip order by count(c-ip) DESC

Just change the date as you need.