Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Static IP address database

Posted on 2010-11-16
6
605 Views
Last Modified: 2012-05-10
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?
0
Comment
Question by:RavenNetworking
6 Comments
 
LVL 20

Expert Comment

by:woolnoir
ID: 34152823
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
 
LVL 1

Author Comment

by:RavenNetworking
ID: 34152851
Ty woolnoir
0
 
LVL 20

Expert Comment

by:woolnoir
ID: 34152856
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
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 5

Expert Comment

by:dacasey
ID: 34152950
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
 
LVL 11

Accepted Solution

by:
MajorBigDeal earned 500 total points
ID: 34159181
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
 
LVL 1

Author Closing Comment

by:RavenNetworking
ID: 34188276
Didn't really provide a product for solution!! This gave me a start.
0

Featured Post

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Connect two buildings 6 47
Internet Service Provider 3 55
Samba Question 11 75
what is mstp 6 35
If you're not part of the solution, you're part of the problem.   Tips on how to secure IoT devices, even the dumbest ones, so they can't be used as part of a DDoS botnet.  Use PRTG Network Monitor as one of the building blocks, to detect unusual…
PRTG Network Monitor lets you monitor your bandwidth usage, so you know who is using up your bandwidth, and what they're using it for.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

856 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