Jetzt Ausprobieren

Assets and the Switch They’re Connected To

Hardware Network Devices Relations

Get a List of All Network Devices and the Switch They Are Connected To

This report allows you to easily map your network by providing a list of assets alongside the switch and the port on that switch they are connected to. Never again waste long periods of time finding which switch each device is connected to. If you want to report on the reverse, switches and the assets that are connected to them, you can use the Switch Ports Report.

 

Assets and the Connected Switch Query

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblSNMPInfo.ifAlias,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As Icon,
tblSNMPAssetMac.AssetMacAddress,
tblAssets_1.AssetName As Switch,
tblSNMPInfo.IfIndex As Port
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
Order By tblAssets.AssetName

Show

Hide