PRUEBA AHORA

Network Adapter Speed

Hardware Hardware Components Network

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

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

Show

Hide