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:
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.
