Add connected switch name and port number to report

[studerje]

Here's what I have so far. This report shows me the details I need about the device.
Now I'd like to add the switch and port number on the switch to the device. We already have LanSweeper collecting SNMP info from the switches.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Firstseen,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.Model = 'CP-7911G' And tblAssetCustom.State = 1

[Susan_A · Accepted solution]

There's a sample report in our Report Center for this. You can find it here.