All USB devices connected

[earmor]

Hello, I am new to Lansweeper so I apologize in advance if this has already been answered. I need to run a report for ever usb device that is connected to a system on out network. The only exclusion would be mice and keyboards. I could not find how to run the report or create it, could you help me please?

[earmor]

Thank you, this has helped tremendously

[RCorbeil]

Add tblUSBDevices to your report, then pick the fields from that table that you want to see. E.g.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblUSBDevices.Name,
  tblUSBDevices.Manufacturer
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblUSBDevices On tblAssets.AssetID = tblUSBDevices.AssetID
Where
  tblAssetCustom.State = 1
  AND tblUSBDevices.Name NOT LIKE '%mouse%'
  AND tblUSBDevices.Name NOT LIKE '%keyboard%'