Report Creation - Get VM parent host metrics

[iam_exio]

Hello,

I want to create a report to show maximum VM usage metrics and Physical available resources.

Example:

table 1

VM Name	VM CPU Usage MHz	Parent Host Available CPU MHz	Parent Host Available CPU %	VM Memory Usage GB	Parent Host Available Memory GB	Parent Host Available Memory %

table 2

VM Name	VM Network usage	Physical Available Network bandwidth	VM IOPs	Physical Available IOPs

I already have contention,ready and latency reports.

I'm trying to use supermetrics for this, but i'm still researching.

Has anyone created something like this?

[ooajala]

If I am understanding your request, you can just create a view with those metrics by using the Usage (MHz) metric for VM CPU and Memory because those metrics are just sitting there for you to use.

[marinthal]

Create a view using the suggested metric(s) and change the transformation to Maximum.

[erikverbruggen]

Maybe you can do it with something like this as a super metric: avg(${adaptertype=VMWARE, objecttype=HostSystem,attribute=cpu|capacity_usagepct_average, depth=-1})

This displays the cpu capacity usage (%) metric of the parent host of the vm.

You will need to apply the metric on the virtual machine object and of course enable it in a policy applied to the vm's.

[iam_exio]

Created 2 supermetrics:

Parent Host % Memory Remaining

100-max(${adaptertype=VMWARE, objecttype=HostSystem, attribute=mem|usage_average, depth=-1})

Parent Host % CPU Remaining

100-max(${adaptertype=VMWARE, objecttype=HostSystem, attribute=cpu|usage_average, depth=-1})

I tried using Capacity remaining %, but it seems the metric is a rollup or something.

And yes Depth -1 is the trick!

Now i just need something for Network and Storage...