VMware {code} Community
sajuptpm
Contributor
Contributor
‎09-11-2012 05:26 AM

QueryPerfComposite method returning bunch of values for cpu.usage.average of Virtual Machine

Hi,

QueryPerfComposite method returning bunch of values for cpu.usage.average of Virtual Machine.
How to calcuate cpu.usage.average from this bunch of values ???

Can i take one value from value list as cpu.usage.average , like ??
for childent in Query_Perf_Composite_result.childEntity:
    for v in childent.value:
        print "----childent.value--------", v.value[0]/100.00

def get_metrics_QueryPerfComposite(client, mob):
    statInterval = client.sc.perfManager.QueryPerfProviderSummary(entity=mob)
    print "------statInterval.refreshRate------", statInterval.refreshRate

    perfMetric_cpu = client.create("PerfMetricId")
    perfMetric_cpu.counterId = get_perf_counter(client, counter_key_str="cpu.usage.average")
    #perfMetric_cpu.instance = "*"

    perfSpec = client.create("PerfQuerySpec")
    perfSpec.entity = mob._mo_ref
    perfSpec.intervalId = statInterval.refreshRate
    perfSpec.metricId = [perfMetric_cpu]
    perfSpec.maxSample = 1

    result = client.sc.perfManager.QueryPerfComposite(querySpec=perfSpec)
    parent = result.entity
    for v in parent.value:
        pass

    for childent in result.childEntity:##Virtual MAchines
        for v in childent.value:
            print "----childent.value--------", v

client = Client("192.168.0.105", "root", "xxxxx")##Esxi
hosts = HostSystem.all(client)
get_metrics_QueryPerfComposite(client, hosts[0])

######### Output ########

------statInterval.refreshRate------ 20
====counterid==== 1
====counterid==== 65537
--Parent name-- localhost.localdomain
----childent.value-------- (PerfEntityMetric){
   entity = <psphere.managedobjects.VirtualMachine object at 0x949cc10>
   sampleInfo[] =
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:22:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:22:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:22:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:23:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:23:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:23:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:24:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:24:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:24:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:25:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:25:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:25:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:26:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:26:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:26:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:27:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:27:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:27:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:28:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:28:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:28:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:29:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:29:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:29:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:30:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:30:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:30:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:31:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:31:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:31:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:32:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:32:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:32:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:33:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:33:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:33:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:34:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:34:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:34:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:35:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:35:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:35:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:36:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:36:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:36:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:37:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:37:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:37:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:38:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:38:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:38:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:39:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:39:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:39:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:40:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:40:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:40:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:41:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:41:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:41:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:42:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:42:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:42:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:43:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:43:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:43:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:44:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:44:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:44:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:45:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:45:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:45:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:46:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:46:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:46:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:47:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:47:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:47:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:48:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:48:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:48:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:49:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:49:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:49:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:50:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:50:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:50:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:51:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:51:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:51:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:52:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:52:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:52:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:53:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:53:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:53:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:54:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:54:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:54:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:55:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:55:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:55:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:56:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:56:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:56:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:57:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:57:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:57:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:58:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:58:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:58:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:59:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:59:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 22:59:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:00:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:00:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:00:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:01:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:01:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:01:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:02:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:02:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:02:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:03:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:03:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:03:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:04:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:04:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:04:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:05:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:05:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:05:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:06:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:06:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:06:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:07:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:07:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:07:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:08:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:08:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:08:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:09:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:09:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:09:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:10:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:10:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:10:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:11:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:11:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:11:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:12:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:12:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:12:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:13:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:13:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:13:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:14:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:14:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:14:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:15:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:15:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:15:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:16:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:16:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:16:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:17:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:17:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:17:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:18:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:18:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:18:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:19:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:19:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:19:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:20:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:20:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:20:40
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:21:00
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:21:20
         interval = 20
      },
      (PerfSampleInfo){
         timestamp = 2012-09-11 23:21:40
         interval = 20
      },
   value[] =
      (PerfMetricIntSeries){
         id =
            (PerfMetricId){
               counterId = 1
               instance = None
            }
         value[] =
            276,
            255,
            200,
            314,
            303,
            233,
            492,
            268,
            241,
            281,
            292,
            371,
            269,
            278,
            199,
            208,
            344,
            214,
            295,
            256,
            214,
            216,
            297,
            260,
            283,
            614,
            360,
            223,
            242,
            290,
            295,
            259,
            236,
            217,
            198,
            315,
            366,
            267,
            266,
            258,
            213,
            456,
            299,
            275,
            249,
            277,
            242,
            173,
            356,
            367,
            587,
            329,
            222,
            227,
            318,
            356,
            419,
            314,
            219,
            208,
            275,
            313,
            244,
            276,
            248,
            184,
            859,
            349,
            280,
            312,
            313,
            361,
            252,
            289,
            266,
            310,
            263,
            225,
            257,
            254,
            295,
            313,
            282,
            233,
            254,
            303,
            725,
            290,
            1162,
            262,
            277,
            224,
            219,
            331,
            265,
            236,
            595,
            205,
            239,
            341,
            298,
            380,
            289,
            307,
            194,
            310,
            530,
            460,
            270,
            238,
            220,
            225,
            321,
            258,
            292,
            649,
            370,
            229,
            303,
            234,
            312,
            262,
            232,
            230,
            194,
            297,
            501,
            282,
            272,
            266,
            249,
            700,
            343,
            268,
            263,
            248,
            250,
            262,
            301,
            233,
            243,
            274,
            213,
            252,
            342,
            330,
            442,
            263,
            221,
            216,
            328,
            246,
            274,
            264,
            233,
            274,
            302,
            319,
            267,
            284,
            276,
            441,
            327,
            318,
            257,
            268,
            265,
            356,
            253,
            245,
            283,
            272,
            238,
            277,
            240,
            283,
            437,
            294,
            726,
            241,
      },
}

Reply
0 Kudos
0 Replies