curious ... how did you implement this database ? Was it a commercial offering or is it a 'robust' home grown solution?
Today, its just a home-grown Oracle database with a web front-end for searches. My impression (though I'm not the DBA who built it / maintains it) is that there are tables for equipment with attributes like hostname, IP, subnet that it drives, physical location, # ports, etc., as well as location tables for each of our core wiring closets that contain patch panel informaiton, drop numbers, locations, etc. If you are looking for details, drop me a note offline and I'll forward it to our DBA. Having said all that, we are thinking about moving to a more commercial system so that we can tie the information into a ticket system, asset tracking system, etc. (i.e. Pinnacle, Remedy, etc). But, as with all things in todays market, "thinking" means "sitting around the lunch table and saying "that would be neat" and not "I have a budget". [Translation: sales droids, do NOT send inquiries because we have no money to spend on this nor am I authorized to approve any spending for this.] Eric :)