Computer USB Ports

List All USB Ports In Your Network

Get an audit of all the USB ports on the computers in your network. This report provides a list of each USB port found on your computers, allowing you to see exactly how many USB ports are available on each computer in your network.

Computer USB Ports Query

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblPortConnector.ExternalReferenceDesignator,
  tblPortConnector.InternalReferenceDesignator,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  tsysIPLocations.IPLocation,
  tsysOS.OSname As OS,
  tblAssets.SP As SP,
  tblAssets.Firstseen,
  tblAssets.Lastseen
From tblAssets
  Inner Join tblPortConnector On tblAssets.AssetID = tblPortConnector.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Where tblAssetCustom.State = 1 And tblPortConnector.PortType = 16
Order By tblAssets.AssetName