CrowdStrike Update Causes BSOD Issues Globally – Audit Available 🛡️ Learn more

TRY NOW

Uplinks Audit

Network

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 report example

Uplinks Audit Lansweeper Classic Query

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

Show

Hide

NO CREDIT CARD REQUIRED

Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.