Virtualization Sprawl

Hi Guys,

I'm running the 'Virtualization Sprawl' option under 'MY DASHBOARDS\Virtualization, and on the dashboard I can see a table column in Widgets named 'CPU' or 'Memory Recommendation' I am presented with recommendations on the allocation of vCPUs and vMemory against each VM, and have the ability to Add and Remove these assets from the VM.

However, I want to add this column into a 'Report' and I cannot find it anywhere in SWQL Studio so that I can add this column into a Report and or Dashboard.

I have looked in SWQL Studio and searched the following;

Orion Virtualization

Virtualization Sprawl

Virtualization Instance

Virtualization Statistics

But cannot find the vCPU Recommendation, OR Memory Recommendation table.

Can anyone help please.

Find more posts tagged with

Reports

vman

vcpu

sprawl

vMemory

Over Allocation

Accepted answers

All comments

dodo123

this may help, but think you should search for 'recommendation'

SELECT TOP 1000 ActionID, Type, Action, RecommendationID, Primary, Description, Optional, Status, FailureMessage, DateStarted, DateFinished, BatchID
FROM Orion.Recommendations.Actions

bootneck1111

Found it,

In this table I can see 'Name of entry' such as "Decrease CPU on VM"

Then there's a 'Description' column, for example "Decrease the number of CPUs on VM (4 CPUs to 2 CPUs)

Exactly what I need to push into a Report for Management to highlight 'Over Allocated Resources' across there VMware environment.

Thank you for your support.

SELECT TOP 1000 * FROM [dbo].[RE_Recommendations]

(SolarWindsOrion - RE_Recommendations