Friday, November 19, 2021

software to convert a connection table to a topology diagram

I have a large table describing layer 1 connections between nodes. Each row represents a physical connection between two devices. There are columns representing device A, port A, device B, port B, and connection type (like serial or ethernet). There is (ideally) no differentiating device A and device B, they're just connection endpoints and reversing them doesn't change anything.

Yes I know you can "import" excel spreadsheets into Visio, but it doesn't add the connectors automatically, and you can't even label the endpoints of connectors at all, which I would think is a no-brainer for anything used to diagram networks. Automatic network discovery tools will not work. While these devices are always connected, most of them are powered off most of the time, and some connections have strict firewalls that I do not control in between.

This table is part of a larger inventory tracking database. Most of our assets are actually disconnected from any network, whether or not they're always powered on.



No comments:

Post a Comment