Search and list ip address


#1

Hi,

First of all thanks for such a fine script! I find piwik to be much better than Google analytic.

Anyway, I just starting to use Piwik and someone keep spamming my website. Can someone guide me how to use the API so I can search for the spammer IP address? I have the spammer ip address and I need this search because I have several sites on piwik and I want to know if the spammer have already visited my other sites before.

I tried phpmyadmin to search for the IP address but it is not working as all IP address has been converted into some kind of id keys.

thanks!!!


(Matthieu Aubry) #2

You can use the Visitors > Visitor Log, or look at Live API: Real Time Analytics - Analytics Platform - Matomo


#3

Thanks the information. I know the live visitor log, but the problem is I have hundreds of visitors a day, and with the different visitor log coming in everyday, flipping through the visitor log page by page to find the ip address is really troublesome. Is there anyway that I can search the specific IP address and the system will list it down?

thanks !


(Matthieu Aubry) #4

you can add &segment=visitIp==93.220.86.117 in the hash tag in the URL to show only one IP


#5

[quote=matt]
you can add &segment=visitIp==93.220.86.117 in the hash tag in the URL to show only one IP[/quote]

Thanks Matt! This is awesome. Do you know how to acheive the same with a custom variable? Something like…


&segment=name==value

I’ve tried every combination I can think of. Can’t get it to work. Thanks again.


(Matthieu Aubry) #6

see : Segmentation - Compare segments of visitors - Analytics Platform - Matomo


#7

To Know the details about spammer IP address, visit this site Ip-details.com. This site might provide you to search for list of spammer’s IP address. This gives the Information of their Service provider, IP Location and Network etc…


#8

Ok well after a lot of research I found a work-around to search and list all activity from an IP number within a one-year time period.

Hopefully filtering results by IP will be a built in feature in the future (hint hint) (tu) but until then, this post describes how one can filter results for a single IP one year at a time:

Search for IP Number within Piwik’s log

hope this helps others


(Matthieu Aubry) #9

Actually it is already possible to filter all statistics by IP Address in Piwik :slight_smile: This works the same way you did it, but you may create the segment using the segment editor: Segmentation - Compare segments of visitors - Analytics Platform - Matomo