Export either URL to asset or assetID as text

[b8rtm8nn]

In our procurement database, we want to add links to specific assets in Lansweeper, but I cannot find a way to export the actual link paths or even just the assetID (and we can construct the path ourselves). Is this possible?

Example: https://<our server>/asset.aspx?AssetID=3659 or '3659'

Thanks,
Bart

[b8rtm8nn]

Perfect - thanks!

[Jeremy_D · Accepted solution]

Asset IDs are stored in the AssetID field of the tblAssets database table. You just need to assign an alias to the field. Otherwise it will be filtered automatically from your report results. We included a sample report below that displays the complete asset URLs in a separate column, by combining your main web console URL and the asset IDs.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  'http://<Lansweeper server name>:<port>/asset.aspx?AssetID=' + Cast(tblAssets.AssetID As
  nvarchar) As URL
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.State = 1
Order By tblAssets.IPNumeric,
  tblAssets.AssetName