In this post, I will be doing a brief commentary on creating and maintaining a physical port mapping spreadsheet. A port mapping spreadsheet is useful for keeping track of used/available ports on your network equipment, thoroughly documenting to which remote device each port connects, and generating configuration scripts to update port descriptions on the equipment.
You can download this article’s template file using the link to the right.
This is a huge space-saver. For instance, console channel outputs 1-8 connect to the patch bay using a single cable, instead of 8 separate TRS cables. Patchbay Layout. Patchbays are organized based on the needs of the studio, so none of them are laid out the same way.
- Excel label template Excel Label Template Awesome Word Calendar Templates 35 Unique Free 2019 Club Sign Up Sheet Template Elegant Free Price List Template Awesome Free Download 63 Elegant Pics How to Print Labels From An Excel Spreadsheet New file label template free – waldulmfo Model Binder Spine Label Template Labels Word Book Unique Beautiful Avery Model, Patch Panel Label Template Excel.
- Tracking patches and updates to hardware, operating systems, and third-party software programs is one of the most challenging aspects of managing a network. Here is a strategy for getting on track.
What to Document
The first question to ask when deciding to create a port mapping is which details should you record. The answer completely depends on your specific environment and what you plan to do with the documentation. Different requirements demand different data to be collected. I recommend you identify what you would like to do with this documentation before collecting and creating it. All that being said, the template linked to on this post contains a baseline of the most common data points which can provide a solid starting point.
Type
This field details the layer-1 and layer-2 media and protocols used on the wire. Layer-1 can be things like RJ45, OM2 (SC), OS1 (LC), etc. Layer-2 can be things like Ethernet, PPP, or God forbid, Frame Relay.
Source Device Hostname & Port
These fields record the hostname and port information of the source device. Whenever possible, I will use the port name as it is seen in the configuration terminal of the device.
***NOTE***
In case you are wondering the difference between the source device and the destination device, there really is no difference other than the fact that the focus of the document is always on the source device. In other words, the complete listing of ports for a device can be found in the section of the document where it is focused on as the source.
Patch Panel Fabric & Port
When there is infrastructure cabling used in-between the source and destination device: it is handy to note down which patch panel and port is used for the connection. The “Fabric” column can be replaced with “Panel Name” or anything else which specifies the infrastructure cabling extension set.
Destination Hostname & Port
This field defines the remote (non-focused) device and port where the connection terminates. When the port on the source device is empty and unused, these fields will be blank.
Destination Device Notes
These fields can be used for notations about the destination device including information about its role, purpose, and if the documented link is in an aggregated group (port-channel).
Scripting Columns
The scripting columns are used to generate configuration scripts using the information contained in the other columns. The scripting columns in the template are set up to generate port descriptions for Cisco based switches and will automatically detect when the different “Notes” fields are populated.
Documentation Tips
Make sure to visit the homepage for this series Network Documentation Series: Preamble and review the generic documentation tips listed there which apply to all network-related documents.
Free Excel Patch Panel Template Simple 46610 from 6550 + Download Template Example Free
panel schedule template – entrerocks Electrical Panel Schedule Excel Template 30 Electrical Panel cutler hammer panel schedule template – zerosoftfo Project Schedule Template Powerpoint – Electrical Panel Schedule Electrical Panel Schedule Template Excel Glendale munity Electrical Outlet Template New Electric Panel Schedule Template Electric Panel Schedule Template Inspirational Square D Panel Elegant Panel Schedule Template Excel Employee Spreadsheet, Electrical Panel Schedule Template Lera Mera Business Document Panel Schedule Template Sample Electrical Panel Schedule Template Electrical Panel Schedule Template as Well as How to Calculate Flow Chart Template Excel Work Readleaf Panel Schedule Luxury Map Electrical Panel Schedule Template Word – photofactsfo Electrical Panel Schedule Excel Lovely Electrical Panel Schedule Ge Panel Schedule Template Amp Breaker Distribution Panels Circuit â Process Flow Chart Powerpoint Modest Panel Schedule Template Square D Electrical Panel Schedule Template A Awesome Block Tem.
Download Panel Schedule Template Collections Best Resume Template Google 2019 from panel schedule template simple with resolution : 638 x 903 pixel
Download 8 Lovely Stock Panel Schedule Template Excel paranoidcitroid examples from panel schedule template examples with resolution : 640 x 514 pixel
Download Ge Panel Schedule Template Amp Breaker Distribution Panels Circuit format from panel schedule template professional with resolution : 554 x 543 pixel
Free Electrical Panel Schedule Excel Template 30 Electrical Panel download from panel schedule template new with resolution : 1152 x 587 pixel
Free download Excel Scheduling Template – Rotating Shift Schedule Template Weekly examples from panel schedule template new with resolution : 300 x 210 pixel
Download Elegant Panel Schedule Template Excel Employee Spreadsheet examples from panel schedule template format with resolution : 765 x 990 pixel
Free Panel Schedule Template Lera Mera Business Document Template example from panel schedule template format with resolution : 798 x 421 pixel
Download Electrical Panel Labels Template Example Raised Panel Door Templates download from panel schedule template picture with resolution : 450 x 300 pixel
Download cutler hammer panel schedule template – zerosoftfo new from panel schedule template template with resolution : 990 x 765 pixel
Free Electrical Panel Schedule Template Elegant Electric Unique Software 2019 from panel schedule template template with resolution : 638 x 826 pixel
Free Electrical Panel Directory Template new from panel schedule template photo with resolution : 614 x 800 pixel
Free download panel schedule template – entrerocks new from panel schedule template free templates with resolution : 724 x 1024 pixel
Free Electrical Panel Schedule Template as Well as How to Calculate examples from panel schedule template new template with resolution : 1449 x 2048 pixel
Free download â Process Flow Chart Powerpoint Modest Panel Schedule Template download from panel schedule template professional template with resolution : 1754 x 1240 pixel
Free download Project Schedule Template Powerpoint – Electrical Panel Schedule new from panel schedule template picture with resolution : 592 x 359 pixel
Free Electrical Panel Schedule Template Lera Mera Business Document sample from panel schedule template new template with resolution : 1036 x 810 pixel
Download Electrical Panel Schedule Template Lera Mera Business Document format from panel schedule template download with resolution : 960 x 720 pixel
Free download Panel Schedule Template Sample Electrical Panel Schedule Template new from panel schedule template new with resolution : 1127 x 414 pixel
Free collection excel patch panel template examples from panel schedule template picture with resolution : 800 x 624 pixel
Free collection Circuit Breaker Panel Label Template Fresh Electrical Panel Schedule sample from panel schedule template professional with resolution : 460 x 434 pixel
Download Electrical Panel Label Template Excel – Electrical Panel Labels new from panel schedule template free template with resolution : 600 x 600 pixel
Free Panel Schedule Template Design Square D Pdf Free Electrical Download free download from panel schedule template free templates with resolution : 1024 x 792 pixel
Free download Electrical Panel Schedule Template as Well as How to Calculate new from panel schedule template template with resolution : 1809 x 1823 pixel
Free collection Awesome Concept About Electrical Panel Schedule Template Artwork picture from panel schedule template sample with resolution : 200 x 140 pixel
Download 017 Panel Schedule Template Excel Electrical Circuit Breaker Label examples from panel schedule template 2019 with resolution : 2550 x 3225 pixel
Download 025 Panel Schedule Template Download Excel Luxury Flow Chart Map new from panel schedule template template with resolution : 1400 x 1593 pixel
Free Panel Schedule Template Sample Electrical Panel Schedule Template new from panel schedule template simple with resolution : 706 x 312 pixel
Free download Panel Schedule Template New 30 Awesome Electrical Panel Schedule examples from panel schedule template free template with resolution : 960 x 720 pixel
Free collection Free Circuit Panel Schedule Template Download Schedules In picture from panel schedule template simple with resolution : 638 x 826 pixel
Free Electrical Panel Schedule Template as Well as How to Calculate sample from panel schedule template examples with resolution : 1496 x 1600 pixel
Free download Electrical Panel Schedule Template Word – photofactsfo free download from panel schedule template template with resolution : 639 x 768 pixel
Download 025 Panel Schedule Template Download Excel Luxury Flow Chart Map 2019 from panel schedule template new with resolution : 1200 x 675 pixel
Free Panel Schedule Template New 30 Awesome Electrical Panel Schedule format from panel schedule template professional template with resolution : 728 x 546 pixel
Free collection Electrical Panel Schedule Excel Lovely Electrical Panel Schedule picture from panel schedule template format with resolution : 1929 x 1164 pixel
Download Electrical Outlet Template New Electric Panel Schedule Template download from panel schedule template simple with resolution : 290 x 175 pixel
Free collection circuit schedule template – yummytummyfo professional from panel schedule template sample with resolution : 1107 x 255 pixel
Download ge panel schedule template – watsontowncmachurchfo 2019 from panel schedule template free templates with resolution : 736 x 952 pixel
Free collection panel schedule template excel – arborridgefo photo from panel schedule template picture with resolution : 660 x 511 pixel
Free download Panel Schedule Templates Sample Blank Electrical Legend Template free from panel schedule template example with resolution : 1200 x 360 pixel
Free collection Flow Chart Template Excel Work Readleaf Panel Schedule Luxury Map model from panel schedule template photo with resolution : 989 x 1024 pixel
Free collection Electrical Panel Schedule Excel Lovely Electrical Panel Schedule 2019 from panel schedule template new with resolution : 1218 x 267 pixel
Free Panel Schedule Template New 30 Awesome Electrical Panel Schedule download from panel schedule template sample with resolution : 1024 x 627 pixel
Free download Panel Schedule Templates Sample Blank Electrical Legend Template model from panel schedule template simple with resolution : 960 x 720 pixel
Free download Electrical Panel Schedule Template Lera Mera Business Document example from panel schedule template templates with resolution : 670 x 523 pixel
Download Electrical Panel Schedule Template Excel Glendale munity examples from panel schedule template free template with resolution : 1860 x 2483 pixel
Free download Panel Schedule Template Lera Mera Business Document Template download from panel schedule template professional with resolution : 729 x 280 pixel
Free download Electric Panel Schedule Template Luxury Panel Schedule Circuit 2019 from panel schedule template examples with resolution : 960 x 720 pixel
Free Free Electrical Panel Schedule Template Excel New Electrical Panel model from panel schedule template 2019 with resolution : 939 x 540 pixel
Download Electrical Panel Schedule Template Excel Medium Free – arborridgefo new from panel schedule template template with resolution : 640 x 480 pixel
Free collection Square D Electrical Panel Schedule Template A Awesome Block Tem 2019 from panel schedule template format with resolution : 600 x 1060 pixel
Free download Electric Panel Schedule Template Inspirational Square D Panel free from panel schedule template download with resolution : 600 x 730 pixel
Download Circuit Breaker Panel Labels Template Awesome Electrical Panel professional from panel schedule template download with resolution : 487 x 685 pixel
Free Panel Schedule Template Lera Mera Business Document Template format from panel schedule template free with resolution : 1297 x 569 pixel