→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
jwaldeck
Engaged Sweeper
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!
1 REPLY 1
RCorbeil
Honored Sweeper II
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