2 weeks ago
I need to do an inventory of all the USB attached bar code scanners but despite my research on the internet and in the community, I cannot find whether Lansweeper provide a way to do it, except for a post dating 2019 with a solution that won't work. What about you guys? Do you know how to run a report to do that?
Solved! Go to Solution.
2 weeks ago
Sadly, as far as I'm aware, there isn't a way for Lansweeper to obtain the serial number.
I saw you replied to someone else about not seeing the device under Config>Hardware>USB Devices. Are you sure the asset you're checking is one that definitely had the scanner plugged in when Lansweeper last scanned it? If the answer is yes and you still don't see anything to identify it under the USB Devices section such as an accurate device name, then I don't think you'll be able to leverage Lansweeper for those scanners at all.
I was lucky enough that our webcams populated with an accurate name so that I could just take a count of all USB devices with a name that starts with X.
2 weeks ago - last edited 2 weeks ago
Do you see bar code device on Asset-Config-Hardware-USB Devices page?
Post screenshot.
2 weeks ago
No I don't.
2 weeks ago
I think there is no solution...
2 weeks ago
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblUSBDevices.Name,
tblUSBDevices.Manufacturer,
tblUSBDevices.DeviceID,
tblAssets.Lastseen,
tblUSBDevices.LastChanged,
tblAssets.OScode
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 tblUSBDevices.Name like '%your_device_or_device_type%' And
tblAssetCustom.State = 1
Order By tblAssets.AssetName
2 weeks ago
Hello,
I've created a report for USB attached webcams once. However, my objective was simply to find out what devices have webcams connected to them (which you could also use to get a total count of webcams).
Is your objective similar, or do you need to obtain additional information for the scanners such as serial numbers?
2 weeks ago
I certainly need to the serial number. The model and make would be very nice to have.
2 weeks ago
Sadly, as far as I'm aware, there isn't a way for Lansweeper to obtain the serial number.
I saw you replied to someone else about not seeing the device under Config>Hardware>USB Devices. Are you sure the asset you're checking is one that definitely had the scanner plugged in when Lansweeper last scanned it? If the answer is yes and you still don't see anything to identify it under the USB Devices section such as an accurate device name, then I don't think you'll be able to leverage Lansweeper for those scanners at all.
I was lucky enough that our webcams populated with an accurate name so that I could just take a count of all USB devices with a name that starts with X.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now