IP Allocation and Management?
jmw asks: "I work for a large[r] regional ISP in the midwest. In the past, and through several acquisitions, we've accumulated a substantial amount of IP space - non contiguous blocks from a /24 up to /19 or more, totaling several thousand IPs. With that many IP's, it's a fairly daunting task to manage, allocate and just keep track of what we have. I'm sure some of you are in, or have been in, similar situations... CVS has been used, but not standardized on.-More people would like to see a pretty web page or the like. For those of you in this situation, what have you done?"
A few years ago I had to allocate single IP's to a now defunct Cable Modem ISP user base. I was handed this job when it was being handled by using Microsoft Excel, of all the stupid things. Upon learning this, I sent a memo to several of the in-house engineers and said "What can you guy's do to assist in this matter?". One of the unix guru's got together with one of our webmaster's, and they were in the middle of writing a nice little database with GUI system. Then upper management decided to combine the accounting system, the tech call center data, and the sales order system into one large package. A year later, I was still using Excel to allocate IP's. Later, after I had left the company, I found out this system wide package never got completed.
The moral here: keep it simple, clean, and efficent. And I'm pretty sure there are lots of folks who are current with all the latest database
technology that could handle this matter.