Switch Port Description - Macro/Spreadsheet/Technique
I was curious to know what others use to add port descriptions to switches when they have a spreadsheet from vendors with the information needed already provided. My vendor gives me a spreadsheet with the patch panel(drop) number and the room number used for our naming convention and I was looking for a better way to get this data together and apply it to my switches (sometimes multiple stacks of 8 or more 3750's) in a more efficient manner.
Re: Switch Port Description - Macro/Spreadsheet/Technique
I use two methods:
Method One - Excel
I use Excel's 'CONCATENATE' function. I enter the commands and variables into columns. Then I use a formula with concatenate to build the full string for each custom command. You then have to highlight the resulting column and do a COPY -> PASTE SPECIAL -> VALUES. Once you have the commands, you can simply COPY -> PASTE into a console or telnet session. Be cautious though, as you have to be absolutely certain your commands are built correctly and that you know exactly what the outcome will be. Once you hit paste, there's no turning back. If you don't write the config and make a mistake, you can always reboot the switch (assuming there's the opportunity to do so). You may also want to limit the number of commands you send to the switch at once as you may overflow the buffer. If you need an example, give me some sample data and I can send you a spreadsheet with what I'm talking about already completed for you.
Method Two - Perl
I have written Perl scripts that will take in a CSV file and parse it to arrays. I then open a telnet session and run the commands I need to, inserting the variables from the CSV file as appropriate. I have also used Perl scripts to do some work in reverse, namely crawling a subnet or list of IP addresses to login to each Cisco device and output information like 'sh ver' and 'sh cdp neigh' to get a quick glance at the network physical and data link layers.
We are pleased to announce availability of Beta software for 16.6.3.
16.6.3 will be the second rebuild on the 16.6 release train targeted
towards Catalyst 9500/9400/9300/3850/3650 switching platforms. We are
looking for early feedback from customers befor...
Introduction Featured Speakers Luis Espejel is the Telecommunications
Manager of IENova, an Oil & Gas company. Currently he works with Cisco
IOS® and Cisco IOS XE platforms, and NX to some extent. He has also
worked as a Senior Engineer with the Routing P...
In this session you can learn more about Layer 3 multicast and the best
practices to identify possible threats and take security measures. It
provides an overview of basic multicast, the best security practices for
use of this technology, and recommendati...