→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
earmor
Engaged Sweeper
Hello, I am new to Lansweeper so I apologize in advance if this has already been answered. I need to run a report for ever usb device that is connected to a system on out network. The only exclusion would be mice and keyboards. I could not find how to run the report or create it, could you help me please?
2 REPLIES 2
earmor
Engaged Sweeper
Thank you, this has helped tremendously
RCorbeil
Honored Sweeper II
Add tblUSBDevices to your report, then pick the fields from that table that you want to see. E.g.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblUSBDevices.Name,
tblUSBDevices.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
AND tblUSBDevices.Name NOT LIKE '%mouse%'
AND tblUSBDevices.Name NOT LIKE '%keyboard%'