Report Writer not picking up the version number of ESX 4

Question

Is this a bug? When generating a report on all ESX systems it will not display the version number of ESX 4 systems but it will version 3.0 through 3.5   SELECT  TOP 10000 Nodes.IOSVersion AS IOS_Version, Nodes.Caption AS NodeName, Nodes.CPULoad AS CPULoad, Nodes.TotalMemory AS TotalMemory, Nodes.PercentMemoryUsed AS PercentMemoryUsed, VirtualMachines.DisplayName AS DisplayName FROM VirtualMachines INNER JOIN Nodes ON (VirtualMachines.HostNodeID = Nodes.NodeID) WHERE  (   (Nodes.Caption LIKE 'myvmware-%') )   ORDER BY 2 ASC

bshopp · Accepted Answer

In 10 we are storing the ESX details in a different table, try this query instead

SELECT TOP 10000

VMHostNodes.VMwareProductVersionAS IOS_Version,

Nodes.Caption AS NodeName,

Nodes.CPULoad AS CPULoad,

Nodes.TotalMemory AS TotalMemory,

Nodes.PercentMemoryUsedAS PercentMemoryUsed,

VirtualMachines.DisplayNameAS DisplayName

FROM VirtualMachines

INNER JOIN VMHostNodes ON (VMHostNodes.NodeID =VirtualMachines.HostNodeID)

INNER JOIN Nodes ON (VirtualMachines.HostNodeID = Nodes.NodeID)

WHERE

(

(Nodes.CaptionLIKE 'myvmware-%')

)

ORDER BY 2 ASC