Assets that aren't VMs (see towards the bottom if you need to add something, for example Xen, Hyper-V).
Select Top (1000000) tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Mac,
tblAssetCustom.Serialnumber,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssetCustom.Manufacturer,
tblAssetCustom.Contact,
tblAssetCustom.Model,
tblAssets.Description,
tblAssets.Processor,
tblAssets.Memory,
tblLinuxSystem.OSRelease,
tblLinuxSystem.OperatingSystem,
tblMacOSInfo.SystemVersion,
tblOperatingsystem.Caption
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
Left Join tblMacOSInfo On tblAssets.AssetID = tblMacOSInfo.AssetID
Left Join tblOperatingsystem On tblAssets.AssetID = tblOperatingsystem.AssetID
Where tblAssetCustom.Manufacturer Not In ('oVirt') And
tblAssetCustom.Model Not In ('KVM', 'VMware Virtual Platform') And
tblAssetCustom.State = 1
