Yrurtj

I am working on a script. I have bits and pieces what I am trying to bring them together, however....the script handling the login into devices and collecting the data is written in python.

#!/usr/bin/env python

from __future__ import print_function

from netmiko import Netmiko

from getpass import getpass

import sys

import re



# Prompts for username and password

p = getpass("Enter password: ")



# Creates empty list to be used later n script for device dictionaries

devices = 



# Creates list of ip addresses of devices

ips = ["ip1", "ip2"]



# Loop used to generate device dictionaries from ips list and

# stores dictionary entry in devices list

for ip in ips:

    cisco_asa = {

        "device_type": "cisco_asa",

        "host": ip,

        "username": "python",

        "password": p,

    "secret": p,

    }

    devices.append(cisco_asa)



cmd_system = "changeto system"

cmd_nopager = "terminal pager 0"

cmd_failip = "sh failover | in ):|host"



for device in devices:

    net_connect = Netmiko(**device)

    net_connect.enable()

    print(net_connect.find_prompt())

    output1 = net_connect.send_command(cmd_system)

    output2 = net_connect.send_command(cmd_nopager)

    print(net_connect.find_prompt()+cmd_name)

    output = net_connect.send_command(cmd_name)

    print(output) 

    net_connect.disconnect()  

This will generate an output like...

TESTASA1#sh failover | in ):|host

        This host: Secondary - Active

                  admin Interface dmz (10.149.41.1): Normal (Not-Monitored)

                  admin Interface admin (10.149.41.24): Normal (Not-Monitored)

                  INTER Interface outside (164.54.212.23): Normal (Not-Monitored)

                  INTER Interface inside (10.149.51.77): Normal (Not-Monitored)

        Other host: Primary - Standby Ready

                  admin Interface dmz (10.149.41.2): Normal (Not-Monitored)

                  admin Interface admin (10.149.41.23): Normal (Not-Monitored)

                  INTER Interface inside (10.149.51.78): Normal (Not-Monitored)

                  INTER Interface outside (164.54.212.24): Normal (Not-Monitored)



TESTASA2#sh failover | in ):|host

        This host: Secondary - Active

                  admin Interface dmz (10.149.41.1): Normal (Not-Monitored)

                  admin Interface admin (10.149.41.24): Normal (Not-Monitored)

                  INTER Interface outside (164.54.212.23): Normal (Not-Monitored)

                  INTER Interface inside (10.149.51.77): Normal (Not-Monitored)

        Other host: Primary - Standby Ready

                  admin Interface dmz (10.149.41.2): Normal (Not-Monitored)

                  admin Interface admin (10.149.41.23): Normal (Not-Monitored)

                  INTER Interface inside (10.149.51.78): Normal (Not-Monitored)

                  INTER Interface outside (164.54.212.24): Normal (Not-Monitored)

...then formatting of the data is done with awk against the python_output

#!/bin/sh

awk  '

BEGIN  {FS="[)#/(:]"; OFS = ",";fw="";dev=""}

{

        if ($0~/#/) fw=$1 ;

        if (($0~/host/)&&($0~/Primary - Active/)) dev=fw"/pri/act";

        if (($0~/host/)&&($0~/Primary - Standby/)) dev=fw"/pri/stdby";

        if (($0~/host/)&&($0~/Secondary - Active/)) dev=fw"/sec/act";

        if (($0~/host/)&&($0~/Secondary - Standby/)) dev=fw"/sec/stdby";

        if ($0~/):/) {

                print $2,dev,substr($1,match($1, "face")+5,length($1))

                }

}' python_output >> datadb.csv

and the end result...

10.149.41.1,TESTASA1/sec/act,dmz 

10.149.41.24,TESTASA1/sec/act,admin 

164.54.212.23,TESTASA1/sec/act,outside

I tried to research how to bring awk and python together but general advise it should not be mixed. I have a couple of different awk modules and being very beginner with python, the whole splitting and sub-string is more then challenging for me. My final script will be bigger incorporating multiple awk calls, so once awk is done the control should be passed back to python script.

Thanks for the help!