cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 7

Dashboard Trend/Top-N with custom attribute

Jump to solution

I'm new to virtualization manager, so my apologies up front.

I'm wanting to create widget on a dashboard that does a calculation of two attributes together.

Specifically, I want to report showing the top VM's that have the highest Throughput per Used Capacity. (IE "/virtualMachine/totalThroughputUtilization/week"  / "/virtualMachine/totalStorageSizeUsed")  How do I go about doing that? i would perfer the 'Top-N' approach as that looks most appropriate.

Thanks for any help ahead of time.

0 Kudos
1 Solution
Level 12

Hello, when you add columns into the Top-N widget you can use your own xPath expressions in "Field" box. So your widget can look like that:
pastedImage_0.png

The xPath expression is:

/virtualMachine/totalThroughputUtilization/week/text() * 1024 div /virtualMachine/totalStorageSizeUsed/text()

Keep in mind that due to different units of the attributes (totalThroughputUtilization [kB/s] vs. totalStorageSizeUsed [B]) it's necessary to multiple ThroughputUtilization by 1024.

You can see various xPath expressions in "VM CPU Underallocated" Top-N widget ("VM Sprawl" dashboard) or "Predicted VM Disk Depletion" Top-N widget ("Storage" dashboard).

Should you have any questions, feel free to ask.

View solution in original post

3 Replies
Level 12

Hello, when you add columns into the Top-N widget you can use your own xPath expressions in "Field" box. So your widget can look like that:
pastedImage_0.png

The xPath expression is:

/virtualMachine/totalThroughputUtilization/week/text() * 1024 div /virtualMachine/totalStorageSizeUsed/text()

Keep in mind that due to different units of the attributes (totalThroughputUtilization [kB/s] vs. totalStorageSizeUsed [B]) it's necessary to multiple ThroughputUtilization by 1024.

You can see various xPath expressions in "VM CPU Underallocated" Top-N widget ("VM Sprawl" dashboard) or "Predicted VM Disk Depletion" Top-N widget ("Storage" dashboard).

Should you have any questions, feel free to ask.

View solution in original post

Level 7

Thanks!

Great instructions and great reference to examples!

One additional question before I mark this answered.  Is there a way to use the xPath expression on the sort field of Top-N widget?

Thanks again!

0 Kudos
Level 12

No, in Top-N widget you can sort items based on attributes only.

As a workaround, you can also create a new trend and use it in Trend widget to see top "X" items, including historical changes. Something like this:
pastedImage_0.png

You can find more info about Trends in VMAN Admin manual (Trends).

And Trend widget may look like this:

pastedImage_1.png

I'm not sure if it's feasible for you. So if you prefer Top-N widget then it's not possible to sort items via xPath expressions.

0 Kudos