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