USB device report

[TekTok]

Looking through past questions and answers, it appears that with Version 6, Lansweeper can now scan USB devices?
The data appears to be there on the assets, but not sure how to report it out. How could I report for all USB devices plugged into all computers? Even if I'd have to filter out specific devices or types, this would be very useful.
No SQL yet. Thanks in advance.

[Tom_P · Accepted solution]

Similar to the linked report by AZHockeyNut, the following report will list all USB devices that were connected while the asset was scanned. Additional columns or filters can of course still be added

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblUSBDevices.Name As [USB Device],
  tblUSBDevices.Manufacturer As [USB Device Manufacturer]
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
Order By tblAssets.AssetName, [USB Device]

[AZHockeyNut]

see this post it might help....

http://www.lansweeper.com/Forum/yaf_postst14377_Locally-Connected-Devices.aspx#post49461