Forum Discussion
George_32256
Nimbostratus
NimbostratusExtracting CSV data for SSL Statistics with pycontrol/suds
I'm trying to get the CSV data for the Performance SSL TPS graphs so we can determine which vips are using the most TPS but I can't figure out the syntax of the commands from the icontrol wiki. This is what I have so far:
b = pc.BIGIP(
hostname = '192.168.3.2',
username = 'admin',
password = 'eclipse',
fromurl = True,
wsdls = ['System.Statistics'])
b.get_performance_graph_csv_statistics(
in PerformanceStatisticQuery[]
Query.object_name = "CPU0"
Query.start_time = 0
Query.end_time = 0
Query.interval = 0
Query.maximum_rows = 0);
This isn't working plus not sure where data will be placed, what it will be named or if I get to choose somehow? I'm a python novice so that may be part of the problem here.
George Thompson
7049937006
george.thompson2@hp.com
- JRahm
Admin
You need to send a dictionary. First, you'll want to get the object_name from get_performance_graph_list (the graph_name value), then supply like this:
stats.get_performance_graph_csv_statistics(objects = [{'object_name': 'detailthroughput2', 'start_time': 0, 'end_time': 0, 'interval': 0, 'maximum_rows': 0}]
HTH...Jason - JRahmsorry the stats is a shortcut for the interface (stats = b.System.Statistics), full would be b.System.Statistics.get_performance_graph_csv_statistics()
L4L7_53191@George: You can see an example of this very call in the TPS report script that I wrote a while back:
http://devcentral.f5.com/weblogs/jason/archive/2010/10/04/2048-bit-infrastructure-impact-reporting-tool.aspx
Hopefully this helps. Also, please post back what you cook up to code share! If you run into any issues please post back and we'll help you out.
-Matt- L4L7_53191Addendum: Sorry, I missed something. In looking at what you're trying to accomplish, I think you may be better off with SNMP polling against the appropriate OIDs - the graph data will give you VIP-level SSL TPS ; instead, it's more system-level.
-Matt
