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

    Orion Report Writer / Virtual Machine information


      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.ProcessorCount AS CPU_Count,




      VirtualMachines.NodeID AS NodeID_1



      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.