cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
b8rtm8nn
Engaged Sweeper III
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
1 ACCEPTED SOLUTION
Jeremy_D
Champion Sweeper
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

View solution in original post

2 REPLIES 2
b8rtm8nn
Engaged Sweeper III
Perfect - thanks!
Jeremy_D
Champion Sweeper
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