+ Post New Thread
Results 1 to 2 of 2
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 ...
  1. #1

    Join Date
    Jun 2009
    Location
    East Renfrewshire
    Posts
    146
    Thank Post
    20
    Thanked 22 Times in 16 Posts
    Rep Power
    14

    Cataloging your network cabinets

    Hello, all..

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

    Cheers,
    Gerard

  2. #2

    Join Date
    Feb 2006
    Location
    South Cumbria
    Posts
    199
    Thank Post
    26
    Thanked 29 Times in 24 Posts
    Rep Power
    22
    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)

SHARE:
+ Post New Thread

Similar Threads

  1. 10% off price of Used Cabinets
    By TNE in forum Our Advertisers
    Replies: 0
    Last Post: 8th June 2009, 11:45 AM
  2. How do you wire your cabinets?
    By maniac in forum How do you do....it?
    Replies: 28
    Last Post: 6th December 2007, 03:09 PM
  3. terminating CAT5E network cables in network cabinets
    By broc in forum Network and Classroom Management
    Replies: 7
    Last Post: 10th July 2007, 11:54 AM
  4. Server Cabinets
    By mortstar in forum Hardware
    Replies: 33
    Last Post: 20th April 2007, 01:54 PM
  5. SERVER CABINETS
    By alan-d in forum Hardware
    Replies: 30
    Last Post: 15th September 2006, 08:47 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •