From: Antonie Henning - MWEB (AHenning@mweb.com)
Date: Fri Jan 23 2009 - 11:05:46 ARST
I would say if you had to ask, use autoexpect to build the script for
you. You don't need any programming skills to use autoexpect. It is
similar to the macro record feature in excel. Then, once you are happy
autoexpect made a script that is working for you, clean the script, as
autoexpect is a bit messy. When you run the script you will then have
raw output, which you will have to parse and output to a file that you
will graph (e.g ./script.exp > csm.out). I would suggest mrtg for that
but since you want to use excel, I would output the parsed data into a
csv file which you can open in excel.
However cisco have a mib for the csm, all this can be done with one
liner by pulling the info via snmp:
snmpwalk -v1 -c private 10.10.10.10
CISCO-SLB-MIB::slbVirtualNumberOfConnections.9 | sed 's/"/ /g' | awk
'{print $2, $5}'
Change private to your snmp community, change the ip address to your
loadbalancers address and .9 to the module number where the csm is
installed in. You can send the output to a csv file by adding > csm.csv
at the end and opening the file in excel. Again mrtg would be easier,
but if you have to do it in excel you would have to make another similar
line to prepend the new values every 30 minutes.
HTH
21500.org
-----Original Message-----
From: nobody@groupstudy.com [mailto:nobody@groupstudy.com] On Behalf Of
shiran guez
Sent: 22 January 2009 06:02 PM
To: Tyson Scott
Cc: testing testing123; ccielab@groupstudy.com
Subject: Re: script to log into cisco csm load balancer
I use python as it is more flexible then expect and much easy syntax
then
perl here is an real small exmple but you can actually do what you
described
you need in not much more code lines:
============================================================
#!/usr/bin/python
import getpass
import sys
import telnetlib
HOST = raw_input("Enter your remote address: ")
user = "user"
password = "pass"
enable = "enapass"
tn = telnetlib.Telnet(HOST)
tn.read_until("Username: ")
tn.write(user + "\n")
if password:
tn.read_until("Password: ")
tn.write(password + "\n")
tn.write("enable\n")
if password:
tn.read_until("Password: ")
tn.write(enable + "\n")
tn.write("show ip int b | ex una\n")
tn.write("exit\n")
print tn.read_all()
========================================================
Good luck
On Wed, Jan 21, 2009 at 1:02 AM, Tyson Scott <tscott@ipexpert.com>
wrote:
> Perl or Expect will provide you the greatest functionality and
> customization
> in my opinion. Perl has a lot more examples that you can easily
obtain off
> of the internet. Expect is a great tool for network admins.
>
> Regards,
>
> Tyson Scott - CCIE #13513 R&S and Security
> Technical Instructor - IPexpert, Inc.
>
> Telephone: +1.810.326.1444
> Cell: +1.248.504.7309
> Fax: +1.810.454.0130
> Mailto: tscott@ipexpert.com
>
>
> -----Original Message-----
> From: nobody@groupstudy.com [mailto:nobody@groupstudy.com] On Behalf
Of
> testing testing123
> Sent: Tuesday, January 20, 2009 5:27 PM
> To: ccielab@groupstudy.com
> Subject: script to log into cisco csm load balancer
>
> What language should I use to write a script to log into my cisco csm
> load balancer and check the usage ? The place I work for doesn't have
> any industry tools like HP Openview, CIscoworks, solarwinds, or
> anything like that. I want it to log into the csm once every half
> hour and check the connections of the serverfarms and export it to a
> spreadsheet that will automatically graph that data.
>
> thanks
>
>
> Blogs and organic groups at http://www.ccie.net
>
>
This archive was generated by hypermail 2.1.4 : Sun Mar 01 2009 - 09:43:39 ARST