×

Warning message

  • Cisco Support Forums is in Read Only mode while the site is being migrated.
  • Cisco Support Forums is in Read Only mode while the site is being migrated.

Export physical and logical details on ASA 5520 and 8.0 software

Answered Question
Jan 9th, 2012
User Badges:

Hello...does anybody know if there is any way to export details of the physical and logical interface details (including interface descriptions) to Excel, PDF or and other format from the command line or ASDM? 


Thanks,

John

Correct Answer by Marvin Rhoads about 5 years 7 months ago

Export directly in xls, xlsx or pdf - no.


The output of "show run interface" or "show interface" is pretty structured however and easily parsed by Excel - either manually or via a macro. See output below (you can omit the interface identifier to get all interfaces. I used one for brevity.)


One can build a script to log in, perform an arbitrary command logging the output to a file which can then be massaged to extract the information you want in a suitable format (csv, etc.). Once in Excel it can be saved as pdf if you're so inclined.


Of couse, some of the full-featured network management tools do a lot of this (and lots more) if you have them.



ASA-1# sh run int eth0/0

!

interface Ethernet0/0

nameif outside

security-level 0

ip address x.x.x.x 255.255.255.224

ASA-1#


ASA-1# sh int eth0/0

Interface Ethernet0/0 "outside", is up, line protocol is up

  Hardware is i82546GB rev03, BW 1000 Mbps, DLY 10 usec

Auto-Duplex(Full-duplex), Auto-Speed(1000 Mbps)

Input flow control is unsupported, output flow control is unsupported

MAC address 0013.c480.6b50, MTU 1500

IP address x.x.x.x, subnet mask 255.255.255.224

14156274 packets input, 16095096189 bytes, 0 no buffer

Received 44764 broadcasts, 0 runts, 0 giants

0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored, 0 abort

0 pause input, 0 resume input

0 L2 decode drops

8548524 packets output, 1006461151 bytes, 0 underruns

0 pause output, 0 resume output

0 output errors, 64 collisions, 6 interface resets

95 late collisions, 627 deferred

0 input reset drops, 0 output reset drops, 0 tx hangs

input queue (blocks free curr/low): hardware (255/230)

output queue (blocks free curr/low): hardware (255/125)

  Traffic Statistics for "outside":

14156267 packets input, 15839536990 bytes

8548619 packets output, 820243613 bytes

39502 packets dropped

      1 minute input rate 2 pkts/sec,  349 bytes/sec

      1 minute output rate 2 pkts/sec,  425 bytes/sec

      1 minute drop rate, 0 pkts/sec

      5 minute input rate 2 pkts/sec,  2091 bytes/sec

      5 minute output rate 1 pkts/sec,  352 bytes/sec

      5 minute drop rate, 0 pkts/sec

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Correct Answer
Marvin Rhoads Mon, 01/09/2012 - 19:18
User Badges:
  • Super Silver, 17500 points or more
  • Hall of Fame,
  • Cisco Designated VIP,

    2017 Firewalling, Network Management, VPN

Export directly in xls, xlsx or pdf - no.


The output of "show run interface" or "show interface" is pretty structured however and easily parsed by Excel - either manually or via a macro. See output below (you can omit the interface identifier to get all interfaces. I used one for brevity.)


One can build a script to log in, perform an arbitrary command logging the output to a file which can then be massaged to extract the information you want in a suitable format (csv, etc.). Once in Excel it can be saved as pdf if you're so inclined.


Of couse, some of the full-featured network management tools do a lot of this (and lots more) if you have them.



ASA-1# sh run int eth0/0

!

interface Ethernet0/0

nameif outside

security-level 0

ip address x.x.x.x 255.255.255.224

ASA-1#


ASA-1# sh int eth0/0

Interface Ethernet0/0 "outside", is up, line protocol is up

  Hardware is i82546GB rev03, BW 1000 Mbps, DLY 10 usec

Auto-Duplex(Full-duplex), Auto-Speed(1000 Mbps)

Input flow control is unsupported, output flow control is unsupported

MAC address 0013.c480.6b50, MTU 1500

IP address x.x.x.x, subnet mask 255.255.255.224

14156274 packets input, 16095096189 bytes, 0 no buffer

Received 44764 broadcasts, 0 runts, 0 giants

0 input errors, 0 CRC, 0 frame, 0 overrun, 0 ignored, 0 abort

0 pause input, 0 resume input

0 L2 decode drops

8548524 packets output, 1006461151 bytes, 0 underruns

0 pause output, 0 resume output

0 output errors, 64 collisions, 6 interface resets

95 late collisions, 627 deferred

0 input reset drops, 0 output reset drops, 0 tx hangs

input queue (blocks free curr/low): hardware (255/230)

output queue (blocks free curr/low): hardware (255/125)

  Traffic Statistics for "outside":

14156267 packets input, 15839536990 bytes

8548619 packets output, 820243613 bytes

39502 packets dropped

      1 minute input rate 2 pkts/sec,  349 bytes/sec

      1 minute output rate 2 pkts/sec,  425 bytes/sec

      1 minute drop rate, 0 pkts/sec

      5 minute input rate 2 pkts/sec,  2091 bytes/sec

      5 minute output rate 1 pkts/sec,  352 bytes/sec

      5 minute drop rate, 0 pkts/sec

Actions

This Discussion