Hi everyone,
Got a project that is pretty daunting but I think it can be pretty cool. I am taking all my company's IP ranges and creating a database that maps out data centers and other important topics. Here is my question:
My current program that I have runs with IP ranges and I have separated the ranges into 4 different levels. If the IP is 10.20.30.40
Level 1 - 10
Level 2 - 10.20
Level 3 - 10.20.30
Level 4 - 10.20.30.40
Rules for this is that everything in level 2-4 goes from 0-255 and I will seldom use level 1 by itself.
The range in this situation may be 10.20.30.40 - 10.20.30.255 for Boston / 10.20.50.00 - 10.20.80.255 for Austin
Here is my issue. I have close to half a million possible IP's and each range is associated with a data center. I am happy to make a .yxdb database but I would love to utilize a tool that I know exists, but the multi row formula seems like the wrong choice. I am leaning towards a find and replace tool but It would be great to find out what you all have done.
I have thought about setting up a listing of lookup where it goes from most granular to least granular
Level 3 Strings to look up ranges in the level 3 range for Austin as the range goes from 10.20.50 - 10.20.80 so anything within that range will be in Austin
Level 4 String to look up exact IP's in the level 4 range for Boston as the range goes from the 4th level .40-.255 as anything within that range will be in Boston
I have roughly 300 ranges that exist and I can look though everything to determine ranges but it would be really nice to get some outside perspective. Any thoughts?
