1 Reply Latest reply on May 19, 2010 9:11 AM by bshopp

    Report Writer not picking up the version number of ESX 4

    lchance

      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

        • Re: Report Writer not picking up the version number of ESX 4
          bshopp

          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