[44777] in North American Network Operators' Group
Re: Cabling databases and wireless networks
daemon@ATHENA.MIT.EDU (Eric Gauthier)
Wed Dec 12 15:46:47 2001
Date: Wed, 12 Dec 2001 15:45:28 -0500
From: Eric Gauthier <eric@roxanne.org>
To: Tony <missing@nts.umd.edu>
Cc: nanog@merit.edu
Message-ID: <20011212154528.A31845@roxanne.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20011212152338.M38007-100000@nts.umd.edu>; from missing@nts.umd.edu on Wed, Dec 12, 2001 at 03:25:56PM -0500
Errors-To: owner-nanog-outgoing@merit.edu
> 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 :)