TCL Script to log all Switch Interface Statistics to a CSV file

[claudm]

Have created a TCL script which can tabulate all the Interface Statisctics seen from the "Show Interface" command in a CSV file.

This CSV file is then copied to a TFTP server

This can then be opened up in Excel.

This was created on a 3560 switch.

Copy the file onto the Flash of the switch and run "tclsh switchstats.tcl" from the command line

Multiple of such files from different switches can be concatenated and then can be consolidated into one large file.

[felixguzman]

This can be done with EEM?

https://supportforums.cisco.com/thread/2178602?tstart=0

thanks

FGA

[claudm]

Hi Felix

You pointed me to a document on "How monitor the use of dial-peer (Connect Time)"

Can you please send me the right one ?

You can do a lot with EEM, but I have done this for a specific purpose, wherein I can create a CSV file.

This CSV file can be captured for all the switches and then the file can be opened up in Excel.

From that the information can be sorted out and then the customer can see which are the ports that are less used over a period of time.

[felixguzman]

Hello, I wonder if you can help me with this (How monitor the use of dial-peer (Connect Time) ?

Thanks,

FGA

[claudm]

Hi FGA

In case you have a command which captures the info, you can mdofiy the same script, for the router to send the information to you on a minute/hour/daily basis.

If required I can help you with this.

Claud

[felixguzman]

Hello Claudm

I want to shutdown the dial-peer when it comes to 600000 in Connect Time (100 minutes) and to become active again in a day of the month (example every day 15)

And within the same script will clean the dial-peer Statistics with this command (reset the timer dial-peer usage)

UC520#clear statistics dial-peer voice 1

Clear voice call statistics stored in this voice dial-peer [confirm]

UC520#show dial-peer voice 1

VoiceEncapPeer1

peer type = voice, system default peer = FALSE, information type = voice,

description = `** FAX **',

tag = 1, destination-pattern = `263',

voice reg type = 0, corresponding tag = 0,

allow watch = FALSE

answer-address = `', preference=0,

CLID Restriction = None

CLID Network Number = `'

CLID Second Number sent

CLID Override RDNIS = disabled,

rtp-ssrc mux = system

source carrier-id = `', target carrier-id = `',

source trunk-group-label = `', target trunk-group-label = `',

numbering Type = `unknown'

group = 1, Admin state is up, Operation state is up,

Outbound state is up,

incoming called-number = `', connections/maximum = 0/unlimited,

DTMF Relay = disabled,

URI classes:

     Destination =

huntstop = disabled,

in bound application associated: 'DEFAULT'

out bound application associated: ''

dnis-map =

permission :both

incoming COR list:maximum capability

outgoing COR list:minimum requirement

        Translation profile (Incoming):

Translation profile (Outgoing):

incoming call blocking:

translation-profile = `'

disconnect-cause = `no-service'

advertise 0x40 capacity_update_timer 25 addrFamily 0 oldAddrFamily 0

mailbox selection policy: none

type = pots, prefix = `',

forward-digits default

session-target = `', voice-port = `0/0/0',

direct-inward-dial = disabled,

digit_strip = enabled,

register E.164 number with H323 GK and/or SIP Registrar = TRUE

fax rate = system,   payload size =  20 bytes

supported-language = ''

preemption level = `routine'

bandwidth:

     maximum = 64 KBits/sec, minimum = 64 KBits/sec

voice class called-number:

     inbound = `', outbound = `'

dial tone generation after remote onhook = enabled

mobility=0, snr=, snr_noan=, snr_delay=0, snr_timeout=0

Time elapsed since last clearing of voice call statistics never

Connect Time = 8990, Charged Units = 0,

Successful Calls = 2, Failed Calls = 0, Incomplete Calls = 0

Accepted Calls = 0, Refused Calls = 0,

Last Disconnect Cause is "10  ",

Last Disconnect Text is "normal call clearing (16)",

        Last Setup Time = 10974084.

Last Disconnect Time = 10979594.

VerticeMty#show dial-peer voice 1

VoiceEncapPeer1

peer type = voice, system default peer = FALSE, information type = voice,

description = `** FAX VERTICE/VERTEX **',

tag = 1, destination-pattern = `263',

voice reg type = 0, corresponding tag = 0,

allow watch = FALSE

answer-address = `', preference=0,

CLID Restriction = None

CLID Network Number = `'

CLID Second Number sent

CLID Override RDNIS = disabled,

rtp-ssrc mux = system

source carrier-id = `', target carrier-id = `',

source trunk-group-label = `', target trunk-group-label = `',

numbering Type = `unknown'

group = 1, Admin state is up, Operation state is up,

Outbound state is up,

incoming called-number = `', connections/maximum = 0/unlimited,

DTMF Relay = disabled,

URI classes:

     Destination =

huntstop = disabled,

in bound application associated: 'DEFAULT'

out bound application associated: ''

dnis-map =

permission :both

incoming COR list:maximum capability

outgoing COR list:minimum requirement

        Translation profile (Incoming):

Translation profile (Outgoing):

incoming call blocking:

translation-profile = `'

disconnect-cause = `no-service'

advertise 0x40 capacity_update_timer 25 addrFamily 0 oldAddrFamily 0

mailbox selection policy: none

type = pots, prefix = `',

forward-digits default

session-target = `', voice-port = `0/0/0',

direct-inward-dial = disabled,

digit_strip = enabled,

register E.164 number with H323 GK and/or SIP Registrar = TRUE

fax rate = system,   payload size =  20 bytes

supported-language = ''

preemption level = `routine'

bandwidth:

     maximum = 64 KBits/sec, minimum = 64 KBits/sec

voice class called-number:

     inbound = `', outbound = `'

dial tone generation after remote onhook = enabled

mobility=0, snr=, snr_noan=, snr_delay=0, snr_timeout=0

Time elapsed since last clearing of voice call statistics never

Connect Time = 8990, Charged Units = 0,

Successful Calls = 2, Failed Calls = 0, Incomplete Calls = 0

Accepted Calls = 0, Refused Calls = 0,

Last Disconnect Cause is "10  ",

Last Disconnect Text is "normal call clearing (16)",

        Last Setup Time = 10974084.

Last Disconnect Time = 10979594.

[Carlton Patterson]

Will this work on 6500's?

[Joe Clarke]

It looks to have been designed for a desktop switch (e.g., Cat 3K).  It will need some rework and validation for a 6500.