Finding Computers with multiple keyboards (bar-code scanners)

[cctech]

I would like to run a report to find devices with bar-code scanners attached to them. The problem is that most bar code scanner appear to the system as a keyboard. I would like to run a report for devices with more then 1 usb keyboad attached. This will not be exact but will give an ballpark of how many bar-code scanners or at least eliminate devices that do not have them.

[cctech]

Thanks, this will help.

[RCorbeil]

Quick & dirty:

Select Top 1000000
  tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  (Select COUNT(*)
   From tblUSBDevices
   Where
     tblUSBDevices.AssetID = tblAssets.AssetID
     And tblUSBDevices.Name Like '%keyboard%'
     And tblUSBDevices.Name Not Like '%Bluetooth%') As USBkeyboards
From
  tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where
  tblAssetCustom.State = 1
  AND (Select COUNT(*)
       From tblUSBDevices
       Where
         tblUSBDevices.AssetID = tblAssets.AssetID
         And tblUSBDevices.Name Like '%keyboard%'
         And tblUSBDevices.Name Not Like '%Bluetooth%') > 1

(I spotted a few Bluetooth keyboards in my inventory when I tested and assumed those would be of no interest to you.)