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!)