0 Replies Latest reply on Apr 2, 2012 1:13 PM by Number0ne

    Orion Report Writer / Virtual Machine information

    Number0ne

      I'm trying to run a SQL report in Report Writer that gives me:

       

      ESX Server Host NameOrion

      CPU Count

      Memory Allocation

      Hard Drive allocation

       

      This is what I've written so far:

      SELECT  TOP 10000 Nodes.Caption AS NodeName,

      VirtualMachines.Name,

      VirtualMachines.ProcessorCount AS CPU_Count,

      VirtualMachines.MemoryConfigured,

      Volumes.VolumeDescription,

      Volumes.VolumeSize,

      VirtualMachines.NodeID AS NodeID_1

       

      FROM

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

      INNER JOIN Volumes ON Volumes.NodeID = VirtualMachines.HostNodeID

       

      Which gives me:

      4-2-2012 12-12-42 PM.png

       

      The problem is, I want total allocation of Hard Drive space for the Virtual Machine, not space that's used (Which is accurate, it's just split up). If the hard drive is 40gb I want 40gb's to show in one line as opposed to many.

       

      Any assistance? My SQL knowledge is limited so this is what I pieced together with the help of code snippets and limited knowledge, but I didn't know if there was a different table I need to be extracting information from or not.