Wireless Networks Thread, Cataloging your network cabinets in Technical; Hello, all..
I've had a search through the forum and haven't noticed anyone talking about this specifically, but I could ...
10th May 2010, 12:09 PM #1
Cataloging your network cabinets
I've had a search through the forum and haven't noticed anyone talking about this specifically, but I could be wrong (it's one of THOSE days already!!)..
I'm hoping (desperately) to try to catalogue the network cabinets and hardware in our school.
I currently have the following information:
1. Excel sheet of all network points across the school, listing each point and which room it's in
2. Excel sheet of all PCs/printers (inc model/serial) by network name, listing which patch point they're connected to
3. Excel sheet of all cabinets, listing Cisco switches and which patch point plugs into which switch port
4. Excel sheet of Cisco switches listing which port is configured for which VLAN
Is there some clever way I can get all of this information into one easy to lookup form?
I'm thinking of things like:
Look up PC123 and see that it's an HP DC7600 serial number 12345 which connected to wall point A/1/12 which is connected to Cisco switch 10.130.1.12 port 11 which is on VLAN 10.
Kind of idea
I don't much care if it's in Excel or not - that was just the original format I typed the data into.
Is there some kind of application out there which might do this for me? (before I start dabbling in code myself - never pretty!)
10th May 2010, 01:30 PM #2
It should be fairly straightforward in any relational database - I'm just doing something similar in Access where I use a subset of my config database with a room form which shows all the resources in a given room (computers, printer, projector etc). It shouldn't be difficult to convert your excel sheets into database tables and then create the queries and forms you need. If you're not familiar with Access you might find this a good starting point http://office.microsoft.com/en-gb/te...184591033.aspx (of course you don't have to use Access it depends what database software you have available or how good you are with SQL)
By TNE in forum Our Advertisers
Last Post: 8th June 2009, 12:45 PM
By maniac in forum How do you do....it?
Last Post: 6th December 2007, 04:09 PM
By broc in forum Network and Classroom Management
Last Post: 10th July 2007, 12:54 PM
By mortstar in forum Hardware
Last Post: 20th April 2007, 02:54 PM
By alan-d in forum Hardware
Last Post: 15th September 2006, 09:47 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread