Static IP address database

I have hundreds of IP addresses set statically over multiple vlans on my internal network. Right now I have an excel sheet with them noted (not the best option). I am wondering what other options there are?
LVL 1
RavenNetworkingAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
MajorBigDealConnect With a Mentor Commented:
We started witha spreadsheet in a shared folder but that was unweildy and hard to find for some people.  So we created a very simple database app: ip address, mask, vlan, device type, device name (host name), location, rack and elevation.  I prefer to have as few fields as possible that are fully populated, rather than lots of to try to handle every situation and then have the data mostly missing.

We added a link to our intranet site that can only be viewed by people who also have access to this application. And this also helped us with backups since for some reason it is easier for us to get a database restored than a shared file (don't know why).
0
 
woolnoirCommented:
There are always other methods of dealing with it. You could make a quick and dirty database, stick with excel use a text file. Depending if the addresses are really static, or dynamically assigned reservations you can use the DHCP consoles to provide an overview.

We manage 100's too and we stick with excel, no reason to over complicate it to be honest.
0
 
RavenNetworkingAuthor Commented:
Ty woolnoir
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
woolnoirCommented:
I guess it depends on scale a bit.

say like 10-100 addresses = text file
100 - 1000 maybe multi tab excel
1000+ i'd start looking at a DB solution to record extra information with the static.
0
 
dacaseyCommented:
I agree with woolnoir.   Keep it simple.  If you do want to knock it up a notch here is an open source app for this purpose.

http://sourceforge.net/projects/iptrack/



0
 
RavenNetworkingAuthor Commented:
Didn't really provide a product for solution!! This gave me a start.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.