cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
rog1039
Engaged Sweeper
Hello,

I'd like to include the connection information on the asset page. By asset page I mean the grid of asset information you are presented when you click on an asset type or an IP location. For example, I'd like to include the asset connection information as another column in the grid. See https://imgur.com/X9kKDJj for what I mean. Is that possible? It would be nice to add some other fields to the grid as well.

Related question: is it possible to show non-active assets on the asset grid page? Some toggle or something to enable that?

Thanks,
Paul
1 ACCEPTED SOLUTION
Esben_D
Lansweeper Employee
Lansweeper Employee
Unfortunately, the page you are referring to is non-customizable. To get the information you want on one page you will have to create a custom report.

Below you can find an example report, do note that the report below will only give back assets which have a connection to a switch.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysIPLocations.IPLocation,
tblAssetCustom.Location,
tblAssets.Domain,
tsysAssetTypes.AssetTypename,
tblAssets.IPAddress,
tsysAssetTypes.AssetTypeIcon10 As Icon,
tblSNMPAssetMac.AssetMacAddress,
tblAssets_1.AssetName As Switch,
tblSNMPInfo.IfIndex As Port,
tblAssets.Description,
tblAssets.Lastseen
From tsysAssetTypes
Inner Join tblAssets On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetMacAddress
On tblAssets.AssetID = tblAssetMacAddress.AssetID
Inner Join tblSNMPAssetMac On tblAssetMacAddress.Mac =
tblSNMPAssetMac.AssetMacAddress
Inner Join tblSNMPInfo On tblSNMPAssetMac.IfIndex = tblSNMPInfo.IfIndex And
tblSNMPAssetMac.AssetID = tblSNMPInfo.AssetID
Inner Join tblAssets tblAssets_1 On tblSNMPInfo.AssetID = tblAssets_1.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Order By tblAssets.AssetName

View solution in original post

2 REPLIES 2
rog1039
Engaged Sweeper
OK, thanks Charles!
Esben_D
Lansweeper Employee
Lansweeper Employee
Unfortunately, the page you are referring to is non-customizable. To get the information you want on one page you will have to create a custom report.

Below you can find an example report, do note that the report below will only give back assets which have a connection to a switch.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysIPLocations.IPLocation,
tblAssetCustom.Location,
tblAssets.Domain,
tsysAssetTypes.AssetTypename,
tblAssets.IPAddress,
tsysAssetTypes.AssetTypeIcon10 As Icon,
tblSNMPAssetMac.AssetMacAddress,
tblAssets_1.AssetName As Switch,
tblSNMPInfo.IfIndex As Port,
tblAssets.Description,
tblAssets.Lastseen
From tsysAssetTypes
Inner Join tblAssets On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetMacAddress
On tblAssets.AssetID = tblAssetMacAddress.AssetID
Inner Join tblSNMPAssetMac On tblAssetMacAddress.Mac =
tblSNMPAssetMac.AssetMacAddress
Inner Join tblSNMPInfo On tblSNMPAssetMac.IfIndex = tblSNMPInfo.IfIndex And
tblSNMPAssetMac.AssetID = tblSNMPInfo.AssetID
Inner Join tblAssets tblAssets_1 On tblSNMPInfo.AssetID = tblAssets_1.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Order By tblAssets.AssetName