For my smaller to mid-sized clients, I use an Excel spreadsheet with 2 pages. Page 1 - I have lines and columns that represent the various Cisco switches or switch modules. A 6509, for example, might have a couple of 48-port 100bT cards, a 24-port Ge card, and a sup with a pair of fiber connections.
I color-code the ranges of ports based on the VLAN, use red text for POE ports, and blue text for fiber cables. Trunk ports are medium grey. I then embed comments on the cells of critical or special devices, such as the trunks, WiFi APs, or VoIP routers. Servers and endpoints don't get any comments. Each switch resides on a single page, and I hang a color printout of the switch near or on each switch for quick VLAN reference.
I use the same color-code for patch cords. The second page is an association between the end point and the switch port, with each intervening patch panel defined. The end jack terminates on a 110 block, which goes to a patch panel, which goes to the switch. Entering the endpoint device description on the End Jack line makes it pop up on the patch panel.
I identify the switch connection (using a SW-Mod-Port format) and the device name is populated on the corresponding switch/module/port line. Took a while to set up the formulas, but I can trace the connection through multiple IDF locations right to the switch and port. I copy the pages from a template to each customer's documentation workbook and add connection layers if necessary.
I'll share the pages from my home network if anyone is interested. This would be better in some form of SQL database, but I don't have enough skill there.
Play full-length songs from Jagged Little Thrill by Jagged Edge on your phone, computer and home audio system with Napster. Jagged edge jagged little thrill zip.
Excel Spreadsheet Patch Panel Template
Even the military in all its guidelines has yet to solidify a real documentation strategy that is actually understandable and possible to implement. In theory, I want a google map that has every one of my sites where I can zoom on each building and get a floor plan and list the com rooms and zoom into the comm rooms and see the switches and then zoom to the ports and see the devices connected to it. Stuff like that is possible but improbable to actually implement. Stuff like mapping endpoints to jack ports to patchpannel location to switchports is near impossible in a multiple location enviornment when you dont have physical control over who changes what.
Patch Panel Excel Template
Mlan wrote:I have asked this question before to various people, especially in regard to network documentation that would meet compliance initiatives, and I have yet to get a solid answer. Everybody seems to be doing their own thing, and I have yet to find any kind of industry or compliance-standard template for network documentation.
I've been having that problem too! A lot of jobs I've seen are asking for network documentation skills but I haven't been able to find anything on the subject other than abstract concepts of what it should be. There's isn't a wrong way to do it as long as the document conveys the information that you are trying to communicate or make a record of. We use several different applications and groups to provide a 'complete' picture of the enterprise system. The datacenter/facilities folks do floorspace drawings in CAD, rack elevation is done in Visio, network drawings I make are in Visio using Cisco stencils and basically use their format, IP address tracking/assignment is done in Excel (probably not my first choice), app-tier stuff is usually flow-chart style using Visio or whatever. Every place I've worked had different standards but I generally do most of my drawings the same way wherever I am with as much information in them I need to support the network effectively. ' Display posts from previous: Sort.
The trouble here is that documentation was up to date immediately after the network's initial installation, years ago. Numerous changes have since taken place. Because updating documentation is a time-consuming, error-prone process, it was not always performed. Incompatible records and spreadsheet confusion Part of the problem is that a complete set of documents includes files with multiple, incompatible formats. Office area blueprints showing the location of wiring closets, patch panels, cable trays and connection jacks are often AutoCAD files. Excel spreadsheets are often used to keep track of which PC connects to which jack, which connects to which patch panel connection, which, in turn, connects to which switch port.
There is no way to relate the two files to each other to provide an easy way to see the physical location of a connection point. Another problem with spreadsheets is the lack of internal consistency checking. When moving multiple PCs to different jacks, you might miss entering one of the changes in the spreadsheet. The result could be that your documentation would show two PCs connected to the same jack. Nor are end-to-end connections obvious in a spreadsheet. If your spreadsheet has a line item for each PC-to-jack connection, each jack-to-patch panel connection, and each patch panel-to-switch port connection, the relationship between a PC and switch port requires locating three different line items. Tracking cabling with dedicated software Cable management software packages are designed to address these problems.
They integrate information from blueprints with information about connections, maintain internal consistency (preventing errors such as two PCs connected to the same jack), and make both individual and end-to-end connections easy to see. Such packages include by Total Wire Software Company Inc. And by Brady. This software can import connection information from Excel spreadsheets and maintain internal consistency of the data.
Both integrate with Visio to read and update building or office area blueprints. They integrate the two types of data by providing a way for you to add physical connection point locations to the blueprint. Both products are compatible with the ANSI/TIA/EIA-606A standard.
This standard specifies formats and required information for identifying and describing cabling elements such as cable types, telecommunications spaces and endpoint locations. UltiCAM 2000 allows you to describe a network change and then request a printed work order. The work order describes to a technician the steps to be performed to carry out the change. When the work is done, you specify to UltiCAM that the change is now complete. At that point, the product updates its database to reflect the change.
Patch Panel Spreadsheet Template
NetDoc interfaces with Brady's software to create labels that then can be printed and attached to cables, wall jacks, and so on. Use of compatible cable management and labeling software ensures that identifiers in the documentation will exactly match the label attached to the object.
Finally, cable management software makes updating documentation a quick and easy process, increasing the likelihood that the task will actually be done. But don't wait for an emergency. The best time to install and begin using cable management software is when the network is first installed. If that time has passed, make the necessary effort now, before an emergency.
What is a Rack Diagram? A rack diagram is a two-dimensional elevation drawing showing the organization of specific equipment on a rack. It is drawn to scale and may show the front and the rear elevation of the rack layout. Typical Uses of Rack Diagrams Rack diagrams can be extremely valuable when selecting equipment or racks to buy, since they are drawn to scale and can help determine what size to choose. In addition, a rack diagram allows for efficient organization prior to moving the actual equipment.
How to Draw a Rack Diagram Installing equipment in a rack without planning in advance can create issues. You may not have adequate space for equipment, cables, and patch panels. Creating a rack diagram can help you plan and organize your equipment in an optimal fashion. SmartDraw has a number of rack drawings and elevations included that you can easily edit and customize.
Add components, servers, wiring, cables easily from the included library of components and cabinets. Here are some tips for creating a rack diagram:. Determine the purpose. Determine the equipment and racks to be organized. It may be useful to write a list of each item and its measurements. Also consider any special needs of a piece of equipment such as air flow.
The media files you download with rsymedia.com must be for time shifting, personal, private, non commercial use only and remove the files after listening. Rsymedia.com is not responsible for third party website content. Kabhi kabhi mere dil mein new version. It is illegal for you to distribute copyrighted files without permission.
Draw to scale. A relay rack typically uses universal hole spacing at 0.625, 0.625, and 0.5 inches. Each of these sets of holes is what is known as a rack-mount unit (RMU) of 1.75 inches. If you're drawing your rack diagram by hand you'll need to know the size of each component part and convert it into RMUs to allocate rack cabinet space. SmartDraw provides preformatted symbols for commonly used components such as servers, switches, patch panels and standard rack cabinets.
This makes building a rack diagram much faster and more accurate than trying to draw one by hand. Create the rack. Draw the racks on the page first. They should be drawn to scale exactly and should show every feature of the actual rack in real life. Arrange equipment.
Draw each piece of equipment to scale. Placing a label inside the area of each will be useful for keeping track of them while organizing.
Begin placing equipment on the racks where it will fit and continue rearranging until the desired organization is reached. It is good practice to place equipment that will be accessed frequently, such as patch panels, at eye level or slightly below. This will make servicing much faster and easier. Allow space for cabling.
Don't forget to allocate space for cable troughs and raceways. This is particularly important in a multi-rack environment.
The dead space at the top of the rack is often a good place for cable management. Use your rack diagram. Use the diagram you have made to arrange your equipment on your rack. Since the diagram is drawn to scale, everything should fit together as it does on the diagram. Rack Diagram Templates Click on any of these rack diagrams and drawings included in SmartDraw and edit them.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |