Uplinks Audit

Find Uplink Network Interfaces

Lansweeper will automatically scan switches and devices' network interfaces, if more than 4 devices are connected to a single network interface, it will be considered an uplink network interface. However, if you want full exposure of all devices connected to network interfaces, you can change this in your settings to view all devices connected to network interfaces. The chart and report below provide a view of how many and which devices have a network interface that is considered an uplink. You can use this data divide whether you need to adjust your settings and find potential points where you could be getting more data. You can find more info about this use case in the Pro Tips 41 blog post.

Uplinks Audit Lansweeper Classic Query

Select Top 1000000 tblassets.AssetName,
tblassets.assetid,
Count(tblSNMPInfo.Uplink) As Uplinks
From tblSNMPInfo
Inner Join tblassets On tblSNMPInfo.assetid = tblassets.AssetID
Where tblSNMPInfo.Uplink = 1
Group By tblassets.AssetName,
tblassets.assetid

Uplinks Chart Audit Lansweeper Classic Query

select tblassets.AssetName,
Count(tblSNMPInfo.Uplink) as Uplinks
from tblSNMPInfo
inner join tblassets on tblSNMPInfo.assetid = tblassets.AssetID
where Uplink = 1
group by tblassets.AssetName