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.
To use this in a chart widget, prefix the report name with «Chart:» and select it in the chart report widget found on a dashboard.
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
Uplinks Chart 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
