List the Speed of All Network Adapters or Nics in Your Network
This report provides a detailed overview of all your network adaptors and their speed. Determine which devices are ready for higher speed network connections and which ones are not. Find possible network interface controller upgrade candidates without having to do elaborate tests or checking computers one by one.
Network Adapter Speed Query
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblNetworkAdapter.Name As NetworkAdapter,
tblNetworkAdapter.Manufacturer As AdapterManufacturer,
tblNetworkAdapter.MACAddress,
tblNetworkAdapter.Speed As BitsPerSecond,
tblNetworkAdapter.NetConnectionID As ConnectionID,
tblNetworkAdapter.Lastchanged As LastChanged
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblNetworkAdapter On tblAssets.AssetID = tblNetworkAdapter.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblState.Statename = 'Active' And Case tblNetworkAdapter.NetEnabled
When 0 Then 'No'
When 1 Then 'Yes'
End = 'Yes'
Order By tblAssets.Domain,
tblAssets.AssetName,
NetworkAdapter
