SWQL - Virtual machine state (Critical, Warning and etc)

ShoutDown

The Orion.VIM.VirtualMachines table doesn't show the current VM status. For example, on the VIM main page /Orion/VIM/Summary.aspx?view=VIM+Summary, the machine is in Guest Status Critical, but in the cell Overallall Status, it's green. How can I get the current value?

 

pratikjajal

Hi @ShoutDown ,

Please try the below SQL query — it should return the required output. You can use it within your modern dashboard or report to visualize the results.

SQL Query:
SELECT
v.VirtualMachineID,
v.Name AS [VM Name],
v.HostID,
v.GuestName,
v.GuestState,
v.PowerState,
v.OverallStatus,
v.ManagedStatus,
v.TriggeredAlarmDescription,
v.ConsumedPercentMemLoad,
v.CpuLoad,
v.MemUsageMB,
v.NetworkUsageRate,
v.LastActivityDate
FROM VIM_VirtualMachines AS v
ORDER BY v.Name;

Column Meaning
OverallStatus: VM’s current overall health (numeric code, used internally for color in UI)
ManagedStatus: Management/connection state of VM (numeric code)
GuestState: Guest OS state (Running, Stopped, Suspended, etc.)
PowerState: VM power status (PoweredOn, PoweredOff, etc.)
TriggeredAlarmDescription: Active VMware alarms that may mark VM as Critical
ConsumedPercentMemLoad / CpuLoad / MemUsageMB / NetworkUsageRate: Resource performance metrics
LastActivityDate: Last time VM activity was recorded

If you’d like to fine-tune the query further, please feel free to contact me with your specific requirements, and I’ll be happy to assist you.

Regards,
Pratik Jajal