‎09-16-2014 09:42 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tsysOS.OSname,
tblHyperVGuest.Name As Guest,
tblHyperVGuest.Memory,
tblHyperVGuest.Enabledstate,
tblHyperVGuest.Healthstate,
tblHyperVGuest.Lastchanged,
tsysOS.Image As icon
From tblAssets
Inner Join tblHyperVGuest On tblAssets.AssetID = tblHyperVGuest.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Order By tblAssets.AssetName
Solved! Go to Solution.
‎09-17-2014 09:42 PM
‎09-17-2014 09:42 PM
‎09-18-2014 12:50 AM
Lansweeper wrote:
This is not possible you can only link one column to an asset in a report. It is not possible to also map the guest to an asset page.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now