Network Interfaces Report

[jetb2]

I'm trying to pull a report from a switch so we can see what's connected to each interface. I can see MAC addresses and PC names in the asset column of the switch but when I pull a report it only shows me the PC names and not the MAC addresses (these are VOIP phones) that I really want.

This is my first question here so let me know if I'm not clear and...be gentle.

[Andy_Sismey]

Hi Jim, give this report a go and let me know if this close to what your after ?

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssetCustom.Printedpages,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  tblAssetCustom.Custom1,
  tblSNMPInfo.IfIndex As Interface,
  tblSNMPInfo.IfDescription As Name,
  tblSNMPIfTypes.IfTypename As Type,
  tblSNMPInfo.IfAdminstatus As Admin,
  tblSNMPInfo.IfMTU As MTU,
  Ceiling(tblSNMPInfo.IfSpeed / 1000 / 1000) As Speed,
  tblSNMPInfo.IfIPAddress As IP,
  tblSNMPInfo.IfMask As Mask,
  tblSNMPInfo.IfMacaddress As MAC
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblSNMPInfo On tblAssets.AssetID = tblSNMPInfo.AssetID
  Inner Join tblSNMPIfTypes On tblSNMPIfTypes.IfType = tblSNMPInfo.IfType
Where tblAssetCustom.State = 1

[george29]

is there a way to add the connected device (with hyperlink) on the switch port to the report