cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
kevinoie
Engaged Sweeper III
Hi. Im running the below report to get a list of all my servers. Some are physical and some are Virtual. Is there any way I can add what virtual host my virtual servers are on to the end of this? I have tried by adding the tblHyperVGuest table but its not giving me the information im looking for.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tsysOS.OSname,
tblAssets.SP,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Memory,
tblComputersystem.Lastchanged,
tsysOS.Image As icon,
tblAssets.IPAddress
From tblComputersystem
Inner Join tblAssets On tblComputersystem.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblComputersystem.Domainrole > 1 And tblAssetCustom.State = 1


Any help would be very much appreciated.

Kevin.
1 REPLY 1
Hemoco
Lansweeper Alumni
Our apologies, this thread appears to have been overlooked. The report below should work.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tsysOS.OSname,
tblAssets.SP,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Memory,
tblComputersystem.Lastchanged,
tsysOS.Image As icon,
tblAssets.IPAddress,
tblAssets1.AssetName As HyperVhost,
tblAssets1.Domain As HyperVhostdomain
From tblComputersystem
Inner Join tblAssets On tblComputersystem.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tblHyperVGuest On tblHyperVGuest.Name = tblAssets.AssetName
Left Join tblAssets tblAssets1 On tblAssets1.AssetID = tblHyperVGuest.AssetID
Where tblComputersystem.Domainrole > 1 And tblAssetCustom.State = 1