Python & Excel – move data from one spreadsheet to another using openpyxl

System A: Currently working on a big project and giving hand with some customized task automation. The systems are bootstraped using Ansible and it is calling the information from an clinet onboarding excel spreadsheet, as shown in ‘client_onboarding_sys1.xlsx. System B: During the boostrapping, the team also wants to use some of the data from the… Read More Python & Excel – move data from one spreadsheet to another using openpyxl

netstat commands for practical use

“netstat” command for my reference: The netstat command symbolically displays the contents of various network-related data structures for active connections. The Interval parameter, which is specified in seconds, continuously displays information regarding packet traffic on the configured network interfaces. If you want to check the TCP/UDP, think of tuna, run “netstat -tuna” command.

Python class, simple switch example

This is a simple Python class example to understand the use of Python class. 1. Here is a simple class called switch. 2. Use the class to assign arguments to each switch. sw1 = switch(‘SYD-SW01’, 48, “Cisco”)sw2 = switch(‘MEL-SW01’, 48, “HP”)sw3 = switch(‘BRI-SW01’, 24, “Juniper”) 3. Get the hostnames sw1.hostname‘SYD-SW01’sw2.hostname‘MEL-SW01’sw3.hostname‘BRI-SW01’ 4. Get the interface numbers… Read More Python class, simple switch example

Ansible : Replace, insert, update and delete lines using Regex and fileinline.

While you are using Ansible, you also want to be able to handle the strings and text as you like using few method. In this example, we will use some simple regex expressions and fileinline to make modification to the content of our files. After matering these simple tricks, you can apply them straight to… Read More Ansible : Replace, insert, update and delete lines using Regex and fileinline.

UnetLab – Day 1e, Extended Access Lists, (Cisco router ACL lab)

Extended Access List (ACL) Can use source/destination IP Addresses Can use source/destination port number Can use protocol types Uses numbering between 100-199, 2000-2999 Remove the previous ACLs. R2(config)#do show ip access-listStandard IP access list in-acl20 deny 1.1.34.3 (5 matches)30 deny any (1406 matches)Standard IP access list inbound-acl10 deny 1.1.34.4 (5 matches)20 permit any (82 matches)R2(config)#no… Read More UnetLab – Day 1e, Extended Access Lists, (Cisco router ACL lab)