cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cctech
Engaged Sweeper II
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.

usb keyboards
2 REPLIES 2
cctech
Engaged Sweeper II
Thanks, this will help.
RCorbeil
Honored Sweeper II
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.)

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now