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