→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
CHRLAU
Engaged Sweeper III
Could someone pls. help me with a report that shows all "USB Devices" from a specific manufactuer?

The place I can find the info manually is by choosing a asset (PC) and then Config->Hardware -> USB Devices
And then the first column hold the name of the Manufacturers name.

Would be nice if the report had at least the hostname of the client pc, name of std. user, Name of the device from the specific Manufacturer fx. (3Dconnexion) and may also the device ID.



3 REPLIES 3
CHRLAU
Engaged Sweeper III
Thank you very much "Mister Nobody" I got to learn how to make my own reports. Any good guides to start with?
Mister_Nobody
Honored Sweeper II
With set of filters
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblUSBDevices.Name,
tblUSBDevices.Manufacturer,
tblUSBDevices.DeviceID,
tblAssets.Lastseen,
tblAssets.Lasttried
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 Not Like N'%HID%' And tblUSBDevices.Name Not Like '%hub%'
And tblUSBDevices.Name Not Like '%generic%' And
tblUSBDevices.Name Not Like
'%printing support%' And
tblUSBDevices.Name Not Like '%mouse%' And tblUSBDevices.Name Not Like
'%keyboard%' And tblUSBDevices.Name Not Like '%USB Composite Device%' And
tblUSBDevices.Name Not Like '%USB Pointing Device%' And
tblUSBDevices.Name Not Like '%USB Input Device%' And
tblUSBDevices.Name Not Like '%USB Human Interface Device%' And
tblAssetCustom.State = 1
Order By tblAssets.AssetName
Mister_Nobody
Honored Sweeper II
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblUSBDevices.Name,
tblUSBDevices.Manufacturer,
tblUSBDevices.DeviceID,
tblAssets.Lastseen,
tblAssets.Lasttried
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 tblAssetCustom.State = 1