Notification

Icon
Error

All USB devices connected - Need a report to any usb device connected to any system on the network

Posted: Monday, July 6, 2020 5:27:47 PM(UTC)
earmor

earmor

Member Original PosterPosts: 2
0
Like
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?
RC62N
#1RC62N Member Posts: 450  
posted: 7/6/2020 6:40:58 PM(UTC)
Add tblUSBDevices to your report, then pick the fields from that table that you want to see. E.g.
Code:
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%'
earmor
#2earmor Member Original PosterPosts: 2  
posted: 7/7/2020 1:35:37 PM(UTC)
Thank you, this has helped tremendously

Active Discussions

Lansweeper Help Desk Workflow
by  lswanson   Go to last post Go to first unread
Last post: Yesterday at 11:12:21 PM(UTC)
Lansweeper Changing to remote scanning due to COVID
by  FrankSc  
Go to last post Go to first unread
Last post: Yesterday at 9:35:26 PM(UTC)
Lansweeper Not giving hackers the Domain Admin password / account
by  FrankSc   Go to last post Go to first unread
Last post: Yesterday at 9:27:13 PM(UTC)
Lansweeper LsAgent failing - Lansweeper SSL Expired
by  lansweeper25t34  
Go to last post Go to first unread
Last post: Yesterday at 8:33:28 PM(UTC)
Lansweeper Is there a chance to get the firewall off via Lansweeper?
by  EDV_OHZ   Go to last post Go to first unread
Last post: Yesterday at 4:57:26 PM(UTC)
Lansweeper Merge Asset button
by  KeithBecker  
Go to last post Go to first unread
Last post: 8/5/2020 9:27:54 PM(UTC)
Lansweeper Merge Two Assets or Update Based on Serial Number
by  KeithBecker   Go to last post Go to first unread
Last post: 8/5/2020 9:25:16 PM(UTC)
Lansweeper Hyper-V guest assets
by  bgstein  
Go to last post Go to first unread
Last post: 8/5/2020 5:50:24 PM(UTC)