→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎06-12-2024 09:15 PM
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.
‎06-13-2024 03:05 PM
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.
‎06-13-2024 08:26 AM - edited ‎06-13-2024 09:52 AM
Do you see bar code device on Asset-Config-Hardware-USB Devices page?
Post screenshot.
‎06-13-2024 01:13 PM
No I don't.
‎06-13-2024 01:27 PM
I think there is no solution...
‎06-13-2024 05:18 AM
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
‎06-12-2024 11:43 PM
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?
‎06-13-2024 01:15 PM
I certainly need to the serial number. The model and make would be very nice to have.
‎06-13-2024 03:05 PM
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