Modify Asset Page

[rog1039]

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

[rog1039]

OK, thanks Charles!

[Esben_D · Accepted solution]

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