Solved

Static IP address database

Posted on 2010-11-16
6
574 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
Free camera licenses with purchase of My Cloud NAS

Milestone Arcus software is compatible with thousands of industry-leading cameras for added flexibility. Upon installation on your My Cloud NAS, you will receive two (2) camera licenses already enabled in the software. And for a limited time, get additional camera licenses FREE.

 
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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Some time ago I was asked to set up a web portal PC to put at our entrance. When customers arrive, they could see a webpage 'promoting' our company. So I tried to set up a windows 7 PC as a kiosk PC.......... I will spare you all the annoyances I…
Configuring network clients can be a chore, especially if there are a large number of them or a lot of itinerant users.  DHCP dynamically manages this process, much to the relief of users and administrators alike!
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

760 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

20 Experts available now in Live!

Get 1:1 Help Now