port mapping excel template

• Day Two Cloud
• Heavy Networking
• Heavy Strategy
• Heavy Wireless
• Kubernetes Unpacked
• Network Automation Nerds
• Network Break
• Packet Protector
• The Fat Pipe
• Newsletters
• Slack community
• About Packet Pushers
• Meet the hosts
• Become a sponsor
• Pitch your news
• Book us to speak

Reach our specialized technical audience through a channel they trust. Become a Packet Pushers sponsor.  

Blog > How-To  | August 2, 2015 

Tags: documentation | management, network documentation series: port mapping, john w kerns.

You can download this article’s template file using the link to the right.

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.

About John W Kerns: John Kerns is a network and automation engineer for a VAR based in Southern California and has been in the industry for over 12 years. He maintains a few open-source projects on GitHub and writes for Packet Pushers.

• Activity Diagram (UML)
• Amazon Web Services
• Android Mockups
• Block Diagram
• Business Process Management
• Chemical Chart
• Cisco Network Diagram
• Class Diagram (UML)
• Collaboration Diagram (UML)
• Compare & Contrast Diagram
• Component Diagram (UML)
• Concept Diagram
• Cycle Diagram
• Data Flow Diagram
• Data Flow Diagrams (YC)
• Database Diagram
• Deployment Diagram (UML)
• Entity Relationship Diagram
• Family Tree
• Fishbone / Ishikawa Diagram
• Gantt Chart
• Infographics
• iOS Mockups
• Network Diagram
• Object Diagram (UML)
• Object Process Model
• Organizational Chart
• Sequence Diagram (UML)
• Spider Diagram
• State Chart Diagram (UML)
• Story Board
• SWOT Diagram
• TQM - Total Quality Management
• Use Case Diagram (UML)
• Value Stream Mapping
• Venn Diagram
• Web Mockups
• Work Breakdown Structure

Switch port mapping diagram [classic]

You can easily edit this template using Creately. You can export it in multiple formats like JPEG, PNG and SVG and easily add it to Word documents, Powerpoint (PPT) presentations, Excel or any other documents. You can export it as a PDF for high-quality printouts.

• Flowchart Templates
• Org Chart Templates
• Concept Map Templates
• Mind Mapping Templates
• WBS Templates
• Family Tree Templates
• Network Diagram Templates
• SWOT Analysis Templates
• Genogram Templates
• Activity Diagram
• Class Diagram
• Collaboration Diagram
• Component Diagram
• Data Flow Diagrams(YC)
• Deployment Diagram
• Object Diagram
• Sequence Diagram
• State Chart Diagram
• Use Case Diagram

Related Templates

Stack Exchange Network

Stack Exchange network consists of 183 Q&A communities including Stack Overflow , the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Tool to map network cabling between patch panels and switches

I'm planning a switch from the spaghetti wiring of my current networking rack to an organized cut-to-length system. I'd really like to plan ahead as much as possible. The best way I can imagine doing this is to map all the connections virtually first. In the image below you can see my attempt to do just that with Visio 2010. Unfortunately the connector tool in Visio doesn't seem capable of handling this because it always finds the shortest path between two points.

Are there free or low-cost tools available to do this?

• Anytime I've ever seen maps, they have been spreadsheets with port numbers. Each row is a cable path and each column is a switch/patch panel/wall plate/etc. Just make sure that you use something like a ptouch machine to label everything. Each cable should also be flagged with the port it goes into on both ends with a to/from model (only covers the points it touches, not the whole path). –  MaQleod Oct 12, 2011 at 16:54
• Do you have a suggestion on handling length? I suspect that with things mapped out in Excel the tech would be measuring and cutting each cable as he plugs them in rather than doing it ahead of time. I have a limited amount of time to redo my networking rack and I am hoping to visualize/plan the cable lengths ahead of time too. Thoughts? –  Chris76786777 Oct 12, 2011 at 17:04
• You typically want to cut to length as you are making the cables. You can certainly have a number of pre-cut cables that are all the about same length for a switch to patch-panel project and then cut down to exact length (plus a small service loop) when the cables are actually being terminated. –  MaQleod Oct 12, 2011 at 17:15

You must log in to answer this question.

Browse other questions tagged networking ethernet diagrams cabling ..

• The Overflow Blog
• How do mixture-of-experts layers affect transformer models?
• What a year building AI has taught Stack Overflow
• Featured on Meta
• New Focus Styles & Updated Styling for Button Groups
• Upcoming initiatives on Stack Overflow and across the Stack Exchange network
• Google Cloud will be Sponsoring Super User SE

Hot Network Questions

• Is it possible to send a sms text to someone’s iPhone and make it appear that they replied to a number that they did not reply to?
• Need Help in identifying- analog hall sensor with the numbers 958409
• What can I tell a student I am mentoring who claims: "I want to do pure mathematics because it is superior to any other subject in the world"?
• How do I express a negative premise in Coq?
• What international law did Ecuador break by storming the Mexican embassy?
• Difficult sentence from Leibniz's Historia Inventionis Phosphori?
• Is it possible to have a stable black hole that does not evaporate?
• Is there a way to take away an action in D&D 5e?
• I need a word for the atmosphere between two people
• Does Whatsapp use data from inactive SIM?
• Cumulative constraint with a window
• What is better source of random bytes: Yubikey or /dev/random (or both)?
• Why can't the Schlumpf Mountain Drive be used along with the 14-speed Rohloff?
• Why did the US and Israel vote against making food a human right?
• How to partially terraform Venus?
• How can we reconcile the teaching of Jesus to that of Paul concerning judgment?
• Do batteries have capacitance?
• I think I downloaded spyware! I used a curl command in terminal given by a fake support user to download a .sh file
• Combining duplicate elements in a list
• Sight reader or busker?
• Manga where the main character gets experimented on by succubus
• Can definitions in the Oxford Dictionary of the English Language be considered definitive in informal philosophical presentations?
• Simultaneous Diophantine equation
• Can Silent Image change size?

JOIN SOMEKA BUSINESS: Subscribe to Business Membership for exclusive benefits! Dismiss

Network Diagram Excel Template

Network map maker in Excel. Create interactive network diagrams with dynamic shapes and icons. No installation needed. Ready to use.

Unlimited version with password and modification rights of Single User License Allows 1 User & 2 Devices Learn More >

Unlimited version with password and modification rights of Multi User License Allows Multiple Users & Devices Learn More >

Additional Services

Technical assistance and guidance for the product purchased Valid for 1 product & 1 month Learn More >

Custom Services - Basic Plan Assistance for the basic spreadsheet modifications such as adding new columns/rows, filters, changing currencies, removing logo, adding new tabs etc. Learn More >

30-Days Return

One-Time Payment

Instant Download

Redeem 3 Templates

Download 3 premium templates of your choice for free each month.

Continuous Technical Support

We’ll be your one-stop assistant for all your Excel & Google Sheets questions and needs.

Multi-User Environment

You’ll be entitled to multi-user licensing for your templates.

Cancel Anytime | Growing Catalogue | Continuous Updates

Learn more about Someka Business

TEMPLATE DESCRIPTION

This Network Diagram Excel Template will help you to visually demonstrate the network of a system. Basically, the network diagrams, or network topology diagram, are among the best tools to understand the system elements and the relationship between them. Moreover, the Shapes or icons increase the ease of displaying the connections.

It is a powerful yet easy-to-use tool and our Network Diagram Excel Template already has a ready-made Shapes/Icons catalog. To give you further flexibility, you have the option to grow the catalog with new icons and shapes.

Actually, the best in this tool is that you can adapt it to other purposes and use according to your needs. You can:

• create loop dependencies
• add multiple connections
• use shapes as well as pictures
• use smart fit to grid function that will remember all the positions of the elements
• use interactive buttons to add more elements
• customize settings to your preference
• all the shapes can be standardized, simplified

Network Diagram Template Features

This Excel template allows you to create a Network Diagram in two ways :

• Input all your data into the table and then create a network diagram based on the data input.
• Visually create a network diagram using the interactive buttons and shapes without filling the data table.

Both of those methods are connected, so if you make changes in the table, they are reflected in the graph. On the other hand, the changes you directly execute in the chart will show up in the table too.

With additional settings (buttons), the Excel template allows you to customize your network diagram according to your needs.

In the advanced settings part of the template, you can rearrange the diagram settings. Such as: distance measures for the shapes and icons, the width and height of each shape/box and label/main font sizes .

Furthermore, here you can customize your diagram further by setting the colors for connector , shape and font . By using the dropdown options, you can decide on the connector and shape types . As well as the chart style: whether icons or shapes !

The connector selection allows you to set the element style to connect the boxes. In addition, you can select the shape type (circle, rectangle, or rounded) and colors (one color set or many colors).

If you wish to have one color, you can also choose the default color from the given options on the dropdown menu. In addition, you may customize the color to your liking after generating the network diagram.

Network Diagram Template Buttons

Shapes list.

The network diagram maker has an additional sheet dedicated to the components catalogue. Here you may find already existing shapes and icons list. In addition, you can add new ones and rename them!

Export Button: Choose the format using scroll buttons on the right and export your network diagram. You may export to JPG, PDF and PNG.

Draw: If you input, add, or change any data in the data table, use this button to generate or re-generate your network diagram.

Clear: Clear button deletes the diagram, in the second step it asks if you also want to clear the table. So you can start to build your diagram from the beginning.

There are two options in terms of clearing, you will clear the diagram with the first click. And then if you click yes the input table will be cleared too. Please note that this action can not be undone.

Fix: Makes sure all connections are in place after changes. If you delete or disconnect some of the connectors or move the shapes in another spot. It will bring connectors back to the optimal position.

Fit to Grid: Being a very useful function, this button can be used for the template to memorize your placement settings. Even after redraw , the positions will be fit to your choice.

Reset: Reverses the previous setting of “fit to grid”.

Add Parent: Parents are the main elements, the roots of the diagram. Click to add one.

Add Node: To add a new node you need to first select its parent and then click the button.

Network Diagram Template Features Summary:

• Add elements and connections to your network diagram
• Ability to use both shapes and icons
• Interactive design, flexible and customizable shapes
• Informational notes included
• No installation needed, ready-to-use
• Works both on Mac and Windows
• Compatible with Excel 2010 and later versions
• Includes VBA code and macros

Network Diagram Template is a ready-to-use Excel Template and provided as-is. If you need customization on your reports or need more complex templates, please refer to our custom services.

PRODUCT VIDEO

Watch the video below to see the template in action! Presentation also includes usage notes, explanations and tips & tricks about the template.

FREQUENTLY ASKED QUESTIONS

User reviews & comments, 14 reviews for network diagram excel template.

M. Oldani – May 21, 2023

The icons are so cute and it makes me happy to work with them. Thank you!

Anshula – February 11, 2023

Does this template work with Excel 2007?

Someka – February 11, 2023

Hey! We’re sorry, but this network diagram won’t work with Excel versions that are older than 2010. Don’t worry though – send us an email and we’ll see what we can do to help you out. [email protected]

Jodi Singh – December 13, 2022

How can I delete the yellow note of this template? It’s very distracting and I don’t need it for my presentation.

Someka – December 13, 2022

We apologize for the inconvenience. Once you unlock the sheets using the password we gave you, it’s simple to cut them from the template by right-clicking. Make sure you know how to use the network diagram template before you do so. We hope this helps you out!

Dr. Forster – October 29, 2022

It saved me so much time and effort. Thank you for creating it!

Zeeshan – September 4, 2022

The font size is too small. It’s hard to read the labels on the shapes.

Someka – September 4, 2022

Hi there, no worries at all. You can change the font sizes from the settings sheet . If you need more help don’t hesitate to get in touch with us at: [email protected]

Mourad AB – June 10, 2022

How i am suppose to activaete the macro in to this template??

Someka – June 10, 2022

Hey there, you can easily activate VBA/Macros in Excel by using this link. If you need more help, please contact us at: [email protected]

Briana – May 23, 2022

like this excel thx

Nathaniel – May 10, 2022

nice excel but tried it on Mac and its full of glitches and bugs couldn’t use it

Someka – May 10, 2022

Hello Nathaniel, We are sorry you had problems using the tool. Could you please get in contact with our support team at [email protected] and give more detail about your problem? Also, bear in mind that our templates have been built specifically for use on Windows. If you have a suitable Excel version, most of our templates are compatible with both Windows and Mac. If you use other software (Like Google Sheets) they may not work properly.

Erin – April 5, 2022

very flexible! thanks team

Ülkü Amjad – March 3, 2022

Hi. Template is very helpful but I need changing font color and size, can you assist?

Someka – March 3, 2022

Hello Ülkü,

Thank you for your question. The font color and size can be changed easily from the settings section of the diagram tab. Please see the image below:

Heraclio – January 4, 2022

Judith – December 5, 2021

It saved me time generating my diagram. Much easier and faster than doing it manually

Dwayne Barrett – November 10, 2021

The template is easy to use and verty complete. I’m no expert but used it without problem

Burhan – October 11, 2021

The template helped me a lot creating my diagrams but can I change/add other icons or modify the existing ones in the catalog? Thanks!

Someka – October 11, 2021

Hello Burhan!

Sure, the template is customizable and you can change the icons and add new ones. You just have to unlock it with the password you received, then you will be able to add and modify anything as in any regular sheet.

You must be logged in to post a review.

Only verified users who have downloaded and used the template may leave a review.

RELATED TEMPLATES

PERT Chart Excel Template

PERT diagram generator in Excel. Create interactive PERT diagrams in seconds. Easy way to visualize complex tasks. Fully printable and ready to use.

Action Plan Excel Template

Action Plan Template to organize and track targets in Excel. Input your goals and actions, and measure status and progress. Visual charts are included.

Daily-Weekly-Monthly Task List Excel Template

Excel Task List Template on a daily, weekly, monthly basis. Save your headspace and keep track of your to-dos easily. Works in Mac & Windows.

After Action Report Template in Excel

Evaluate your performance with the After Action Report Excel Template. Simple AAR spreadsheet with predefined questions. Print-ready. Easy-to-use and clear layout.

Kanban Board Excel Template

Automated Kanban Board in Excel. Manage your workflows and tasks in cards view. Easy-to-use printable spreadsheet. Works in Mac & Windows.

Excel Roadmap Maker

Simple spreadsheet to create roadmap diagrams. Visualize your processes all product plans. Printable roadmap with optional colors. All in Excel.

Network Diagram Template For Excel

What are your network diagram needs.

Network diagrams visualize the connections between devices and hardware in given a computer network. Symbols, shapes, and icons are used to depict devices such as laptops, routers, desktops, and servers. Whether you are mapping out a personal home network or multiple networks as part of a larger organization, a well-made network diagram simplifies and clarifies complex systems. This step-by-step guide will explain how to create a network diagram template in Lucidchart and integrate it into Excel. 

3 minute read

Want to make a network diagram of your own? Try Lucidchart. It's quick, easy, and completely free.

How to make a network diagram in Excel

It easy to organize large amounts of data into neat rows and columns using Excel, but it’s diagramming features are limited. Excel lacks the specific shapes necessary to create a network diagram without spending hours creating custom shapes from scratch or paying for additional extensions. That’s why we have outlined the steps to create a network diagram in Lucidchart and import it into Excel.

1. Sign up for a free Lucidchart Account

2. create a new document and add basic shapes .

When you create a new document in Lucidchart, there are two options: starting from scratch or using a template. Templates are a great option if you want to save time, but don’t be deterred by creating your own from scratch— with Lucidchart both options are simple and straightforward.

Starting from a template

Lucidchart offers several pre-made network diagram templates in its library. To find the right template that fits your needs click  “+Document” or the “More Templates” button. Then select “Network” from the panel on the left. You can also use the search bar in the upper lefthand corner and search “network diagram.” For additional information on the different templates, click it once to read more about it.

All Lucidchart templates are customizable—move, add, or delete shapes and arrows until the diagram suits your needs

Starting from scratch 

If you would rather create your own network diagram using the shape library, open a blank document by clicking “+Blank” at the top of the homepage. 

3. Add shapes and lines 

It’s easy to quickly add all the shapes, lines, and text you will need when you use Lucidchart.

First, you will need to add the correct shape library to your shape menu. To do this select “+Shape” in the bottom left of the shape menu. A pop-up window will appear. In the left panel scroll down until you find “Cisco Network Icons” and select it. A checkmark will appear in the box indicating that it was added to your shape menu. A preview of the shapes will appear to ensure that you selected the correct library. Exit the window.  

Drag and drop shapes onto the canvas to start diagramming. To connect the shapes, click and drag your cursor drawing a line between them. 

• Connect the red dots with lines to keep the shapes linked.

4. Add text 

Now that you have your network diagram mapped with the appropriate devices and shapes it is time to add text. Double-click the shape to add text and begin typing.

To add text to your arrows double click the arrow and begin typing. 

It’s just as easy to edit text—simply repeat the same process. Modify the text size, font, color, and more using the properties bar at the top of the editor.

Once you’ve finished you will have a complete network diagram. Continue to move and add device shapes as needed if your network grows.

Network diagram template For Excel

More on network diagrams

Additional resources.

• How to Draw a Network Diagram
• What is a Network Diagram
• Network Diagram Symbols and Icons
• Why you should visualize your cloud infrastructure

For more storage space and diagram choices, sign up for a free trial of a Pro account. It’s risk-free, no credit card required!

• A Network Switch Mapping Solution
• More Details
• Program Requirements
• Switch Compatibility List
• Getting Started
• Licensing FAQ
• How to Upgrade
• Revision History

Managed Switch Port Mapping Tool Overview, Details and Videos

What exactly is the managed switch port mapping tool.

It's a powerful switch information gathering tool for network administrators - interested? read on...

Managed Switch Port Mapping Tool Overview

The Managed Switch Port Mapping Tool is a Windows application designed to 'map' or discover information about a network switch's ports and report on the attached devices. It does this by accessing switch internal information using Simple Network Management Protocol (SNMP) over the network. SNMP access credentials must be provided in order to access the data in the switch. The amount of data retrieved depends on the extent of the switch manufacturer's SNMP implementation.

What information can we get from the switch?

The Managed Switch Port Mapping Tool can retrieve essential information needed by network administrators such as the port identification or naming, status, speed and VLAN assignments. See the MAC addresses of attached devices and optionally IP addresses and device hostnames. Need help with topology? we can display LLDP, CDP, Link Aggregation (LACP/LAG/IEEE802.3ad/PAGP) information recorded by the switch showing connectivity to devices, other switches or servers.

Switches can be manually mapped one at a time or in groups using Switch Lists

Switch mappings can be done manually from the GUI interface or through command line parameters on a scheduled basis using Windows Task Scheduler (the GUI will appear even if started from the command line). The results of every switch mapping are automatically saved into an SQLite database for later retrieval, searching or analysis. Results may be optionally saved to XML text files for independent analysis using spreadsheets.

Product Information

• The Managed Switch Port Mapping tool communicates with managed Ethernet network switches using SNMPv1/v2c/v3 and discovers the MAC addresses and other information about devices attached to the physical port jacks on the front of the switches. The app requires Microsoft Windows® and can be also used on Apple MAC OSX if you use Windows inside a virtual machine like VMware Fusion or Parallels.
• No switch is too big or too small, but it must be capable of being 'managed' using SNMP (simple network management protocol) and it must support certain MIBs. It's been used on switches as small as the Cisco SF 300-08 series all the way up to core switches like the Cisco 6500 series.
• Simple to use: enter the switch IPv4 address and the SNMP v1/v2c/v3 read-only credentials. Then press Map Switch. We do the rest. Watch one of the videos to see it in action.
• Results are presented in a spreadsheet-like grid. Print the results or export them to your favorite spreadsheet program as either tab-delimited text or as XML.
• Available as an app installed on your hard drive or as a fully portable app that runs from a USB Flash Drive.
• Fast - supports SNMP v2c/v3 Bulk Transfer mode. This mode reduces required SNMP bandwidth.
• Map Switches Manually one at a time or as a set of switches in a list.
• Switch Lists - map a group or set of switches, record the mapping results in the History Database and optionally automatically export the XML results for each switch to files as the switch list is mapped.
• History Database - all switch mappings are automatically saved here. Searchable. Review a switch mapping at a later time.
• SNMPv1/v2c/v3 - supports USM access model SNMPv3 requests.
• Command Line - run the app from the command line using various options. Use Windows Task Scheduler to map a switch or switch list when you need it mapped. (The GUI will appear if started from the command line)
• Optional Columns - over 25 optional columns supporting RMON and Cisco packet related counters including overruns etc. Also columns reporting Voice VLAN, Trunking, Port Security (preceding are for Cisco switches only) and Assigned VLANs.
• LLDP and CDP neighbor information are reported by the switch. See neighboring devices like other switches and routers connected to a switch port (if they have LLDP or CDP enabled).
• Link Aggregation - LACP LAG (IEEE 802.3ad), PAGP and legacy HP Trunk links between switches or switches to servers are shown in the Type column and color coded for easy identification of the aggregation ports and their member ports.

The Details - what we get from the switch

• Optional Info

Switch Properties

Basic information retrieved from the switch.

The software uses SNMP to retrieve information (raw data) from the switch. The information, if available, is presented in a spreadsheet-like grid with each switch port represented as a row and the data type as a column.

Default Columns

• Interface description, name, alias (ifDescr, ifName, ifAlias - 3 columns)
• Interface type (ethernet, gigabit ethernet, tunnel, virtual, loopback etc. Shows Link Aggregation LACP/LAG/IEEE802.3ad/PAGP member ports and aggregator port.)
• VLAN (default and multiple VLAN assignments per port or by device, Voice VLAN column is optional)
• Port Status (up, down or other)
• Port Speed (10Mbps, 100Mbps, 1Gbps etc.)
• Port Duplex mode (full, half, auto, FDx, HDx etc.)
• MAC addresses of devices attached to ports
• IPv4 addresses and Hostnames of those devices if available**
• Attached device interface manufacturer - helps identify devices.
• LLDP (Link Layer Discovery Protocol) - shows neighbor connection information between devices attached to the port like switches and routers.
• CDP (Cisco Discovery Protocol) - shows neighbor connection information between devices attached to the port like switches and routers.
• Connector Present - shows whether a physical connector is present.
• Last Change Time column shows the elapsed time since a port status was changed from up to down or from down to up. Useful in determining how long a device has been online or offline.
• Interface Index (ifIndex)

**About IP Addresses

Managed switches usually operate at layer 2 which means they keep track of the MAC addresses attached to their ports not the IP addresses. When we retrieve the data from the switch, we have to find the IP address that matches the list of device MAC addresses for each port. We do this by searching ARP tables from various devices.

Optional Information Retrieved from the Switch

More columns are available to show optional data - if supported by the switch. Use Settings and Tools/Column Order and Visibility Editor to add them in.

Optional Columns

• Voice VLAN (currently Cisco only)
• Assigned VLANs per port
• Trunking - shows Cisco switch ports operating in VLAN trunking mode
• Port Security - shows Cisco switch ports with port security enabled
• Dot1x - shows 802.1x configuration data for each port
• Partner Port Id - shows the Link Aggregation IEEE802.3ad or PAGP partner port remote ID
• Spanning Tree Protocol (STP) information including port status and root information
• From RMON-MIB: Dropped Packets, CRC Errors, Undersized Packets, Oversized Packets, Fragmented Packets, Jabber Packets, Collision Errors
• From OLD-CISCO-MIB: CRC Errors, Framing Errors, Overrun Errors, Packet Ignored Errors, Packet Abort Errors, Output Collision Errors, Input Queue Full Dropped Packets
• Port input and output byte counts

We also retrieve basic properties of the switch - they are not shown in the results grid. They are shown in the web browser report and by using a right-click menu Properties selection.

• Switch Name
• Description
• Manufacturer
• Contact and Location (you can change these if you have write privileges)

Manufacturer Specific Switch Properties

We also retrieve manufacturer specific properties of the switch - if available. They are also shown in the web browser report and by using a right-click menu Properties selection.

• Model Number
• Serial Number
• Software Version (ie. IOS x.x, JUNOS, NX-OS etc.)
• Firmware Version
• Hardware Revision
• Asset Number
• Stack members are shown in the post-mapping web page report

How the Switch Mapping Results are presented

When a switch mapping is completed, you are presented with a Summary Report in your web browser. This report can be saved or printed as desired. It provides a high level analysis of what was retrieved from the switch.

The app shows the Switch Mapping results in a spreadsheet style grid. The columns of the grid can be reordered and made visible or invisible to suit the your needs. The results are searchable using one of the many selections available from the right-click popup menu.

You can export the results as either tab delimited text or XML suitable for opening directly by Microsoft Excel or OpenOffice. The imported spreadsheet retains the look and presentation of the results in the program.

Switch List results can be exported in XML and opened in Excel with each switch in the list appearing on a separate spreadsheet tab.

• Manufacturer Independent - capable of mapping many different brands and models of SNMP managed switches.
• A Time Saver - saves technicians time mapping out the physical layout of your network by helping identify network devices attached to the physical switch ports.
• Shows Upstream or Downstream Devices - shows multiple devices connected by other switches or hubs.
• Shows Switch Parameters - device MAC Address, device IP address*, hostname**, VLAN assignment, port status, speed, duplex, connected device interface manufacturer and more.
• Identifies Attached Virtual Operating Systems - reports switch ports with devices running virtual operating systems.
• Easy-to-understand Results Presentation - spreadsheet format results can be printed in color and searched for text strings.
• Export results to spreadsheet schema XML or tab delimited text files - the XML file can be directly opened by Microsoft Excel XP/2003/2007/2013/365 or OpenOffice Calc.
• Results are automatically saved in a History Database and can be reloaded for later review.
• Work with Multiple Switches Easily - switch and device 'groups' including IP addresses and access credentials are automatically saved in a database and can be loaded for rapid change between different switches. No need to re-enter switch information.
• Integrates into NetScanTools Pro Optional Tools menu - operates the app standalone or launch it from within NetScanTools Pro.

*We cannot guarantee finding an IP address for every MAC address.

**We cannot guarantee finding a hostname for every IP address - DNS access is required.

How much does it cost?

How is it licensed?

Will it work with my switches? - Try it. That's the fastest way to find out. Download and install our free 30 day trial. You will need to know your switch IPv4 address and SNMP v1/v2c community name or SNMPv3 access credentials. You will also need to be sure SNMP is enabled on the switch and you have permissions to access the internal MIBs (your computer IP may need to be on an Access Control List (ACL) or part of a specific 'view'). Please review list long list of switches that we and our customers have tested with our software. This list includes compatibility of switches reported to us by users. The list also shows switches that do not work with this software.

NetScanTools is a registered trademark of Northwest Performance Software, Inc.

'NetScanTools Pro', 'NetScanTools Standard', 'NetScanTools LE', 'ipPulse', 'Northwest Performance Software' and 'NetScanTools.com', are trademarks of Northwest Performance Software, Inc.

Any trademarked names mentioned herein are the property of their respective owners.

• General Questions
• Sales Contact or Quote
• Tech Support
• +1 (360) 683-9888

Help & Support Center

• Ways to Improve Results

General Topics

• USB Version
• Pricing and Buy Now

Other Products

• NetScanTools® Pro
• NetScanTools® Basic
• IPv6ScopeFinder

© 2024 Northwest Performance Software, Inc. All Rights Reserved. | Privacy Policy

Switch Templates

Switch templates can be used to create switches and switch ports using templates. Once you create the templates, you can either add/edit switch and switch ports using the UI or REST APIs.

Network switch templates for new and existing ports and switches ​

Switch Templates – Legacy can be used to not only create new switches and ports, but also to edit existing switches and ports.

Switch Templates 2.0 – is very similar to Legacy, however, the user doesn't have to enter port information as we discover the port definition from the hardware models to auto create the ports. You can select the hardware models that you want to generate switches from and it will create them for you.  If your hardware model also has parts slots (for modular switches) then you will be able to populate the part models that you want to prepopulate those switches with. This is typically used when manually adding these hardware types and not relying on auto-discovery of switches.

Extended properties for a switch port ​

Module or Asset to show if a port belongs to a blade or fabric extender. Network switch 2nd would represent cluster switch in case of stacked switches or 2nd switch in case of paired switches.

Catering to different switch types in the templates ​

Whether the switch is singular, modular and/or distributed, you can add any type from the templates. Also, stacked switches and paired switches can be added. All different options are discussed below.

Singular switch ​

For a simple switch, you can choose (or add) the hardware module and add the ports in that switch with port prefixes. In example shown above, ports gbe/ 24 gig0/ and fiber/ 2 Fiber would be created (you can choose port starting number for each port template). Once you save this, on the list page it displays a create/edit link next to the switch. Once you click that you can choose an existing switch or add name for new one and rest is done automatically for you.

Stacked switches ​

Taking a page from Cisco's 3750 switches, you can add multiple singular switches to the stack. Stack itself is represented by a cluster device in device42. All physical switches would belong to the cluster device and all ports would have switch2 as the cluster switch. Once you click on create switches, you would be presented with following screen.

Here you can enter a name for the cluster device(or choose an existing one) and similarly enter values for switches in the stack. Switch ports (and switches) are created based on the template.

Modular/Distributed Switch ​

This type can be used to represent modular and/or distributed switches, e.g., a single 6509 switch with modules, Nexus 7k or Nexus 5k with fabric extender modules. Modules with hardware model, slot #, port prefixes and # of ports can be added here. You can also add asset templates( for Fabric Extenders) on this screen. Based on template values, you would be asked for switch/asset name etc. and it would create the switch, modules, assets(Fabric extenders) and switch ports based on the template.

Paired modular/distributed switches ​

This template can serve few different use case scenarios. For example, Cisco VSS paired 6509s or 2 Nexus 5k running in active/active mode. You can add various port info, etc., and it will create modules/assets/switch ports. Ports on the fabric extender can be marked to show if they are connected to both the switches or just one.

• Network switch templates for new and existing ports and switches
• Extended properties for a switch port
• Catering to different switch types in the templates
• Singular switch
• Stacked switches
• Modular/Distributed Switch
• Paired modular/distributed switches

• Privacy Policy

Switch Port Mapping Excel Template

Switch Port Mapping Excel Template - Web cisco 48 port switch template diagram. If anyone can share a good excel template. Web look at the wiki for your router. You can export it in multiple formats like jpeg, png and svg and easily add it to word documents, powerpoint (ppt). If anyone can share a good excel template diagram of a 48 port switch which i can use to map ports to vlans,. It will even discover neighboring switches via cdp and scan them. Switch port mapping displays all the mac addresses connected to. Posted by chris12321 on apr 30th, 2013 at 1:33 pm. Web switch port map excel template — excelguider.com. We just use an excel spreadsheet and create a coherent map.

Switch Lists in the Managed Switch Port Mapping Tool YouTube

Web it helps network engineers discover the devices that are connected to the all the ports of a switch. The managed switch port mapping tool is a windows application designed to 'map’ or discover. Web the managed switch port mapping tool communicates with managed ethernet network switches using snmpv1/v2c/v3 and discovers the mac addresses and other information. Web look at.

Switch Port Mapping an HP ProCurve 1810G8 Network Switch YouTube

The managed switch port mapping tool is a windows application designed to 'map’ or discover. If anyone can share a good excel template diagram of a 48 port switch which i can use to map ports to vlans,. Once you create the templates, you can either add/edit switch and switch ports using the ui. If anyone can share a good.

Exporting to a Spreadsheet from the Managed Switch Port Mapping Tool

Web the managed switch port mapping tool communicates with managed ethernet network switches using snmpv1/v2c/v3 and discovers the mac addresses and other information. Web it helps network engineers discover the devices that are connected to the all the ports of a switch. Web switch templates can be used to create switches and switch ports using templates. Web look at the.

Switch Port Mapping Free Switch Port Mapper Anaaya Foods

Posted by chris12321 on apr 30th, 2013 at 1:33 pm. We have just taken delivery of a 'mature' 48 port switch for testing, deployment and general skulduggery. Web it helps network engineers discover the devices that are connected to the all the ports of a switch. Once you create the templates, you can either add/edit switch and switch ports using.

Data Mapping Spreadsheet Template Spreadsheet Downloa data mapping

Web it helps network engineers discover the devices that are connected to the all the ports of a switch. The managed switch port mapping tool is a windows application designed to 'map’ or discover. Web the basic network diagram template includes shapes for computers, servers, routers, and other parts of a network. Ad use our matrix to set goals, identify.

Patch Panel Spreadsheet Template with How Do You Document Your Network

Web does anyone know a port map template for a 48 port cisco switch, and patch panel? Web the managed switch port mapping tool communicates with managed ethernet network switches using snmpv1/v2c/v3 and discovers the mac addresses and other information. Web cisco 48 port switch template diagram. Once you create the templates, you can either add/edit switch and switch ports.

Managed Switch Port Mapping Tool FREE Download Managed Switch Port

Web switch port map excel template — excelguider.com. Web you can easily edit this template using creately. It will even discover neighboring switches via cdp and scan them. In the event that you manage a group employee or busy household, it is simple to manage important computer data. Web it helps network engineers discover the devices that are connected to.

Switch Port Map Excel Template In the event that you manage a group

Use them to document existing networks and to plan new ones. Web the managed switch port mapping tool communicates with managed ethernet network switches using snmpv1/v2c/v3 and discovers the mac addresses and other information. You can export it in multiple formats like jpeg, png and svg and easily add it to word documents, powerpoint (ppt). The managed switch port mapping.

Switch port mapping template seomsieseo

Web switch templates can be used to create switches and switch ports using templates. Web does anyone know a port map template for a 48 port cisco switch, and patch panel? Web cisco 48 port switch template diagram. Posted by chris12321 on apr 30th, 2013 at 1:33 pm. Web look at the wiki for your router.

Patch Management Spreadsheet Spreadsheet Downloa patch management excel

In the event that you manage a group employee or busy household, it is simple to manage important computer data. Web switch templates can be used to create switches and switch ports using templates. You can export it in multiple formats like jpeg, png and svg and easily add it to word documents, powerpoint (ppt). Web does anyone know a.

We just use an excel spreadsheet and create a coherent map. We have just taken delivery of a 'mature' 48 port switch for testing, deployment and general skulduggery. In the event that you manage a group employee or busy household, it is simple to manage important computer data. The managed switch port mapping tool is a windows application designed to 'map’ or discover. Web cisco 48 port switch template diagram. Ad use our matrix to set goals, identify stakeholders and execute the plan. Web the basic network diagram template includes shapes for computers, servers, routers, and other parts of a network. You can export it in multiple formats like jpeg, png and svg and easily add it to word documents, powerpoint (ppt). It will even discover neighboring switches via cdp and scan them. Once you create the templates, you can either add/edit switch and switch ports using the ui. Web switch templates can be used to create switches and switch ports using templates. Web the managed switch port mapping tool communicates with managed ethernet network switches using snmpv1/v2c/v3 and discovers the mac addresses and other information. If anyone can share a good excel template diagram of a 48 port switch which i can use to map ports to vlans,. Switch port mapping displays all the mac addresses connected to. If anyone can share a good excel template. Use them to document existing networks and to plan new ones. Web it helps network engineers discover the devices that are connected to the all the ports of a switch. Web you can easily edit this template using creately. Posted by chris12321 on apr 30th, 2013 at 1:33 pm. Web does anyone know a port map template for a 48 port cisco switch, and patch panel?

You Can Export It In Multiple Formats Like Jpeg, Png And Svg And Easily Add It To Word Documents, Powerpoint (Ppt).

It will even discover neighboring switches via cdp and scan them. The managed switch port mapping tool is a windows application designed to 'map’ or discover. If anyone can share a good excel template diagram of a 48 port switch which i can use to map ports to vlans,. We have just taken delivery of a 'mature' 48 port switch for testing, deployment and general skulduggery.

Web You Can Easily Edit This Template Using Creately.

Web the managed switch port mapping tool communicates with managed ethernet network switches using snmpv1/v2c/v3 and discovers the mac addresses and other information. Web look at the wiki for your router. Web cisco 48 port switch template diagram. Use them to document existing networks and to plan new ones.

Web The Basic Network Diagram Template Includes Shapes For Computers, Servers, Routers, And Other Parts Of A Network.

If anyone can share a good excel template. Web it helps network engineers discover the devices that are connected to the all the ports of a switch. Ad use our matrix to set goals, identify stakeholders and execute the plan. Posted by chris12321 on apr 30th, 2013 at 1:33 pm.

Switch Port Mapping Displays All The Mac Addresses Connected To.

In the event that you manage a group employee or busy household, it is simple to manage important computer data. Web does anyone know a port map template for a 48 port cisco switch, and patch panel? We just use an excel spreadsheet and create a coherent map. Once you create the templates, you can either add/edit switch and switch ports using the ui.

Related Post:

• Happy Angry Meme Template
• Printable Caaspp Practice Test
• Construction Quote Template Word
• Free Printable Coloring Pages Disney Princess
• Bible Study Invitation Template
• Free Printable Large Print Ukulele Chord Chart
• We Three Kings Lyrics Printable
• Earring Card Template Free
• Use Template In Capcut
• Oh The Places You'll Go Hot Air Balloon Template