Solved

getting location from table of ip addresses

Posted on 2014-09-17
2
245 Views
Last Modified: 2014-09-17
Hi,
i have been using the jdownloads extension on joomla site for a while now and it has been keeping logs of all downloaded files including a list of ip's

i would like to find a way to geolocate these ip's (ie - to find out what country they came from)

since i have 32000 records, its not something i can do manually, any suggestion of a tool / website / ??? that will do this for would be greatly appreciated.

(this is a one-time need, i will not have to do this again, if this changes the approaches suggested)

Cheers,
weaverk
0
Comment
Question by:weaverk
2 Comments
 
LVL 2

Accepted Solution

by:
Akilandeshwari N earned 500 total points
Comment Utility
You can download the database from http://db-ip.com/db/download/country and compare it with your IP list. Before comparing, have your IP list in an other sheet in the file you downloaded. Writing a simple formula to compare both the sheets would do well.
0
 
LVL 1

Author Closing Comment

by:weaverk
Comment Utility
thanks
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
A short article about problems I had with the new location API and permissions in Marshmallow
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now