→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
TekTok
Engaged Sweeper II
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.
1 ACCEPTED SOLUTION
Tom_P
Lansweeper Employee
Lansweeper Employee
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]

View solution in original post

2 REPLIES 2
Tom_P
Lansweeper Employee
Lansweeper Employee
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
Champion Sweeper III
see this post it might help....

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

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now