Notification

Icon
Error

Show attached USB devices - Any attached USB Devices show in LAN Sweeper

Posted: Thursday, October 1, 2020 10:42:17 AM(UTC)
Dannnnooo

Dannnnooo

Member Original PosterPosts: 3
2
Like
Due to COVID and sending equipment home, we need to track & run reports for users who have USB Headsets, USB Webcams, etc etc plugged in to their work issued home devices.

I have seen a few people ask questions if USB devices can be detected & i think this would be an extremely useful feature/selling point!
Csteenhaut
#1Csteenhaut Member Posts: 2  
posted: 10/8/2020 1:22:35 PM(UTC)
Originally Posted by: Dannnnooo Go to Quoted Post
Due to COVID and sending equipment home, we need to track & run reports for users who have USB Headsets, USB Webcams, etc etc plugged in to their work issued home devices.

I have seen a few people ask questions if USB devices can be detected & i think this would be an extremely useful feature/selling point!


I can only agree with this, it's a glaring problem with Lansweeper that it doesn't do this OOTB as of now.
With the current Corona crisis, this has become of paramount importance to our company!
Brandon
#2Brandon Member Posts: 48  
posted: 10/8/2020 4:26:27 PM(UTC)
Originally Posted by: Dannnnooo Go to Quoted Post
Due to COVID and sending equipment home, we need to track & run reports for users who have USB Headsets, USB Webcams, etc etc plugged in to their work issued home devices.

I have seen a few people ask questions if USB devices can be detected & i think this would be an extremely useful feature/selling point!



Try this report:
I have edited the report

Quote:
Select Distinct tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tsysAssetTypes.AssetTypename,
tblAssetCustom.Serialnumber,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblUSBDevices.Name,
tblUSBDevices.Manufacturer,
tblUSBDevices.DeviceID
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
Inner Join web50repwinusbdevices On tblUSBDevices.AssetID =
web50repwinusbdevices.AssetID And
tblAssets.AssetID = web50repwinusbdevices.AssetID
Where tblUSBDevices.Name Not Like '%mouse%' And tblUSBDevices.Name Not
Like '%keyboard%' And tblUSBDevices.Name Not Like 'usb root hub' And
tblUSBDevices.Name Not Like 'generic usb hub' And
tblUSBDevices.Name Not Like '%usb root hub%' And
tblUSBDevices.Name Not Like 'usb composite device' And
tblUSBDevices.Name Not Like '%hid-compliant%' And
tblUSBDevices.Name Not Like 'usb input device' And
tblUSBDevices.Name Not Like 'Generic SuperSpeed USB Hub' And
tblUSBDevices.Name Not Like 'Intel(R) USB 3.0 Root Hub' And
tblUSBDevices.Name Not Like 'VMware USB Pointing Device' And
tblUSBDevices.Name Not Like 'usb printing support' And tblAssetCustom.State =
1
Dannnnooo
#3Dannnnooo Member Original PosterPosts: 3  
posted: 10/9/2020 9:50:50 AM(UTC)
Thanks Brandon.

That worked a treat. I actually realised LS has built in report that does pretty much the same thing. But iv customised the tables to elviate allot of the noise.

One quick other question. i dont suppose you know how to show (Dell) Thunderbolt docks do you?

Active Discussions

Lansweeper License renewal - but why
by  mrusso   Go to last post Go to first unread
Last post: Yesterday at 5:01:47 PM(UTC)
Lansweeper Deployment Package Error Message
by  Brandon  
Go to last post Go to first unread
Last post: Yesterday at 2:04:25 PM(UTC)
Lansweeper Asset Type Mail Server
by  MarkPayton   Go to last post Go to first unread
Last post: Yesterday at 1:03:54 PM(UTC)
Lansweeper Upgrade Win 10 build to version 2004
by  Jean-FB  
Go to last post Go to first unread
Last post: 10/28/2020 7:34:29 PM(UTC)
Lansweeper Uptime only shows Standby
by  Gst4r   Go to last post Go to first unread
Last post: 10/28/2020 4:19:33 PM(UTC)
Lansweeper Excepciones
by  Pablo  
Go to last post Go to first unread
Last post: 10/27/2020 7:35:21 PM(UTC)
Lansweeper Help desk API
by  Skylar@Hennig   Go to last post Go to first unread
Last post: 10/27/2020 5:01:18 PM(UTC)
Lansweeper Helpdesk API
by  Skylar@Hennig  
Go to last post Go to first unread
Last post: 10/27/2020 4:44:50 PM(UTC)