10-01-2020 11:42 AM
10-09-2020 10:50 AM
10-08-2020 05:26 PM
Dannnnooo wrote:
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!
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
10-08-2020 02:22 PM
Dannnnooo wrote:
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!
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now