HyperV Report not showing Guest OS

[tmui]

Hi, I have modified the default HyperV report, but can't seem to pull the Guest OS in my query. What am I missing?

TIA,
Tim

Select Top 1000000 tblAssets.AssetName As [Host Server],
  tblAssets.IPAddress As [Host IP],
  tsysOS.OSname As [Host OS],
  tblHyperVGuest.Name As [Guest Server],
  tblHyperVGuest.Memory,
  tsysOS.Image As icon,
  tsysOS1.OSname As [Guest OS],
  tblAssets1.IPAddress As [Guest IP],
  tblAssets1.NrProcessors As [# of Processors],
  TblHyperVGuestNetwork.MacAddress As [Guest MAC]
From tblAssets
  Inner Join tblHyperVGuest On tblAssets.AssetID = tblHyperVGuest.AssetID
  Inner Join TblHyperVGuestNetwork On tblHyperVGuest.hypervguestID =
    TblHyperVGuestNetwork.HyperVGuestID
  Left Join tblAssets tblAssets1
    On tblAssets1.Mac = TblHyperVGuestNetwork.MacAddress
  Left Join tsysOS tsysOS1 On tblAssets1.AssetName = tsysOS.OSname
Order By [Host Server],
  [Guest Server]

[tmui · Accepted solution]

I figured it out.

Line 17 should have been

 Left Join tsysOS tsysOS1 On tblAssets1.OScode = tsysOS1.OScode