Network adapter speed

[Susan_A]

The report below lists your Windows computers' network adapter speed. Keep in mind that this information is pulled from the Win32_NetworkAdapter WMI (Windows Management Instrumentation) class, which only exists in Windows Vista and higher. As a result, NIC speed will only be available for Windows Vista and more recent operating systems.

The report will only list assets that meet all of the following criteria:

• The asset is a Windows computer.
  
• The computer's state is set to "active".
  
• The computer has been successfully scanned at least once.
  
• The computer is running Windows Vista or a more recent operating system.

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysOS.OSname As OS,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblNetworkAdapter.Name As NIC,
  tblNetworkAdapter.NetConnectionID As Connection,
  tblNetworkAdapter.MACAddress,
  tblNetworkAdapter.Speed As SpeedInMb
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblNetworkAdapter On tblAssets.AssetID = tblNetworkAdapter.AssetID
Where tsysOS.OSname Not Like '%win 2003%' And tblAssetCustom.State = 1
  And tblNetworkAdapter.NetEnabled = 1
Order By tblAssets.Domain,
  tblAssets.AssetName,
  NIC