Create a report showing ubuntu/linux VM assets

[EricCao]

Hi, 

We need to create a report showing all Ubuntu or Linux VMs (we use Hyper-V) and their assigned # of vCPU, RAM and disk volume usage (total vs free).

I was able to create a report for Windows VMs, but for Linux it seems completely different.

I tried below but still no luck. Appreciate your help!!

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblLinuxSystem.OperatingSystem,
  Cast(Round(tblLinuxVolumeGroup.Size / 1024.0, 0) As Int) As
  [Total Disk Space (GB)],
  Cast(Round(tblLinuxVolumeGroup.Free / 1024.0, 0) As Int) As
  [Free Disk Space (GB)]
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
  Inner Join tblLinuxVolumeGroup On
      tblAssets.AssetID = tblLinuxVolumeGroup.AssetID
Where tblAssetCustom.State = 1