USB Device (Specific Manufacturer)?

[CHRLAU]

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.

[CHRLAU]

Thank you very much "Mister Nobody" I got to learn how to make my own reports. Any good guides to start with?

[Mister_Nobody]

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]

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