Report with Monitor asset id

[jwaldeck]

Looking for a way to add the Lansweeper asset ID for monitors to a report. I'm importing these into our CMDB and have a link to open the asset page in Lansweeper, but it's importing the asset ID of the computer it is connected to, instead of its own. It's the asset ID present in the Lansweeper URL, ie. http://lansweeper2/asset.aspx?AssetID=51866. Thanks!

[RCorbeil]

Link the computer through tblAssetRelations to tblAssets and filter the linked asset for monitors.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblAssets1.AssetID AS MonitorAssetID,
  tblAssets1.AssetName AS MonitorAssetName
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblAssetRelations On tblAssets.AssetID = tblAssetRelations.ParentAssetID
  Inner Join tblAssets tblAssets1 On tblAssets1.AssetID = tblAssetRelations.ChildAssetID
  Inner Join tsysAssetTypes tsysAssetTypes1 On tsysAssetTypes1.AssetType = tblAssets1.Assettype And tsysAssetTypes1.AssetTypename = 'Monitor'
Where tblAssetCustom.State = 1