report asset name link

[danielm]

Hi,
Is it possible to have a report , like bellow , but have the names of the associated Virtual machines (whcih are also scanned by lansweeper) have a live link that pops up info just like the main host server in the lansweeper report.

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

[Hemoco · Accepted solution]

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.

[danielm]

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.

thank you . so no LINK on the guest name to open up the associated page 😞